Dashboard from 1693 Analytics - Powered by SpreadsheetGear and ASP.NET
This sample shows how to create a dashboard where the user chooses from a list of states, and relevant educational cost data and charts are returned for that state. The model and data for this sample are contained in a static Excel workbook which has been provided by Burt Baker at 1693 Analytics, LLC, but it could just as easily come from a workbook which is dynamically generated by SpreadsheetGear.

The key steps in the generation of this dashboard are:
  • The first time this page is loaded, the BuildStates() method loads the workbook from disk and populates the listbox of states from the range of cells which have been given the defined name "ListOfStates".
  • The Page_Load() method constructs a URL which will instruct the image rendering utility what to render.
  • The constructed URL is assigned to the Image control on this page.
  • The browser generates an HTTP request to the image rendering utility which generates the dashboard.
State: Dashboard Generated by SpreadsheetGear Image Rendering Utility:
Copyright 2009-2017 © SpreadsheetGear LLC. All Rights Reserved.