excel app
-
hi all, im doing an application in which im reading an excel file,so i just want to count the number of rows and columns in excel file from the vb program .please help me with this. with regards, susa
-
hi all, im doing an application in which im reading an excel file,so i just want to count the number of rows and columns in excel file from the vb program .please help me with this. with regards, susa
Rowcount: numRows = xls.Worksheets(1).usedrange.rows.count Column Count: colRows = xls.Worksheets(1).usedrange.columns.count Here, xls is Excel Workbook Object which is declared as Dim xls as Excel.Workbook
-
Rowcount: numRows = xls.Worksheets(1).usedrange.rows.count Column Count: colRows = xls.Worksheets(1).usedrange.columns.count Here, xls is Excel Workbook Object which is declared as Dim xls as Excel.Workbook
i added this code but im getting error as property or method not supported help me hi to all with regards, susa