2
Vote

Unable to copy a worsheet from one workbook to another workbook in Office Open XML

description

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:

1.The option is not present in the Office Open XML
2.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["Sheet1"].WorksheetXml.InnerXml = xcelNewWorkSheet.WorksheetXml.InnerXml;)

Are there any ways to copy worksheet from one workbook to another in Office Open XML?

comments

Geekays wrote Oct 14, 2014 at 6:08 AM

Have you tried Range copy?