I have an Excel spreadsheet with various sheets. I load these using a loop and add new data through the joiner. I want to insert the new data back into the “old” spreadsheet in the corresponding cells. Is this possible? Or how can I recreate the spreadsheet as it was?
In general you can read in data, processes it and then use Excel Writer to write data to a file. Excel reader has different options like “appending” to an existing file or “overwritting” that file. What works best highly depends on your specific use case - to provide more guidance it’d be great for an example to be provided…