[Excel Report] Some data are not filled in expected cells
Question
Forge component by Miguel Meireles

Dear Miguel,


I faced another problem when I am opening the exported excel file.

An alert likes 'We found a problem with some content in 'teste (16).xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.' was shown and after I clicked Yes to recover the file, some data are not filled in the expected cells.

You can reproduce this error with attachment sample oml file.  The page is 'ExcelDownload', and you check my data in both 'Download' and 'Downloadnoformattedcells' actions. I set the xml data directly to 'XmlData' variable.

For the result, after AB column(column name:TestColumn28, attribute name:JournalizeSourceName),  the data are all filled in wrong cells.

I am using version 10.

Could you please check this error?

Thank you very much.


Best Regards

Kiriya

ExcelErrorSample.oml

Hello Kiriya

I checked and saw that there was a wrong version in a library, it's changed in this version. Download

Best Regards
Miguel

Hello Kiriya,

There was a bug when there were more than 26 columns. I generated a new version for 10, I hope it works

Download

Best Regards

Miguel

Hello Miguel,


Thank you for your quick bug fix.

I tried to run the new extension, but it doesn't seem to work.

I got an alert message like 'Excel cannot open the file 'teste (21).xlsx' because 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.' when I open the exported excel file.

Could you please check it?

Thank you very much again.


Best regards,

Kiriya

Hello Kiriya

I checked and saw that there was a wrong version in a library, it's changed in this version. Download

Best Regards
Miguel

Hello Miguel,

I tested the new version, it is working well.

Thank you for your excellent support very much!

Best Regards

Kiriya


After reading about your query I think your Excel workbook is facing the cell overlapping issue. So why don’t you just try the given fixes which is beautifully explained in this post. i am pretty much sure that, your issue will get resolved after trying out these fixes.

source: Fix Excel Cells Overlapping

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.