Excel 格式和赋值

{
  //取得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的一些常见用法，列举一二。