We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Xml Import unhides previously hidden columns in template

Posey.zip (5.5 MB)
I am importing xml into a template spreadsheet with an xml map. I’ve mapped the xml to cells and hidden one of the xml mapped cells (column B in this case).

When I import xml using Excel the column stays hidden however when using Aspose the column is shown again.

Please refer to the uploaded sample application. There is a data folder containing a template.xlsx and the xml.xml file to be imported.


Thanks for the sample project with template file.

Please notice, I am able to reproduce the issue as you mentioned by using your template file. I found xml import unhides previously hidden columns in the template file. If we do the same task in MS Excel manually, the hidden column remains hidden. I have logged a ticket with an id “CELLSNET-50507” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.


This is to notify you that your issue has been resolved. The fix will be included in our regular (upcoming) release: Aspose.Cells v22.3. You will also be notified in this thread when the next version is released.

Great thank you.


You are welcome.

The issues you have found earlier (filed as CELLSNET-50507) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi