Change column witdth to the heading(first row) width, the heading should be fully visible

[Testname]

I have this code:

            List<wert> tempWerte = ...;



            #region Tabelle füllen

            int columnCounter = 1;

            foreach (wert item in tempWerte)
            {
                //for (int i = 0; i < item.Werte.Length; i++)
                //{item.Werte[i]}
                worksheet.ImportArray(item.Werte, 1, columnCounter, true);
                columnCounter++;
            }

            #endregion

            #region Formatierung

            int startRow = 1;
            int startColumn = 1;

            IRange usedRange = worksheet.UsedRange;
            for (int i = startColumn; i <= usedRange.LastColumn; i++)
            {
                usedRange[startRow, i].CellStyle.Font.Bold = true;
                usedRange[startRow, i].BorderAround(LineStyle.Thin);
            }

            usedRange.CellStyle.Font.FontName = "verdana";
            usedRange.CellStyle.Font.Size = 10;

[Dilli Babu Nandha Gopal]

Hi Testname  

Thank you for contacting Syncfusion support.  

Yes, you can auto-fit the column width by using IRange.AutofitColumns method. The code example illustrating this behavior is available in the following UG documentation link.  

UG documentation link: http://help.syncfusion.com/file-formats/xlsio/working-with-cell-or-range-formatting#auto-fit-rows-or-columns  

We have also shared a sample illustrating this behavior for your reference which can be downloaded from the following link.  

  

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ImportStringDataWithAutofit-1052793612.zip  

Please let us know if you have any concerns.  

Regards,  

Dilli babu.