i am getting below error when trying to read an excel file. it is an auto-generated file. if i open and re-save file, i can read it. but i don't want to add a manual step.
@ayush_mishra If you do not want to do it manually you can use Python tool to do it for you, VBA or Power Shell and I'm sure that there are other ways to do it in addition to those that I just listed.
Is it possible to generate XML file instead of excel? It seems that the XML format is broken when the data is generated as excel file, maybe if an XML file will be generated you will not get this error and the good thing is that Alteryx know how to open XML files.