I've run into a BlueHeeler table in an Excel file that is causing a "corrupt file" error when I try to ingest it into my data process.
The Error Text: "Target Excel file may be corrupted. Cannot find required file or element within file xl/styles.xml."
Other than saving to csv, is there any other way to remove/change the BlueHeeler table without physically opening and resaving the file? It looks like the file was possibly created using Visual Studio...but I am not 100% sure since it is coming from my client's vendor.
(By the way....the best part of this problem was Googling the issue and seeing all the very cute blue heeler and Bluey images pop up. So I guess it isn't all bad.)
User | Count |
---|---|
107 | |
85 | |
76 | |
54 | |
40 |