206
Views
2
Comments
Solved
[Advanced Excel] How to set column width
advanced-excel
Service icon
Forge asset by Carlos Freitas
Application Type
Reactive
Service Studio Version
11.53.27 (Build 61662)
Platform Version
11.17.0 (Build 36348)

Hello, I'm looking for a way to set column width as desired.

I've tried using WorkSheet_AutoFitColumns but it doesn't make columns smaller than 64px width.

The excel file which I'm trying to export contains several columns that needs to be really thin like 20~30px.


Thanks in advance.

2018-08-27 08-29-35
Fábio Vaz
Solution

Hello,

It's possible, but i don't know if the Forge version supports that.

https://stackoverflow.com/questions/9096176/how-to-set-xlsx-cell-width-with-epplus

You can add this action to the extension.

UserImage.jpg
Shinichiro Endo

Hi, Vaz.
Thank you for your answer.

Like you said, it seems it's not included in Forge version, so adding it by myself is the only way.
Thanks a lot!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.