Dynamic Excel spreadsheet
 

Hello,

We are trying to work on a project where on a web
interface, selecting certain data will generate a
spreadsheet which has 4 sheets within it. The first one
will have the data that was provided on the web interface
and the other sheets have calculations, charts etc.

We have been able to do a basic spreadsheet with a tool
called aspose but the problem is that once the
spreadsheet is generated, we cannot program one sheet
within the excel spreadsheet to pull data from another
sheet within the same spreadsheet. This is necessary
because once the spreadsheet is generated, we want to be
able to change the data on the first sheet which should
subsequently show results on the other sheets, which
includes charts as well.

Any help in this direction will be appreciated.

Thanks,
Sameer

Dynamic Excel spreadsheet
 

Sameer

I don't really know the answer to this but it may be
possible using Javascript and it will depend on whether or
not you can reference the cells in the html spreadsheet.

Try posting on a web group

Good luck
Peter
-----Original Message-----
Hello,

We are trying to work on a project where on a web
interface, selecting certain data will generate a
spreadsheet which has 4 sheets within it. The first one
will have the data that was provided on the web interface
and the other sheets have calculations, charts etc.

We have been able to do a basic spreadsheet with a tool
called aspose but the problem is that once the
spreadsheet is generated, we cannot program one sheet
within the excel spreadsheet to pull data from another
sheet within the same spreadsheet. This is necessary
because once the spreadsheet is generated, we want to be
able to change the data on the first sheet which should
subsequently show results on the other sheets, which
includes charts as well.

Any help in this direction will be appreciated.

Thanks,
Sameer
.