Render with blank columns

Question

Hi All,

I have attached an excel file. I want to render it but unable to do it.

I need Column A, B & C as blank and Row A1 and A2 also blank and then the data pasted as it is. Kindly check the below picture.

Is it possible? I need the output via Render tool only.

I know I can apply formatting in excel and take the output but I have multiple sheets with similar kind of data that I want it on one single excel file and if I apply formatting on each sheet then the file size will be big that I don't want.

Book4.xlsx

ArijitRoy · Answer

Hi @messi007,

Thanks for your reply but I want the output via render. I have around 12 to 15 sheets like this that I want in one excel file. If I use formatting on the excel file then it will get heavy and also sometime it get corrupt.

messi007 · Answer

@ArijitRoy,

You can start with an empty sheet like this :

And then use the option below to update the empty sheet :

Attached the workflow.

Please save the workflow and the output on the same folder or replace the output path.

Regards

FormatOutput_20240118.yxmd