PdfRpt.Core.Helper.ExcelHelper.ColumnWidth2Pixel C# (CSharp) Method

        public static int ColumnWidth2Pixel(this ExcelWorksheet ws, double excelColumnWidth)
        {
            //The correct method to convert width to pixel is:
            //Pixel =Truncate(((256 * {width} + Truncate(128/{Maximum DigitWidth}))/256)*{Maximum Digit Width})

            //get the maximum digit width
            var mdw = ws.Workbook.MaxFontWidth;

            //convert width to pixel
            var pixels = decimal.Truncate(((256 * (decimal)excelColumnWidth + decimal.Truncate(128 / mdw)) / 256) * mdw);
            //double columnWidthInTwips = (double)(pixels * (1440f / 96f));

            return Convert.ToInt32(pixels, CultureInfo.InvariantCulture);
        }