topic Number of exportet rows/columns in QlikView

Number of exportet rows/columns

Thu, 29 Oct 2009 14:33:02 GMT

Hi,

I'm exporting table charts to excel via macro. Is it possible to get the number of the exported rows and columns?
I'd like to do a specific cell formatting in the cells that contain data.

Thanks for your help

Aloah

Number of exportet rows/columns

Thu, 29 Oct 2009 15:50:46 GMT

Found the solution: XLSheet.Cells.SpecialCells(11).Row

🙂

Number of exportet rows/columns

Thu, 29 Oct 2009 16:21:46 GMT

Try it

sub ToExcel
........
iCol= XLSheet.UsedRange.Columns.Count
iRow = XLSheet.UsedRange.Rows.Count
Call RefToColl(iCol, sLett)
............
end sub

'*************************************************************************
'* Per calcolare ultima colonna in excel
'*************************************************************************
function RefToColl(iCol, sLett)
aCol1 = iCol
slett = ""
if icol > 26 then
aCol1 = iCol -26
sLett = "A"
end if
if icol > 52 then
aCol1 = iCol -52
sLett = "B"
end if
if icol > 78 then
aCol1 = iCol -78
sLett = "C"
end if
if icol > 104 then
aCol1 = iCol -104

sLett = "D"
end if
Slett = SLett + Chr(65 + ACol1 - 1)
MsgBox("columns " &Acol&" Lettera "&slett)
end Function

Ciao!

Daniela