Alteryx Designer Desktop Discussions

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

Avoid Alteryx remove leading space when write data into excel

IMSL
7 - Meteor

Hi all,

 

How can I avoid Alteryx remove leading space when write data into excel.

I want to keep the indent.

 

Below is a similar discussion but I am looking for a solution to publish in xlsm not a csv file:

Avoid alteryx remove leading space when write data... - Alteryx Community

1 REPLY 1
FrederikE
13 - Pulsar

Hey @IMSL,

 

This is not something that Alteryx does, but Excel does. Once you open a file leading whitespaces are deleted. 

(You can check this yourself, when you call the file in Alteryx again before you open it in Excel it still has the Whitespace; after it is opened in Excel, it doesn't have it).

 

I am not sure there is a solution (can't find one) - but this would be a question for an Excel forum, Alteryx performs as expected here. 

Labels
Top Solution Authors