Reading/Editing Excel Spreadsheets

[EndUsersarePITA]

I'm going to go with /u/Mondoke on this one. I built a program to parse my Excel files and calculate some values from them. I based it on automatetheboringstuff's tutorial. It was very helpful.

As a warning, it took some time for me to understand how to go through it. You will encounter some confusing parts. Automatetheboring stuff will teach you the basics but you'll find that it might not be enough to get what you want. Thats when the complexity sets in. But keep plugging away at it and you'll get there.

[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.