Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Unzipped file... XLS as HTML? Need it as XLSX

jbravman_
8 - Asteroid

So I'm able to get 7zip to unzip my file.... only issue is its showing up as a .xls but in reality its an html (i see all the HTML code if i convert it to .csv) Is there a workflow out there that can take in the .xls (actual html) and convert it over to .xlsx?

 

Running x10.6

3 REPLIES 3
Claje
14 - Magnetar

See the attached workflow.


This should do what you need - the key is reading in the initial file as a CSV without delimiters (in spite of the extension)

EDIT: Just reread the version you're on.  Updated workflow attached.

jbravman_
8 - Asteroid

hit the accept button by mistake... slow computers these days....

 

But yah so i selected my .xls file and now i'm getting a popup saying InvalidArgument = Value of '0' is not valid for itemindex parameter name : itemindex....

 

 

 

any ideas? 

Claje
14 - Magnetar

I'm guessing that when you brought in the excel file it reset the configuration for that input tool.


Here's a screenshot of how it should look.

 

Let me know if this helps!

ExampleExcelScreenshot.PNG

Labels