Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vchuprina
Specialist
Specialist

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

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
4 Replies
swuehl
MVP
MVP

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
Not applicable

Hi,

Please can you elaborate on your requirement?

is there any specific reason you want to convert?

Regards

Neetha

evan_kurowski
Specialist
Specialist

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
Specialist
Specialist
Author

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.

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").