[ad_1]
New to python - awesome stuff but on a learning curve.
I have an existing excel file with many sheets that have formulas that together function as a simulation engine. The first sheet is dedicated to the input data that the rest of the spreadsheet uses to simulate and produce output data.
The raw input data is generated using a pandas dataframe and one row at a time is input to the first sheet in the excel spreadsheet. But the methods I have investigated overwrite all the other sheets, so obviously the simulation engine doesn't exist and won't function.
How to export a row from a pandas dataframe to a single sheet within an existing spreadsheet while keeping the rest of the existing spreadsheet intact?
[ad_2]
لینک منبع
