Range or = (Excel.Range)sh.Columns[0, Convert.ToInt32(ColumnType.GetKey(i))];
switch ((ExcelColumnDataType)ColumnType.GetByIndex(i))
{
case ExcelColumnDataType.Currency:
{
or.NumberFormat = "#,##0.0000";
break;
}
case ExcelColumnDataType.DateTime:
{
or.NumberFormat = "yyyy-mm-dd hh:mm;@";
break;
}
case ExcelColumnDataType.Normal:
{
break;
}
case ExcelColumnDataType.Number:
{
or.NumberFormat = "0.00_ ";
break;
}
case ExcelColumnDataType.Percent:
{
or.NumberFormat = "0.00%";
break;
}
case ExcelColumnDataType.Text:
{
or.NumberFormat = "@";
break;
}
case ExcelColumnDataType.Integer:
{
or.NumberFormat = "0_ ";
break;
}
default:
{
goto case ExcelColumnDataType.Normal;
}
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(or);
or = null;注意,我这个代码的第一句要出错,其他都对的
switch ((ExcelColumnDataType)ColumnType.GetByIndex(i))
{
case ExcelColumnDataType.Currency:
{
or.NumberFormat = "#,##0.0000";
break;
}
case ExcelColumnDataType.DateTime:
{
or.NumberFormat = "yyyy-mm-dd hh:mm;@";
break;
}
case ExcelColumnDataType.Normal:
{
break;
}
case ExcelColumnDataType.Number:
{
or.NumberFormat = "0.00_ ";
break;
}
case ExcelColumnDataType.Percent:
{
or.NumberFormat = "0.00%";
break;
}
case ExcelColumnDataType.Text:
{
or.NumberFormat = "@";
break;
}
case ExcelColumnDataType.Integer:
{
or.NumberFormat = "0_ ";
break;
}
default:
{
goto case ExcelColumnDataType.Normal;
}
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(or);
or = null;注意,我这个代码的第一句要出错,其他都对的
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货