next »

[Dani Vainstein]

how to count no. of cloumns in an excel sheet?

[Yuval Keren]

Code

GeSHi (qtp):

'This is a pure vbscript to get the no' of columns:



'Create an Excel Object model

Set ExcelFile = CreateObject("Excel.Application")

'You can set it to false as well

ExcelFile.Visible = true

'Open the Excel file

ExcelFile.Workbooks.Open "C:\Demo.xls"

'Get the 1st sheet (can be change to some other index number)

Set ExcelSheet = ExcelFile.Sheets.Item(1)

'Get the number of columns

Cols = ExcelSheet.UsedRange.Columns.Count



msgbox "No of Columns: " & Cols



Set ExcelSheet = nothing

ExcelFile.Quit

Set ExcelFile = nothing

 

Created by GeSHI 1.0.7.20

[Dani Vainstein]

Is the UsedRange property includes Empty String cells? or only unused cells?