This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am very new to Qlikview
Is there any way to find the last used row in a given column of excel sheet by using the Qlikview macro I used several VBA code as well as the vbscript codes
some of them are listed below but none of them worked
Please help me
In vbscript you don't have direct access to the excel enumerations, so xlUp can't be used. Try its value -4162 instead:
ExcelWB.Activesheet.Range("A65536").End(-4162).Row to find the last row in column A.
Edit: There's a list of enumerations on msdn. Or you can look them up in the object browser of the vba ide of excel.
View solution in original post
Thankyou it's working fine
can you please let me know how i could get to know all such enumerations for Qlikview Macro's please ....
Can you help me in finding last column in a given row
below code is throwing some error
myCol = Obj_XLTemplate.worksheet("sheet1").Range("A1").End(-4161).Column
Can you tel me how I can put my data in the first empty column.
When I replace intExcelLastColumn by a number the code works fine.
Thanks in advance.
Is there also a way to look for the last column in row 2.I have an Excel file with the headers already in row 1.
I tried with "A2" but with the same result as "A1"