C#，导出Excel时，第一个为0时不显示，

最新推荐文章于 2024-04-23 10:05:26 发布

wz654273122

最新推荐文章于 2024-04-23 10:05:26 发布

阅读量9.3k

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/wz654273122/article/details/41826575

版权

本文介绍了在C#中导出Excel时，如何处理首位为0但不显示的问题。通过在数据前添加单引号，如`dcv[2] = "'" + drBH["BH_CHDZ"].ToString();`，可以确保0会被正确显示。代码示例展示了创建Excel工作簿、设置单元格值和处理数据的过程。

摘要由CSDN通过智能技术生成

只需在前面加上单引号 " ' "可，如下

dcv[2] ="'" +drBH["BH_CHDZ"].ToString(); ;//补货仓

详细代码如下：

private void Report_BHD_Excel_MB()//轉Excel模板;
{

if (dsforexcel != null)//
{
dsforexcel.Clear();
}
dsforexcel = Query_ToExcel_MB(getwherestr());

//DataSet dsforexcel = BASEINFO.DecompressDS(Pos.Report_BHD(getwherestr()));
#region tran_to_excel_mb
Excel.Application app = new Excel.Application();

_Workbook wkb = app.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
_Worksheet wks = (_Worksheet)wkb.ActiveSheet;
app.ActiveWindow.DisplayZeros = false;
wks.Visible = XlSheetVisibility.xlSheetVisible;
wks.Name = "補貨excel模板(橫排)";
Range wksRange;
string[] cellValue = new string[100];

cellValue[0] = ""; cellValue[1] = ""; cellValue[2] = ""; cellValue[3] = "";
cellValue[4] = ""; cellValue[5] = "";

cellValue[6] = "(幼)130"; cellValue[7] = "140"; cellValue[8] = "150";
cellValue[9] = "160"; cellValue[10] = "170"; cellValue[11] = "180"; cellValue[12] = "190";
cellValue[13] = "200"; cellValue[14] = "210"; cellValue[15] = "220"; cellValue[16] = "230";
cellValue[17] = "240"; cellValue[18] = "250"; cellValue[19] = "260"; cellValue[20] = "270";
cellValue[21] = "";

wksRange = wks.get_Range("A1", "AF1");
#if OFFICEXP
wksRange.set_Value(Missing.Value, cellValue);
#else
wksRange.Value = cellValue;
#endif
cellValue[0] = "导入时，删除灰色的行和列栏位. 同时把单号改成数字:1 2 3 4 5..."; cellValue[1] = ""; cellValue[2] = ""; cellValue[3] = "";
cellValue[4] = ""; cellValue[5] = "";