How to Use Structured References in Aspose Cells

Aspose.Cells Product Family
1

Hi Aspose Folks,

I am demoing Aspose Cells and trying to convert a VB.NET application using Excel COM to Aspose.

How do I reference structured references when creating a line chart?

The Excel COM way:

xlApp.ActiveChart.SetSourceData(Source:=xlApp.Range(“Sheet1!Table1[[#All],[Timestamp]],Table1[[#All],[pctusr]],Table1[[#All],[pctnice]],Table1[[#All],[pctsys]],Table1[[#All],[pctwio]],Table1[[#All],[pctsteal]],Table1[[#All],[pctguest]]”))

x axis is timestamp.
y axis is pctusr, pctnice, pctsys, pctwio, pctsteal, pcsguest.

Any help is appreciated.

Thanks,

Lou

2

Hi,


Thanks for your posting and using Aspose.Cells.

Please create your sample Excel file and the expected Excel file manually using Microsoft Excel and attach it here. We will compare your sample Excel file and your expected Excel file and understand your requirement and provide you a sample code to achieve the similar thing using Aspose.Cells APIs. Please make sure you provide us some simple Excel files not the complex Excel files so that we could help you quickly. Thanks for your cooperation in this regard and have a good day.

3

Hi,


Thanks for using Aspose.Cells.

We have evaluated your requirements further and we are afraid, we do not support Table as the Data Source of the Chart. We will support it in our future releases.

This issue has been logged as

  • CELLSNET-45348 - Support Table as the Data Source of the Chart

However, we do support the creation of Excel Charts. Please see these documents for your help.


4
Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-45348 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
5

The issues you have found earlier (filed as CELLSNET-45348) have been fixed in Aspose.Cells for .NET 17.6.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.