Forum Discussion

Hammerschmidt's avatar
Hammerschmidt
Regular Visitor
3 years ago
Solved

Error: dataformat.error 'text' is an invalid xmlnodetype

Greetings!   I'm importing a folder with a series of sheets in xlsx format., I'm not having problems with the error dataformat.error 'text' is an invalid xmlnodetype.   I tried to create a custom...
Need Help
  • Hammerschmidt's avatar
    Hammerschmidt
    3 years ago

    Hi jbwtp 

     

    In fact, it was wrong to write the code, however when fixing it, I still can't join the tables.
    Until then, the solution I got was transforming the spreadsheets into CSV by VBA, so that after that I could perform the reading within the Power Query correctly, this generates more slowness within my automation via python, but it was the best solution so far time.

     

    Thanks so much for the feedback anyway! 🙂

Hammerschmidt's avatar
Hammerschmidt
Regular Visitor
3 years ago

Hi jbwtp 

 

In fact, it was wrong to write the code, however when fixing it, I still can't join the tables.
Until then, the solution I got was transforming the spreadsheets into CSV by VBA, so that after that I could perform the reading within the Power Query correctly, this generates more slowness within my automation via python, but it was the best solution so far time.

 

Thanks so much for the feedback anyway! 🙂