Thanks mudassarkhan, your articles are really helpful to duplicate data between spreadsheets. But I'm sorry that I didn't make my question clear: what i want to copy between sheets is not only data, but also including images and charts .
I have got some achievements using Interop by studing these refrences in MSDN:
http://msdn.microsoft.com/en-us/library/ms173186(VS.80).aspx
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel._workbook.saveas(VS.80).aspx
http://msdn.microsoft.com/fr-fr/library/microsoft.office.interop.excel.workbooks.open(VS.80).aspx
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheets.copy(VS.80).aspx
I must say Worksheets.Copy() is really a good way to meet my requirement because it does copies objects(including data, images and charts) from one works sheet to another. However, I found that some style is gone or wrong, for example, the background color is gone and some font color is changed in the destination excel file.
So does any guy know how to keep the original styles of a worksheet/workbook when they are being copied to another place?

Thanks a lot!

How To Combine Multiple Excel Files

Sheet

Now choose your destination file (your master sheet, or the file you want to merge your Excel sheets into). This can be an existing spreadsheet already stored in your cloud storage, or if you want to use a new spreadsheet, Sheetgo will create one for you automatically. Here I will consolidate multiple Excel sheets into a new Excel file.

Merge Multiple Excel Files Into One Sheet Using Java

  • Mar 21, 2021 Create a new worksheet. Click on the Data tab and then click on Consolidate. In the Function section, choose Sum. In the Reference section choose your spreadsheet in order to be able to access your data.
  • Using a macro to combine multiple Excel files into one When we have multiple Excel files, we can merge them in a swift manner using a VBA macro. We can easily use the macro displayed below. We will click on Alt + F11 and select Visual Basic Editor.
Coments are closed

Most Viewed Posts

  • Impact And Urgency Matrix
  • Nfc Iphone
  • Speedy Fy
  • Wave Invoicing
  • Merge In R Example

Scroll to top