This sample dynamically creates a chart gallery which demonstrates some of the most commonly used Excel charting features from a single Excel 2007 Open XML workbook.
First, the Category listbox is populated from the list of worksheet names.
Then, for the currently selected worksheet (category), the Options listbox is populated from the names of the
individual charts on that worksheet. Finally, the SpreadsheetGear Image Rendering Utility
is used to render the image by setting the ImageUrl property of the image to:
spreadsheetgearimage.aspx?file=files/chartgallery.xlsx&worksheet=Column&shape=Clustered Column
|