Chart series in Excel97 workbook

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
davefowle
Posts: 12
Joined: Wed Nov 22, 2006 10:39 am
Location: London, England

Chart series in Excel97 workbook

Post by davefowle »

I am porting code from XLsReadWrite v4 to v5. All is going well, but I cannot get the modification of chart series working, e.g

// Does not work missing event handler TFormulaHandler::SheetDataEvent
TDrwCharts* charts = Sheet->Charts ;
TDrwChart* chart ;

// For all charts in a worksheet -
for (int i = 0; i < charts->Count; i++)
{
chart = charts->Items ;
// For all series in chart
for (int a = 0; a < chart->Series->Count; a++)
{
// Add category and value range definitions
UnicodeString C = chart->Series->Items[a]->Category ;
UnicodeString V = chart->Series->Items[a]->Values ;
Post Reply