Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ajay3
Contributor
Contributor

convert the format of xls to xlsx of the files

I have multiple excel files in ".xls" format and I need to convert that files to ".xlsx" format. I had tried below method, but it is not working. As i am not able to open the new ".xlsx" file.

error : "the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

tfilelist --------------->tfilecopy

I have attached the screenshot of the tfilecopy config.

Can some one please let me know how to achieve this.

Labels (3)
1 Reply
Anonymous
Not applicable

why not use tfileinputexcel and tfileoutputexcel : on the input, you don't select xlsx format, on the output, you select it

tfileinputexcel (not xlsx) => tfileoutputexcel (xlsx)