This sample demonstrates an application of HotCell Technology that actively downloads reports from a web server based on selections made on a client-side Excel spreadsheet.
This is a "Drill Down" report that allows you to drill through several layers of relational data. The application starts on a list of customers. Select a customer to "drill down" and see a list of all orders made for that customer. Select an order to see the order details for that particular order.
Each time you select a customer or order to drill down into, HotCell VBA code contacts the ExcelWriter ASP.NET page on the server and downloads the data you have requested. With this technique, you only download the data you need.
In addition to the ASP.NET webform and Page code, look at the VBA code in the Excel template workbooks.
Click the Generate Spreadsheet button to begin the demo.
Important note: HotCell technology is macro-driven. You will need to Enable Macros in the downloaded workbook to run this sample.