I have about 16,000 .xlsx files in a directory. Each file follows the same structure. The first sheet is empty, and called "Sheet 1". The second is where the interesting data is, and it's called "Partners". I need to convert these to text/csv.
I've tried various solutions I found online, including ssconvert, xlsx2csv, both of which produce runtime errors. I've also tried these with a dummy file I created with Libre Office Calc, just to check it's not that my files are corrupt (and those files open fine).
How do I do this?