Merge Multiple Excel Worksheets into One Excel WorkSheet using C# in ASP.Net

Aporvi
 
on Jun 16, 2016 08:17 AM
7564 Views

Hi,

I am new in C# language. I used to do this job in vba but don't know how could we do this in C-sharp.

I would like to collaborate multiple excel files from a folder into a single excel file using C-sharp.

1. Structure of all excel files are same but want to take first 50 columns.

2. Number of rows of those excel files are not same. (some files contains 100,000 rows)

Can anyone help.

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Jun 16, 2016 08:28 AM
on Jun 16, 2016 08:51 AM