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);
}