
Write to, calculate, read from Excel workbook-sheet
Hello,
I am looking for examples on how to read, write, and calculate
(update?) an Excel workbook/worksheet without Excel, from a VB
application. The workbook is full of formulas, ranges and all that. I
need to be able to force a calculation of the workbook/worksheet after
writing new data to it and then read the new data.
Ultimately this will be a web app with a fairly complicated Excel
workbook sitting on the server and users will interact with the
workbook via web forms.
Thank you,
Monte