We have a web site from which we need to generate "poor man's" reports. This site is IIS and currently with ASP.
Our approach to this is to generate Excel and download them to the user. This is what we inherited.
The data is being queried from a relational DB. The site is currently ASP (VB), but we may go to .Net.
At this time, the site is driving a full-blown installation of Excel, which is pretty heavy. We'd like to switch to OWC11 (we think) because we can't afford Excelwriter.
We have one hitch though. We do want to use some starter excel documents, which have a limited amount of header info on them. I inherited this, so this functionality may be why Excel was used in the first place.
Regardless, we can't see how to load an "almost empty" excel workbook with OWC11 like we currently do and put data in it. We'd like to find an example of how to do this or be told that there is nothing equivalent to "read" with OWC11. Currently our extra formatting consists of several rows of text with colored fonts, etc.
Our approach to this is to generate Excel and download them to the user. This is what we inherited.
The data is being queried from a relational DB. The site is currently ASP (VB), but we may go to .Net.
At this time, the site is driving a full-blown installation of Excel, which is pretty heavy. We'd like to switch to OWC11 (we think) because we can't afford Excelwriter.
We have one hitch though. We do want to use some starter excel documents, which have a limited amount of header info on them. I inherited this, so this functionality may be why Excel was used in the first place.
Regardless, we can't see how to load an "almost empty" excel workbook with OWC11 like we currently do and put data in it. We'd like to find an example of how to do this or be told that there is nothing equivalent to "read" with OWC11. Currently our extra formatting consists of several rows of text with colored fonts, etc.
