Forum Discussion
Hi @darshthakkar ,
Good day, the line breaks I think is doable by means of excel formula
e.g.
then in the excel formatter snap checked the “convert the formula to excel formulas”
when open in excel
In excel you need to manually set the cell/s to wrap text
As for the worksheet attributes/settings/style maybe there’s a way in setting this configs from the excel metadata, to see the excel metadata create a copy of the excel file then rename that file to .zip then extract
Which document/schema/xml to update, that I have no idea 🙂
e.g.
Thanks,
EmEm
- darshthakkar3 years agoValued Contributor
Thank you @alchemiz for testing this out and sharing your insights, I really appreciate that.
I’m actually looking for no manual intervention once the flat files have been generated so I will have to research a bit on this. I did try something with csv files before however didn’t find any luck with it.
The old post was Can we hyperlink inside a mapper snap? - #19 by darshthakkar
@alchemiz - If not line breaks, can we display it on a different row altogether? Thinking out loud as we wouldn’t have to worry about the formulas, press enter after opening a flat file or select wrap text option.