search

DynamoDS / Dynamo

Open Source Graphical Programming for Design
https://dynamobim.org
Other
1.68k stars 622 forks source link

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

Open chuongmep opened 2 years ago

chuongmep commented 2 years ago

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?

image

github-actions[bot] commented 2 years ago

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 commented 2 years ago

@mmisol thoughts on this one?

mmisol commented 2 years ago

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.