Fully combine workbooks with data, format, images and charts using Aspose.Cells for .NET in C#

Aspose.Cells Product Family
1

We are considering using Aspose Cells and have a very specific technical question.

Is it possible, using Aspose.Cells for Java, to fully combine workbooks containing data, formats, images and charts?

We had seen in the online Java API documentation some notes for the method Workbook.combine():

Combines another Workbook object. Currently we only combine the sheet and data into this workbook.

However, we also saw an online demo that does combine workbooks that contained images and charts using the .Net version:

https://docs.aspose.com/display/cellsnet/Combine+Multiple+Workbooks+into+a+Single+Workbook

But, the online API documentation for the .Net Workbook.Combine() method states:

Currently, only cell data and cell style of the second Workbook object can be combined. Images, charts and other drawing objects are not supported.

Which contradicts the online Demo. Can you provide clarification? Again, specifically, does Aspose.Cells for Java support combining workbooks that contain images and charts?

Thanks,

Craig

This message was posted using Aspose.Live 2 Forum
2

Hi,

Sorry for the confusion.

We will update the Remarks for the API Reference for Workbook.Combine() method, The .NET article is fine and updated.

And, yes, Aspose.Cells for Java does support charts and images in combining workbooks.

If you find any issue let us know. We will check it soon.

Thank you.


3

Thanks for the quick reply,


And last question regarding this - When combining workbooks/worksheets using Aspose.Cells for Java, will the copied worksheets retain full fidelity to the originals? In other words, are there any worksheet features that are not supported when combining workbooks? And if so, are the limitations/restrictions documented anywhere?

Thanks,
Craig

4

Hi,

Well, there are still some objects which will be lost when combining workbooks, i.e.

  • Macros
  • Pivot tables

Other than these, everything would be copied fine.

Thank you.