Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vchuprina
New Contributor III

How convert xlsx to xls format?

Hi guys,

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


Thanks,

Vitaliy

4 Replies
MVP
MVP

Re: How convert xlsx to xls format?

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)

neetha_p
Honored Contributor

Re: How convert xlsx to xls format?

Hi,

Please can you elaborate on your requirement?

is there any specific reason you want to convert?

Regards

Neetha

evan_kurowski
Valued Contributor

Re: How convert xlsx to xls format?

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
New Contributor III

Re: How convert xlsx to xls format?

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.