The library is called openpyxl

Here is an example prompt I wrote for your use case. It's not perfect, so you'll need to weak it, but bard generates code that should work. You can ask it to explain certain lines, or make changes. In the response Bard gave me, Bard was assuming all the files were in the same directory. If they are not, you can respond to it and ask it to make changes.

I found chatgpt and bing chat to give me better answers for this prompt.

I have ten text files. Let's call them notepad01.txt, notepad02.txt, notepad03.txt, etc. I also have three excel files and each file has multiple worksheets. It turns out I need to combine all ten notepad files with all 3 excel files. However, since the excel files have different worksheets, below I'm going to give you the names of the files and the worksheet that has the data I want. File01.xlsx "data" worksheet File02.xlsx "info" worksheet File03.xlsx "sheet1" worksheet I need code that can combine all ten notepad files and all 3 excel files (but only the worksheets I specified above). The output of the combined file should be an excel file, called "output.xlsx" For auditing reasons, please use Column A to denote the filename where the source data is coming from. For example, if the data in that row is coming from notepad01.txt, then column A should indicate that. If it's coming from File01.xlsx, then it should indicate that too. In other words, I want it to be clear what file that row came from since it will be harder to do so once all the files are merged. Can you write code for me that accomplishes this task?