Error with existing files with DSOffice.Data.OpenXMLExportExcel

[NonicaTeam]

Dynamo Version

2.12.1.8411

Host

Revit

Operating System

Windows 10

What did you do?

We are programming a Python node calling the method DSOffice.Data.OpenXMLExportExcel. Everything seems to work fine when the file does not exists and its newly created. However, when switching Revit documents and exporting on an existing file the data is unorganised and picked from previous sheets.

What did you expect to see?

If the file does exist, I believe the SharedStringTablePart of the method is not properly set up. I expect the string cell values to be referenced to the new values.

What did you see instead?

The excel file needs to be recover when opening and the data is unorganised and picked from previous sheets.

What packages or external references (if any) were used?

clr.AddReference("DSOffice") import DSOffice from DSOffice import * clr.AddReference('DocumentFormat.OpenXml') import DocumentFormat from DocumentFormat.OpenXml import OpenXmlAttribute, SpreadsheetDocumentType from DocumentFormat.OpenXml.Packaging import * from DocumentFormat.OpenXml.Spreadsheet import * from DocumentFormat.OpenXml.Validation import *

Stack Trace

No response

Details

No response