I'm using "Copy document" and "Export Data Store entity to Excel" smart services in a process model to generate a excel sheet. While the sheet is generated when the contents are displayed, the cells don't fit to the width of the contents within them. In excel we can generally expand according to the width of the contents by selecting all rows and columns and double clicking in the middle of any two columns. But that is after generating the file. So, I want this columns to be auto adjusted or expanded while generating itself. how do I make this happen?
Now,
How I need it to be,
Thanks,
Shravan
Discussion posts and replies are publicly visible
Yes, as Stefan mentioned it is not possible to adjust the column width or any alignments in Appian, there would be limited options. You might need to do that after download the file.
is there any smart service where i can preset the width of the columns?
Actually I have done what you are trying to do. I'm assuming you are using a template in Export DSE to excel node since you mentioned that you are using Copy document SS too. So what you can do is, you can word wrap or set the width for required columns in the template document and it will persist in the new generated document as well
I have tried setting the column width in the template document. After doing that for me, when I download the sheet it comes appropriately expanded but when other users try the same they have one or two columns distorted. So im not understanding why is the behaviour of the sheet not uniform for different users
Never seen that kind of disparity.