只需在前面加上单引号 " ' "可,如下
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] = "";