Excel Compatible Chart Gallery - Powered by SpreadsheetGear 2012 and ASP.NET

This sample dynamically creates a chart gallery which demonstrates some of the most commonly used Excel charting features from a single Excel 2007-2010 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%2fchartgallery.xlsx&worksheet=Combination&shape=Area+-+Column+-+Line

Copyright 2009-2010 © SpreadsheetGear LLC. All Rights Reserved.
www.spreadsheetgear.com