I import .xls files using the $options["headers"] setting overriding any existing headers to match my SQL table field names. This works great for .xls files, but if I save the file to .xlsx it fails with "Invalid field name: 0" and I can see all the field names in the import box named "0 1 2 3 4 5 etc." instead of using the headers I've defined. I can see my data lined up under these numeric field names. What would be causing numeric fields names to show-up only in .xlsx file imports?
I'm running v2024.9
Thanks