/// <summary>
/// 获取Excel区域在CAD中的列宽，选择列自动时按本列文字最大宽度乘以1.2确定，否则按列宽设置值
/// </summary>
/// <param name="rng">Excel区域</param>
/// <param name="isDefault">是否返回默认值，为true是不管是否选择列自动均返回默认值</param>
/// <returns>>Excel区域在CAD中的列宽数组</returns>
public static double[] GetTableWidths(this Excel.Range rng, bool isDefault = false)
{
double[] tableWidths = new double[rng.Columns.Count];
string[,] excelContent = rng.GetExcelContent();
if (isDefault || Excel2CADSettings.e2cOptions.ColumnAuto)//如果选择列自动
{
for (int j = 0; j < rng.Columns.Count; j++)
{
//获得该列内容中最多的字节数
int maxChars = (from txt in rng.GetExcelContent().GetColumnAt(j)
let nChars = txt.Count()
select nChars).Max();
tableWidths[j] = maxChars * Excel2CADSettings.e2cOptions.TextHeight * Excel2CADSettings.e2cOptions.Scale
* Excel2CADSettings.e2cOptions.TextWidthFactor * 1.5;//默认宽度为该列最大文字宽度乘以1.5
}
}
else//不选择列自动
{
for (int j = 0; j < rng.Columns.Count; j++)
{
tableWidths[j] = Excel2CADSettings.e2cOptions.ColOptList[j].ColWidth * Excel2CADSettings.e2cOptions.Scale;
}
}
return(tableWidths);
}
