In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Working with UIPath output file

Junie
5 - Atom

Hi,

 

I'm trying to read a UIPath generated email with excel attachment but everytime I try to read the file as input it's showing the erro below

Junie_0-1672926212587.png

 

so I have to always go in and save the file manually and that's the only time it is read normally

 

 

3 REPLIES 3
ChrisTX
16 - Nebula
16 - Nebula

In the configuration for the Input Data tool, try using the File Format "Microsoft Excel Legacy (*.xlsx)"

 

My understanding of the difference in these two File Formats:

  • File Format "Microsoft Excel Legacy (*.xlsx)": driver created and maintained by Microsoft
  • File Format "Microsoft Excel (*.xlsx)": driver created and maintained by Alteryx

 

ChrisTX_0-1672927158189.png

 

Chris

Junie
5 - Atom

I'm using 2020.2 and I don't see it in my File Format options

is there a way to show it?

 

Junie_0-1672930787354.png

 

 

ChrisTX
16 - Nebula
16 - Nebula

I'm on version 2021.4

 

Your question about access to access to both of these is probably something Alteryx support can help with.  

  • File Format "Microsoft Excel Legacy (*.xlsx)": driver created and maintained by Microsoft
  • File Format "Microsoft Excel (*.xlsx)": driver created and maintained by Alteryx

Not sure if there are options to have both drivers with older Alteryx versions.

Labels
Top Solution Authors