Set cell width in dynamic Excel writer

..bad advise?

There is no fme solution, though I think they could provide it.

But you can use the pythoncaller with the xlsxwriter python module which you can download to do it.

I fail to see why this would invoke negative reactions...that's all. (thanks for the deduction in negatives though..;)

You can also use windows api to make the columns fit the content hwne writing, also using python (or tcl, or java)

Hi @krisvewsp, than you for your interest in this scenario. This other post has a potential solution suggested by David_r (April 12th). Although it might be a slow translation, if you are working with a large dataset. There is also an idea tracking the interest for an easier solution for this problem. Please add your vote and comment to let us know of your interest! Thank you!

Excel Writer: Invalid column width 'width' specified for column 'M2_RevAvser5' of sheet 'd_y_n'. Value must be numeric. Using Excel default column width

Hi @krisvewsp, my initial idea was that david_r's method can be used in combination with a dynamic workflow where destination schema is derived from a schema feature. This method in theory should allow us to take the max string length and set the schema feature with that number. e.g. fme_data_type fme_varchar(14), where 14 is the result of the max string length calculation.  

But in my test, this didn't seem to change how wide the column that displays in MS Excel. I still needed to double click on the column boarder to have it fit the width of the text in that column. So, it didn't work as I expected. 

I'm out of ideas at the moment... 

This works great! But depending on your language setting of Excel its either ; or , in the "width,x" part (Dutch is ; while English Excel is ,) the way it works in your functions in Excel