We are working Web API and using Office Open XML for Excel data.
When we tried to copy an ExcelWorksheet from one Workbook to another Workbook in ExcelPackage:
- The option is not present in the Office Open XML
- When we tried using the Inner xml copying from one work book to another, it will not throw error while running the application, but while opening the excel file, it throws corrupted sheet error. (Code: xlpackage.Workbook.Worksheets["Shhet1"].WorksheetXml.InnerXml
Are there any ways to copy worksheet from one workbook to another in Office Open XML?