EasyXLS
http://forum.easyxls.com/

Get chart from Excel
http://forum.easyxls.com/viewtopic.php?f=5&t=124
Page 1 of 1

Author:  khanhtran [ Tue Nov 06, 2007 4:50 am ]
Post subject:  Get chart from Excel

Hello,
I want to read existing charts in some sheet in my existing excel file. Is this possible with EasyXLS reader? I've search all the API but found no way to do this.

Please help!

Author:  daniela [ Wed Nov 07, 2007 3:42 am ]
Post subject: 

You need to use ExcelDocument.easy_LoadXLSFile to load your existing excel file and then to extract your chart.

//Load the excel file
ExcelDocument xls = new ExcelDocument();
xls.easy_LoadXLSFile(filePath);
//Get the worksheet that contains the chart
ExcelWorksheet xlsSheet = xls.easy_getSheetAt(sheetIndex);
//Get the chart from the worksheet
ExcelChart xlsChart = xlsSheet.easy_getChartAt(0);

Author:  khanhtran [ Wed Nov 07, 2007 10:19 pm ]
Post subject:  Thanks

Thanks Daniela. It works great!

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/