{
//取得Range,可以取单元格,也可以取一个范围
Range cell = (Range)wksheet.Cells[i, j];
Range row = wksheet.Range[wksheet.Cells[i, 1], wksheet.Cells[i, columnLength]];
//Range的Value2最后用string赋值,不然会自动匹配容易发生乱码
cell.Value2 = StringValueConverter.Convert(dataDetail[j - 1]);
//边框
cell.Borders.Color = System.Drawing.Color.LightSteelBlue;
//设置背景色,字体色
cell.Interior.ThemeColor = XlThemeColor.xlThemeColorAccent1;
cell.Interior.Color = System.Drawing.Color.FromArgb(219, 229, 241);
cell.Interior.ColorIndex = 31;
cell.Font.Color = System.Drawing.Color.White;
//设置Excel过滤
row.AutoFilter(1, Type.Missing, XlAutoFilterOperator.xlAnd, Type.Missing, true);
}
public static class StringValueConverter
{
public static string Convert(Object value)
{
if (value == null)
return string.Empty;
if (value is string)
return value.ToString();
if (value is int)
{
int intValue = (int)value;
return intValue.ToString();
}
if (value is double)
{
double doubleValue = (double)value;
return doubleValue.ToString();
}
if (value is object)
{
return value.ToString();
}
throw new NotImplementedException();
}
}
Excel的一些常见用法,列举一二。