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

[github-actions]

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.