Export to XLS file: file format and extension don't match

(4) Share

Report

Posted on by Jesús García

557

Hi all, I am trying to export data to an xls file. It is supposed to export correctly but when I open the file I get the following message:

How can i fix this problem, because i would like to open the file without this warning and that the information is already structured without being divided by ‘,’.

To export im using this config variables:

Where stream is UnicodeEncoding

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (9)

Answers (1)

Martin Dráb 235,928 Most Valuable Professional on at

Like (0)

Report

Export to XLS file: file format and extension don't match

We'd need to know more about your scenario before we can suggest how to filter the entity data. Because it's a different topic than Export to XLS file: file format and extension don't match, please create a new thread and explain your requirements there.

Was this reply helpful? Yes No
Jesús García 557 on at

Like (1)

Report

Export to XLS file: file format and extension don't match

Thank you for your recommendations, i chose to try Data Entity, looking for examples on Internet, but most of them use DMF and well, the exportation works but I would like to know if I can, from an entity I create, use my queryRun to export the data based on the filters it has and then export it.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 235,928 Most Valuable Professional on at

Like (0)

Report
Export to XLS file: file format and extension don't match

What you should do depends on what you need to achieve. What is the actual business requirement?

You can't meaningfully generate files in the old Excel format, but you could use the new one (.xlsx). Nevertheless it would require throwing away your current solution and starting from scratch. The question is why you've written code for exporting CSV if you don't want CSV. Maybe you do want CSV and the idea of using XLS is a wrong one.

If you want to generate XLSX in F&O, you have two options:

The best approach would be using a data entity instead of writing your own export code. Then you can also change the format (CSV, Excel, XML...) by using a different configuration of your project, which gives you extra flexibility.

You can use EPPlus library to generate an Excel spreadsheet. For example:
using OfficeOpenXml; class TextWrapDemo { public static void main(Args _args) { using (System.IO.MemoryStream stream = new System.IO.MemoryStream()) { using (var package = new ExcelPackage(stream)) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1"); ExcelRange cell = worksheet.Cells.get_Item(1,1); cell.Value = 'abcd'; package.Save(); } File::SendFileToUser(stream, 'data.xlsx'); } } }

Was this reply helpful? Yes No
Jesús García 557 on at

Like (0)

Report

Export to XLS file: file format and extension don't match

So, knowing that I'm doing it wrong, how should I do it? If it is done differently, I don't know because I have always done it this way.

Was this reply helpful? Yes No
Martin Dráb 235,928 Most Valuable Professional on at

Like (0)

Report

Export to XLS file: file format and extension don't match

Your code creates a text file, not an .xls file. You won't change the format of data just by renaming the file.

Was this reply helpful? Yes No
Jesús García 557 on at

Like (0)

Report

Export to XLS file: file format and extension don't match

Well, when i open the xls file, i have this info:

When i was exporting in CSV extension the file was opened with the structured information, without the ‘,’, like this:

So, what i want to do is mantain the structure of second image but changing the extension from csv to xls.

And that is the code i developed to export csv file.

Was this reply helpful? Yes No
Martin Dráb 235,928 Most Valuable Professional on at

Like (0)

Report

Export to XLS file: file format and extension don't match

Please either confirm what data you have in the file or show us how you generate the file.

Was this reply helpful? Yes No
Jesús García 557 on at

Like (0)

Report

Export to XLS file: file format and extension don't match

Sorry, this comment is an error because in the past, i exported the files in csv extension but now i want to change it to xls

Was this reply helpful? Yes No
Martin Dráb 235,928 Most Valuable Professional on at

Like (0)

Report

Export to XLS file: file format and extension don't match

Your code comment says "Export csv file", while the extension is .xls, which are indeed two different things. Please confirm what data you have in the file.

Was this reply helpful? Yes No