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
Solved! Go to Solution.
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.