topic Re: How convert xlsx to xls format? in QlikView

How convert xlsx to xls format?

vchuprina — Sun, 18 Oct 2015 14:14:09 GMT

Hi guys,

I want to ask, maybe anybody has macro that can convert xlsx files to xls.

Thanks,

Vitaliy

Re: How convert xlsx to xls format?

swuehl — Sun, 18 Oct 2015 14:27:45 GMT

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)

Re: How convert xlsx to xls format?

Anonymous — Sun, 18 Oct 2015 14:30:24 GMT

Hi,

Please can you elaborate on your requirement?

is there any specific reason you want to convert?

Regards

Neetha

Re: How convert xlsx to xls format?

evan_kurowski — Sun, 18 Oct 2015 15:09:21 GMT

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

Unlabelled field names use letters to designate columns
- Columns can exceed beyond 256 in count
Extension is ‘.xlsx’
Format is ‘ooxml’
Sheet names don’t append extra characters into sheet name

//.XLS format Excel 97 - 2003
LOAD @1,
@2,
@3
FROM
[MySpreadsheet.xls]
(biff, no labels, table is Sheet1$);

//.XLS

Unlabelled field names use ‘@#’ to designate columns
- Maximum amount of columns limited to 256
Extension is ‘.xls’
Format is ‘biff’
Sheet names append a ‘$’ at end of sheet name

Re: How convert xlsx to xls format?

vchuprina — Mon, 19 Oct 2015 10:35:39 GMT

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.