Data.OpenXMLExportExcel operation failed. Object reference not set to an instance of an object.

[chuongmep]

If this issue is with Dynamo for Revit, please post your issue on the Dynamo for Revit Issues page.

If this issue is not a bug report or improvement request, please check the Dynamo forum, and start a thread there to discuss your issue.

Dynamo version

2.12

Operating system

Windows 10

What did you do?

I See a problem when i try copy data from file 1 to file 2, next im try delete data in file 2 and save, final run again file 1 not copy. I think this is a bug in https://github.com/DynamoDS/Dynamo/blob/7140c6359debb8a6238d9a6935b6cab32bb80995/src/Libraries/DSOffice/OpenXmlHelper.cs#L599 Book1.xlsx Book2.xlsx Home.dyn.zip

What did you see instead?

[github-actions[bot]]

Thank you for submitting the issue to us. We are sorry to see you get stuck with your workflow. While waiting for our team member to respond, please feel free to browse our forum at https://forum.dynamobim.com/ for more Dynamo related information.

[mjkkirschner]

@mmisol thoughts on this one?

[mmisol]

Hi @mjkkirschner . If the error is indeed in that line then it can only be that sharedStringTable is null. My thought was that these tables were being created if not found in the document in use, but I may be wrong. I would recommend to try to reproduce this using the provided files.

[NonicaTeam]

Any update on this? We have a similar issue with Data.OpenXMLImportExcel ? It reads some sheets but in other we get the same error. Attach a Excel sheet to try to read it with Data.OpenXMLImportExcel . 4.xlsx