Loading Excel Binary File in Qlikview ( Missing ROWS )

lakshmanvepuri — Sat, 16 Nov 2024 18:38:41 GMT

Hi ,

I have Excel Binary File with huge volume of data. A, B, C, D, ---->>>> KB and increases

While converting using the below code

ODBC CONNECT32 TO [ExcelSourceFiles;DBQ=$(vFolder)\vFile.xlsb];

TESTING:
SQL SELECT *
FROM `$(vFile)`.`Overall$`;

STORE TESTING INTO [C:\Temp\Desktop\TESTING.csv]( txt, delimiter is ',');

Missing out certain Headers some where around... BA---DD ( eg)

Anyone has this issue...

Second Method:

As the rows are missing I used this code as BATCH File and is working.

"C:\Program Files (x86)\Microsoft Office\Office16\excelcnv.exe" -oice C:\Temp\Desktop\TESTING_MAIN.xlsb C:\Temp\Desktop\TESTING.xlsx

I am looking for the Solution in Qlikview, So Just want to check can any one help.

Thanks

Vepuri

Re: Loading Excel Binary File in Qlikview ( Missing ROWS )

marcus_sommer — Thu, 14 May 2020 13:05:16 GMT

I use the same approach quite regularly to load from xlsb and hadn't ever had any issue that data wasn't loaded whereby our files are mostly rather small with around 30 - 50 columns and maybe 100 - 2000 records.

Because of the fact that the column KB is beyond of 256 it might be that you hit any limitation within the driver. Therefore you should try it with another one respectively with a 64bit one.

- Marcus

topic Re: Loading Excel Binary File in Qlikview ( Missing ROWS ) in QlikView

Loading Excel Binary File in Qlikview ( Missing ROWS )

Re: Loading Excel Binary File in Qlikview ( Missing ROWS )