How convert xlsx to xls format?

[vchuprina]

Hi guys,

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

Thanks,

Vitaliy

[swuehl]

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)

[Anonymous]

Hi,

Please can you elaborate on your requirement?

is there any specific reason you want to convert?

Regards

Neetha

[evan_kurowski]

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

[vchuprina]

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.