Hooking up a Excel Spreadsheet to an ASP page to output a chart.
Posted on 2006-06-19
I have an idea and i am sure that it is possible but i have no clue where to begin.
What i have is a spreadsheet that has quartly sales by division.
What i would like to do is make an ??ASP?? page that will have pull down boxes that list quarters and divisions. Then a button that says "Create Chart". When user selects the desired quarter and division the asp page could query the spreadsheet and then pull the numbers and then create the chart and place on the page.
Finally, could i have it so that they could change the desired quarter and or divison and then press create chart and have the new chart created?
Thanks A Bunches