Excel file(.xlsb) exported, shows only last row when Open in Excel.

Hi,

I noticed that when an excel file is created (.xlsb) using Alteryx when I open that file it shows the last row with data and down from there, basically a bunch of blank rows.

Is there way to setup a configuration that in Alteryx that when I open the file in Excel it will shows the first rows?

Thanks

Workflow

Accepted answers

All comments

pedrodrfaria

Hi @JoseHerrera

Can you provide us with the configuration on the output data tool? If I understood it correctly, it doesn't really make sense.

I attached a simple WF that outputs to an excel file. Let me know if this is happening as well with the attached WF.

Excel file exported, shows only last row when Open in Excel..yxmd

skeen503979

@JoseHerrera

In your "Output Data" tool is the Output Option (# 3) configured to "Append to Existing Sheet"? It might be cleaner to select the "Overwrite File (Remove)" option so that your results are always fresh and won't be confused with previous results.

JoseHerrera

Thanks @pedrodrfaria

You made me realize that the problem is with .xlsb type files.

This is the configuration I am using.

JoseHerrera

@skeen503979 thanks, but the problem is with a xlsb not a xlsx.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703