file extension is not valid

Question

When using the RMB option Output to export selected lines to Excel produces a message when Excel opens ‘Error cannot open open the file ‘CustomerAnalysis 210818-102120.xlsx’ because the the file format or the file extension is not valid, Verify that the file has not been corrupted and that the file extension matches the format of the file. Click OK and excel is populated with the selected data. If exported as .xls the message return is slightly different ‘The File format and extension of CustomerAnalysis 210818-103355.xls’ don’t match. The file may be corrupted or unsafe. Unless you trust the source don’t open it. Di you want to open it anyway?

icon

Best answer by Adam Bereda 18 August 2021, 11:56

View original

Adam Bereda · Accepted Answer

Hi,I think IFS output produces text or csv file, and not .xls/.xlsx. Please check your output channel settings if you do not overwrite default file extension for file format.To avoid this message, you should use csv file with default extension and make either Excel default application to open csv files or indicate Excel as application to be opened for this output channel.

Dumeesha Wanigarathna · Answer

Hi @Istar,As @Adam Beredamentioned the solution id - 286561 confirm that. Adding below content for further clarificationRND resolution text of the above solution is below. :-The output channel allows a user to export files in four different formats: CSV, XML, Text, HTML. Anyof the above file formats can be saves with a custom extension. The custom extension has to be an alternative extension to the default extension set for the above 4 types (eg. For HTML, the default extension setis .HTM. A custom extension such as .HTML can be used. The file will still be a valid HTML file.).When a CSV type file is saved with a .XLSX format, Excel will treat it as an Excel Workbook. But the internal content of the file is not actually that of an Excel Workbook, hence Excel will display an error. Having an arbitrary custom extension does not mean that the file will be saved in the extension format. In Addition,it does not mean that it would be possible to open the file using an application that opens files with that extension.

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded