c# - 如何使用 EPPLUS 从 Excel 电子表格单元格中获取值？

Question

我正在使用 EPPlus 库从数据表创建 excel。

这是我的做法:

using (ExcelPackage pck = new ExcelPackage())
{
   ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Demo");
   ws.Cells["A5:I5"].LoadFromDataTable(dt, true); 
   ws.DefaultColWidth = 25;

   var headerCell = ws.Cells["A5:I5"];
   headerCell.Style.Fill.PatternType = ExcelFillStyle.Solid;
   headerCell.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.BurlyWood);
   var headerFont = headerCell.Style.Font;
   headerFont.Bold = true; 

   int totalRow = ws.Dimension.End.Row;
   int totalCol = ws.Dimension.End.Column;
   using (ExcelRange rng = ws.Cells[6,1,totalRow,totalCol])   
   {
       rng.Style.Fill.PatternType = ExcelFillStyle.Solid;
       rng.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.Bisque);

       long n = 0;
       for (int row = 6; row <= totalRow; row++)
       {
           for (int col = 1; col <= 9; col++)
           {
                string colVol = (string)ws.Cells[row, col].Value;
                bool isNumeric = long.TryParse(colVol, out n);
                if (isNumeric && colVol.Length > 10)
                {
                      //ws.Cells[row, col] //need to apply a css style
                }
           }
       }
   }
   ws.Cells["A4"].LoadFromText(name);
   Response.AddHeader("content-disposition", "inline;filename=" + name + ".xls");
   Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
   Response.BinaryWrite(pck.GetAsByteArray());   
}

我需要将样式应用于电子表格中满足特定条件的某些单元格。

这是之前代码在循环中构建表格时的做法:

for (int i = 0; i < dt.Columns.Count; i++)
{
    td = new TableCell();
    td.Text = dt.Rows[j][i].ToString();

    n = 0;
    bool isNumeric = long.TryParse(td.Text, out n);
    if (isNumeric && td.Text.Length > 10)
       td.Attributes.Add("style", @"mso-number-format:\@");

    tr.Cells.Add(td);
 }

我如何从单元格中获取值以检查使用 EPPlus 方法格式化值的条件？

Answer 1

(更新答案以反射(reflect) OP 问题的编辑和评论)

只是做:

ws.Cells[row, col].Style.Numberformat.Format = "@";

这将告诉 excel 使用文本格式而不是数字格式。