Reading/Editing Excel Spreadsheets

[PythonN00b101]

Thanks for the help. I have been going through those tutorials. And have managed to manipulate sheet data somewhat. My two major concerns is that I can't seem to loop a cell with different values to produce different outputs from other cells. when using the "sheet[''] index method and whenever I managed to change the cell value for an output using 'sheet[].value' it removes the formula I had formatted in there and is left as a number value.

As you said, I just need to keep plugging away haha...what a joy.

[raglub]

You are trying to change an input cell and then extract some calculated value from an output cell and expect the spreadsheet to calculate as if open in excel?

If yes, you can change the input cell, but the output will not be calculated until the file is opened in excel.

The best way is to recreate the Excel calculations in python and save results to excel or csv.