I have a folder with 73 xlsb files. I need to do the following to each of these files:
- Add a new sheet to each of these files and rename it to "Data Values".
- Into the newly created sheet, I must add the following:
| Cell | Formulae / Value |
|---|---|
| A1 | "Sale date" |
| B1 | "Customer ID" |
| C1 | "Customer Name" |
| D1 | "Sale amount" |
| E1 | "Percent of target" |
| A2 | ='Main Calculation'!B3 |
| B2 | 1011 |
| C2 | "ABC Desserts" |
| D2 | ='Addl Calc'!H30 |
| E2 | ='Addl Calc'!I30 |
Would there be Python code that could achieve this?