xlsgen > overview > Charts management

xlsgen provides the following mechanisms to manage charts :

• addition
  • embedded or stand-alone charts can be added to either Excel 97-2003 or Excel 2007 spreadsheets :
    worksheet.NewChart (embedded chart)
    workbook.AddChart (stand-alone chart)
    
    
• deletion
  • a chart from an Excel 97-2003 or an Excel 2007 spreadsheet can be deleted :
    worksheet.Shapes returns the shapes collection of the given worksheet (shapes are pictures, charts, ...)
    shapes.Item(i) returns the i-th shape in that collection
    shape.Type returns the shape type (chart = 5)
    shape.Delete() deletes the chart
    
    
• introspection
  • the chart details of an existing chart can be read, from an Excel 97-2003 or an Excel 2007 spreadsheet
    worksheet.Charts returns the charts collection for the given worksheet
    charts.Item(i) returns the i-th chart in that collection
    chart.ExtractToFile() returns a snapshot of the chart (PNG file)
    chart.ExtractToMemory() returns a buffer with a snapshot of the chart (PNG buffer)
    
    
• print/preview/PDF (as part of contents)
  • the content of a worksheet can be printed including cell formatting, pictures and charts, from an Excel 97-2003 or an Excel 2007 spreadsheet. For a chart to be printed, the Microsoft OWC components must be installed prior that. For more information on the subject, please read this page. Charts can be printed on a paper, previewed in a page or exported as part of a PDF file.
    worksheet.PrintWith prints the worksheet and its contents
    worksheet.PrintPreview previews the worksheet and its contents
    worksheet.Export.ExportAsPDF exports the worksheet and its contents as a PDF file