Excel Column Width - AutoFit

It is not possible at this time. Please ask for this as a new requirement. It should be easy to realize.

BR,

Torsten

Thanks Torsten,

I simply wrote a function to do this (UPDATED):

        
        function _autoFitColumns(_workSheet, _columnCount) {
            var oRowCount = _workSheet.getAbsoluteFilledRowCount();
            var oRowWidth = 0;
            for (i=0;i<_columnCount;i++)
            {
                
                 var oColWidth = 0;
                 for (j=0;j<oRowCount;j++)
                 {
                     var oCell = _workSheet.getCell(j, i).getCellValue();
                     var oCharCount = oCell.length();
                     if (oCharCount > oColWidth)
                     {
                         oColWidth  = oCharCount;
                     }
                 }
                 oColWidth = (oColWidth + 3) * 256;
                _workSheet.setColumnWidth(i,oColWidth);     
            }