How to set column width of existing excel file using OpenXML using C# in ASP.Net

Last Reply on Dec 21, 2016 09:51 AM By dharmendr

Posted on Dec 19, 2016 07:37 AM

Hi

I create an excel file using openxml and i want to set its columns width to specific value (ex = 80) how can i do this when creating file ?

Please help

Thanks

Posted on Dec 21, 2016 09:51 AM Modified on on Dec 22, 2016 01:44 AM

Hi MElbakly,

As you are editing the existing excel and not mentioning the column. So that i can't set the width. Let me try to modify your code.

You can refer the below link also.

http://stackoverflow.com/questions/34374785/creating-custom-column-widths-in-openxml-excel