Server-side Excel?

----- Excess quoted text cut - see Original Post for more ----- OK, first of all, what do you mean by "run the Excel spreadsheet"? If you mean get data out of it, then just make it a datasource, but this "locks" the file, so you have to release it if you want to replace it If you want to update data, then you could use a COM object (www.cfcomet.com has some code for this), but this requires that Excel is installed on the server HTH

Hi Philip ----- Excess quoted text cut - see Original Post for more ----- Basically we want to use the complicated calculations that are set up in the spreadsheet and are wondering if we can avoid re-coding them in CFML. Will check out cfcomet, thanks. Nick

> Basically we want to use the complicated calculations that > are set up in the spreadsheet and are wondering if we can > avoid re-coding them in CFML. If you want to update the values and get the calculations to update, then you'll have to look into COM It's a hassle to work with in the beginning, but it allows full control over the sheets and stuff

Hi Nick; If you want to pull data from an Excel spreadsheet via COM, go ahead, but I advise you to check the data being returned very carefully. We had a similar situation where we would pull data from Excel in CF5 via COM and had all kinds of problems. Intermittently, the sheet would return bad data, i.e. values that were impossibly high or had nothing to do with what was actually in the spreadsheet. The problems were mostly with calculated fields, although we would have trouble returning simple values sometimes as well. I'm not saying everyone is going to run into issues, just be careful. M Hi Philip ----- Excess quoted text cut - see Original Post for more ----- Basically we want to use the complicated calculations that are set up in the spreadsheet and are wondering if we can avoid re-coding them in CFML. Will check out cfcomet, thanks. Nick