Last post Apr 20, 2013 11:37 AM by tarwara99
Mar 05, 2009 05:23 AM|au_rossli|LINK
I have several excel spreadsheet fils, each of them contains multiple work sheets that may storing images or data.
How could I merge all of these work sheets to just one .xls file and keep their original layout and style using asp.net?
Thanks in advance.
Mar 05, 2009 06:14 AM|mudassarkhan|LINK
you can readand write data using ADO.Net refer my articles
Mar 06, 2009 12:18 AM|au_rossli|LINK
Nov 14, 2009 06:03 AM|singhmanish_888|LINK
Try Worksheet.Move() function.It preserves all format and styles with position.
Don't call WorkBook.Save() or Workbook.Close() after calling Move() function for the source workbook because it automatically closes the source workbook without any changes.
Dec 29, 2009 07:18 PM|minguva|LINK
Can you please provide me some example. Just want to reconfirm... We are coping from two diffrent Excel books.../
Dec 30, 2009 06:49 AM|singhmanish_888|LINK
I tried with WorkSheet.Move() function to check the behavior for the case but it is resulting the same as WorkSheet.Copy().Ideally Move() should completely move sheets from one workbook to another.If you try it manually on excel files and record a macro
it displays Move() function and work properly but from C# the same behavior is not working.
I found a article where stated that Excel maintains a clipboard while doing all operation on windows but C# doesn't consider any clipboard.
I am still finding an appropriate way to do this using C#.Maybe some experts can help us on this.
Jan 01, 2010 05:50 PM|TATWORTH|LINK
Maybe some experts can help us on this.
This is an ASP.NET forum, for Microsoft Office questions, please ask at:
Aug 29, 2011 02:07 AM|jeeshenlee|LINK
I wrote a simple Excel VBA script that merge multiple excel files into one. Here's the link
Apr 20, 2013 11:37 AM|tarwara99|LINK
Find a readymade Add-In at:
It can merge excel 2010, 07 and 03 files into one file. Just two button press and it will merge all your sheets.