We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Accesssible Named Range for designer chart?

Hi

I am trying to evaluate your aspose.cells product for a new project. I am also looking at Spreadsheetgear and OfficeWriter.

I have found the following feature in Spreadsheetgear, but I am not sure whether your product has similar capabilities, with similar ease of implemenation for the programmer? Can you point me towards some example code?

Spreadsheetgear Demo from website:

Excel Report with Chart Linked to Defined Name
This sample shows how to load a workbook containing a chart series linked to a defined name, change the defined name range reference, and stream it to Microsoft Excel. For charts with multiple series, use Excel to set each chart series to refer to a unique defined name.
<%@ Page Language="VB" EnableViewState="false" %>



Excel Report with Chart Linked to Defined Name using ASP.NET and VB.NET - Returns XLS Workbook Using SpreadsheetGear for .NET



 
Thanks for your help
 
Mark

Hi Mark,

Aspose.Cells supports this feature and the code is very simple:

Workbook workbook = new Workbook();
workbook.Open(@"d:\test\Book1.xls");
workbook.Worksheets.Names["ChartSeries"].RefersTo = "=Sheet1!$A$1:$A$5";

workbook.Save(@"d:\test\output.xls");

Please try it with the template file in the attached zip file. And there is a new version in this zip file. It includes most updated enhancement and fixes.