Forum Discussion
Ravik
11 years agoSuper Contributor
Yes Ryan Moran ,
I am agree with you, I have also implemented something in VBScript.
Payal,
If you want to get the row count from the excel sheet you can follow the below approach-
Set Exo=CreateObject("Excel.Application")
Set Wbo=Exo.WorkBooks.Open("Your Path")
Set Wso =Wbo.WorkSheets(1)
rowCount = Wso.usedrange.rows.count
Where -
Exo = Excel Object
Wbo = Workbook Object
Wso = Worksheet Object
I am agree with you, I have also implemented something in VBScript.
Payal,
If you want to get the row count from the excel sheet you can follow the below approach-
Set Exo=CreateObject("Excel.Application")
Set Wbo=Exo.WorkBooks.Open("Your Path")
Set Wso =Wbo.WorkSheets(1)
rowCount = Wso.usedrange.rows.count
Where -
Exo = Excel Object
Wbo = Workbook Object
Wso = Worksheet Object
Related Content
- 3 months agoMarius78
- 7 years agoCapricornus
Recent Discussions
- 7 hours agomegha_phophalia
- 2 days agomegha_phophalia
- 6 days agoAndiiiA