Hot to calculate sum of a range in a spreadsheet using OWC
Posted on 2004-10-20
I am using Office Web Component to populate a spreadsheet within ASP.net. the spreadsheet contains numerous figures. What I need to do is create a grand total line within the spreadhseet.
Can any one tell me how to do this dynamically? the number of rows within the spreadsheet may vary over time depending on the results of the query
Thanks In Advance