Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

excel worksheet into another work sheet

Home
Forums
Visual Basic .NET

excel worksheet into another work sheet

Shalu Shalini

Shalu Shalini

8yAsked Sep 12, 2018, 5:18 AM707Visual Basic .NET

hi

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

thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Leon D8y ago
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 Ranwa8y ago
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