excel worksheet into another work sheet

Question

hi can anyone please help to embed one excel worksheet into another worksheet in c# thanks

Leon D · Answer

Use Free Spire.Xls.dll, you can easiy add multiple worksheets to one worksheet through data table. Refer to the below code: string [] excelFiles = new string [] { "1.xlsx" , "2.xlsx" , "3.xlsx" }; Workbook workbook1 = new Workbook(); workbook1.LoadFromFile(excelFiles[0]); Workbook workbook2 = new Workbook(); workbook2.LoadFromFile(excelFiles[1]); Workbook workbook3 = new Workbook(); workbook3.LoadFromFile(excelFiles[2]); Worksheet sheet1 = workbook1.Worksheets[0]; Worksheet sheet2 = workbook2.Worksheets[0]; DataTable dataTable1 = sheet2.ExportDataTable(); Worksheet sheet3 = workbook3.Worksheets[0]; DataTable dataTable2 = sheet3.ExportDataTable(); sheet1.InsertDataTable(dataTable1, true , sheet1.LastRow + 1, 1); sheet1.InsertDataTable(dataTable2, true , sheet1.LastRow + 1, 1); workbook1.SaveToFile( "Merge.xlsx" , ExcelVersion.Version2013);

Sanwar Ranwa · Answer

Hello Please check these Links https://www.youtube.com/watch?v=Ssjz504CWmM https://docs.microsoft.com/en-us/visualstudio/vsto/how-to-programmatically-add-new-worksheets-to-workbooks?view=vs-2017 https://www.codeproject.com/Questions/418368/trying-to-add-a-excel-worksheet

excel worksheet into another work sheet

Answers (2)