2018.1 Release - Usability of Excel Features in New Input Tool

Dear team & community,

The release note for Alteryx Designer 2018.1 states that "we have enhanced the Input Data tool to improve the usability of excel features". Unfortunately I am currently not able to update to 2018.1 yet (company license), but I was wondering what the changes include since this could impact some of the solutions we are currently working on. I didn't find the detailed information anywhere on the support or community pages, does anyone know where I can find it?

Thank you and kind regards

Frank

Input

Accepted answers

DanM

@frankm,

Really the change is a visual UI change to connecting to Excel. Really no other Excel features added. The ability to choose your sheet name is less confusing, if your worksheet has named ranges enabled you are able to pull that information, and a list of sheet names.

Dan

All comments

DanM

@frankm,

Dan

frankm

Hi Dan

Thanks for the quick response! The RangeName list is good news, although I was hoping for some more fancy updates re Excel integration .

Cheers

Frank

FFFool

Maybe this was in 11.5 or 11.8 as I didn't upgrade to those, but new since 11.3 is the ability to input and output .xlsb files, which is massive for our company, as we were using a Macro I created that called batch files to convert to .xlsb before, and it wasn't necessarily stable.

DanM

@FFFool

We do now read and write to .xlsb files. You can see all the file formats Alteryx can use here. https://help.alteryx.com/current/index.htm?_ga=2.213973266.403253465.1522008027-1960283514.1520617682#DataSources/SupportedDataSources.htm

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703