I have a fairly simple excel spreadsheet that I want to read data from, do some calculations and then add a results column to the spreadsheet and put it back out on our network so people can see it.
I have looked at several threads online, but none seem to get me where I need to be. All I need to do is harvest the data in certain columns and crunch some numbers with the data.
The solutions I have seen to similar problems get way, way too complicated. I just need to read, crunch, and write. Specifically, I need to find out how to assign and open a spreadsheet, how to read the data from the table and store it, and then how to reconstruct recordes that can be used to create a new spreadsheet.
If you are corrently doing this kind of thing, I'd really appreciate hearing from you. Thanks in advance.
Terry
I have looked at several threads online, but none seem to get me where I need to be. All I need to do is harvest the data in certain columns and crunch some numbers with the data.
The solutions I have seen to similar problems get way, way too complicated. I just need to read, crunch, and write. Specifically, I need to find out how to assign and open a spreadsheet, how to read the data from the table and store it, and then how to reconstruct recordes that can be used to create a new spreadsheet.
If you are corrently doing this kind of thing, I'd really appreciate hearing from you. Thanks in advance.
Terry
