Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I want to ask, maybe anybody has macro that can convert xlsx files to xls.
Thanks,
Vitaliy
That is more an MS Office related question, not really a QV topic.
But a quick search in the internet should give you some guidelines:
excel - Converting xlsx to xls using Microsoft Office Compitablity Pack's excelcnv - Stack Overflow
windows - Convert XLS to CSV on command line - Stack Overflow
(you should be able to adapt latter to XLSX and XLS file types easily)
Hi,
Please can you elaborate on your requirement?
is there any specific reason you want to convert?
Regards
Neetha
Hello Vitaliy,
From a QlikView perspective, here are some considerations when scripting between .XLSX & .XLS files. You have the option of converting the source spreadsheet in Excel between the older & newer format, but you also can load both types directly into QlikView.
//.XLSX
LOAD A,
B,
C
FROM
[MySpreadsheet.xlsx]
(ooxml, no labels, table is Sheet1);
//.XLSX
//.XLS format Excel 97 - 2003
LOAD @1,
@2,
@3
FROM
[MySpreadsheet.xls]
(biff, no labels, table is Sheet1$);
//.XLS
I receive files in xlsx format, when I try to process them by qlikview I receive error that files are not in expected format.
When I resaved files manually in xls format parser works correctly.