Discussion Board for collaboration on QlikView Scripting.
Is it possible to find out the number of columns present in an excel sheet in the script?
In the script after you've loaded the excel file then use NoOfFields() function'
So in script below, vFieldNo in UI will give you the number of columns in excel.
LET vFieldNo = NoOfFields('MyTable');
You can use :
RecNo() as RawNo.
will return the number of column last loaded in the table