Working with Excel/Word Charts

Aspose.Words Product Family
1

Hi there,

I found this old message thread while trying to determine if I can embed a chart from Cells into a Words document. The last reply was that this issue “has been fixed” but what does that mean?

Can I embed just a chart from Cells into a Words document? Or do I still need to embed a whole file, as the example above shows?

And as a refinement of my question - what I really want is a Words document with nice looking charts embedded in it (such that you see the actual chart, in good quality, when shown on screen zoomed in or out, printed, or in PDF output). Can I accomplish this with Words and Cells?

In MS Word I can paste a chart from Excel, and it looks perfect no matter if I zoom or print or resize - I’m looking for the same result using Words and Cells.

Thank you.

2

@PJS

You can create charts using Aspose.Words. We suggest you please read the following article.
Working with Charts

3

Yes I can but what I really need is the charts created from Cells/Excel. The Words charting engine is not as extensive (I was testing this about a month ago and asked a similar question). One of the charts I need to create has four series - two bar series, and two line series. I don’t think the Words charting can support this, correct?

So back to my original question - can I create my charts in Cells and copy/paste then into a Words doc programmatically such that they render perfectly?

4

@PJS

You can create this type of chart using MS Word. However, Aspose.Words does not support this feature. Could you please ZIP and attach your expected Excel file here for our reference? We will then log this feature in our issue tracking system accordingly.

You can insert the Excel chart as OLE object into Word document using DocumentBuilder.InsertOleObject method.

5

Tahir,

Attached is a zip file showing what I’d like. We would like to generate a number of charts in Excel, and then be able to insert some of them into a Word doc with text/tables/etc. I need the inserted charts in Word to look good, be able to be resized, moved, etc. without any loss of quality. PastedChart.docx is a Word doc with a pasted Excel chart - this is what I would like to create using the API.

Unfortunately without being able to do this I think my project is dead in the water and Aspose will not work for me…

Thank you.

ExcelChartTest.zip (29.6 KB)

6

@PJS

Unfortunately, Aspose.Words does not support the creation of combo charts at the moment. However, we have logged this feature request as WORDSNET-18330 in our issue tracking system. You will be notified via this forum thread once this feature is available.

We apologize for your inconvenience.

7

The issues you have found earlier (filed as WORDSNET-18330) have been fixed in this Aspose.Words for .NET 24.5 update also available on NuGet.