This topic is locked

Can I convert excel file to web with formulas?

10/30/2004 10:02:48 AM
ASPRunnerPro General questions
author

I am wondering if it is possible to make a asp website with excel which will keep all the current formulas.
Any help or suggestions will be much appreciated.

Sergey Kornilov admin 10/30/2004

Yes, you can publish Excel file with calculated fields however formulas won't work if you change one or more field values.
If you like to keep formulas you need to translate it into SQL statements. Here is the sample SQL statement with calculated fields:

select a,b,a+b as c1, a*b as c2 from Sheet1