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

This sample dynamically creates a chart gallery which demonstrates some of the most commonly used Excel charting features using a single Open XML workbook from Excel 2007-2019 or Excel for Office 365.

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:


Copyright 2009-2017 © SpreadsheetGear LLC. All Rights Reserved.