如果Excell的单元格里面是日期，前面显示2015年05月10日；后面的显示42134
也就是说：Text 和Value2的不同。
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using Microsoft.Office.Core; using Microsoft.Office.Interop.Excel; public partial class dingdan2_Default5 : System.Web.UI.Page { string str日期; string str单号; string str运费支付方式; string str收货人; string str电话; string str购货单位; string str收货地址; string str制单人; string str销售业务员; string str财务部; string str物流货运组; string str仓储组; string[,] str索引 = new string[8,10]; string[,] str数据 = new string[8,10]; protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { ((MasterPage)Master).setDaohang("订单管理->导入订单"); } } protected void Button1_Click(object sender, EventArgs e) { if ((FileUpload1.HasFile) && (null != FileUpload1.PostedFile)) { this.ListBox1.Items.Clear(); String fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower(); String[] allowedExtensions = { ".xls" }; for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension.ToLower() == allowedExtensions[i]) { this.Session["g_filename"] = FileUpload1.FileName; this.FileUpload1.SaveAs(Server.MapPath("uploadfiles\") + FileUpload1.FileName); this.ListBox1.Items.Insert(0, "文件上传成功! " + FileUpload1.FileName); } else { this.ListBox1.Items.Insert(0, "只能上传EXCEL文件!" + FileUpload1.FileName); } } } else { this.ListBox1.Items.Insert(0, "无法检测到上传的文件!"); } } //Excel 应用程序对象 Excel.Application ExcelRS; //Excel 工作簿对象 Excel._Workbook RSbook; //Excel 工作页对象 Excel._Worksheet RSsheet; //某一个单元格对象 Excel.Range range; protected void Button2_Click(object sender, EventArgs e) { try { //第一步:建立Excel应用程序 ExcelRS = new Excel.Application(); this.ListBox1.Items.Insert(0, "建立Excel应用程序成功!"); //第二步:建立Excel工作簿 RSbook = (Excel._Workbook)ExcelRS.Workbooks.Open(Server.MapPath("uploadfiles\")+this.Session["g_filename"].ToString(), Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); this.ListBox1.Items.Insert(0, "建立Excel工作簿成功!"); //第三步:设置第一个工作溥 RSsheet = (Excel._Worksheet)RSbook.Sheets.get_Item(1); this.ListBox1.Items.Insert(0, "建立Excel工作页成功!"); //第四步:读取数据 range = (Excel.Range)RSsheet.get_Range("B2", Type.Missing); this.str日期 = range.Text.ToString(); this.ListBox1.Items.Insert(0,"日期:"+this.str日期); range = (Excel.Range)RSsheet.get_Range("G2", Type.Missing); this.str单号= range.Value2.ToString(); this.ListBox1.Items.Insert(0, "单号:" + this.str单号); range = (Excel.Range)RSsheet.get_Range("B3", Type.Missing); this.str运费支付方式 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "运费支付方式:" + this.str运费支付方式); range = (Excel.Range)RSsheet.get_Range("D3", Type.Missing); this.str收货人 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "收货人:" + this.str收货人); range = (Excel.Range)RSsheet.get_Range("G3", Type.Missing); this.str电话 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "电话:" + this.str电话); range = (Excel.Range)RSsheet.get_Range("B4", Type.Missing); this.str购货单位 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "购货单位:" + this.str购货单位); range = (Excel.Range)RSsheet.get_Range("B5", Type.Missing); this.str收货地址 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "收货地址:" + this.str收货地址); range = (Excel.Range)RSsheet.get_Range("B15", Type.Missing); this.str制单人 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "制单人:" + this.str制单人); range = (Excel.Range)RSsheet.get_Range("E15", Type.Missing); this.str销售业务员 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "销售业务员:" + this.str销售业务员); range = (Excel.Range)RSsheet.get_Range("I15", Type.Missing); this.str财务部 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "财务部:" + this.str财务部); range = (Excel.Range)RSsheet.get_Range("B16", Type.Missing); this.str物流货运组 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "物流货运组:" + this.str物流货运组); range = (Excel.Range)RSsheet.get_Range("E16", Type.Missing); this.str仓储组 = range.Value2.ToString(); this.ListBox1.Items.Insert(0, "仓储组:" + this.str仓储组); for (int i = 7; i < 15; i++) { str索引[i - 7, 0] = "A" + i.ToString(); str索引[i - 7, 1] = "B" + i.ToString(); str索引[i - 7, 2] = "C" + i.ToString(); str索引[i - 7, 3] = "D" + i.ToString(); str索引[i - 7, 4] = "E" + i.ToString(); str索引[i - 7, 5] = "F" + i.ToString(); str索引[i - 7, 6] = "G" + i.ToString(); str索引[i - 7, 7] = "H" + i.ToString(); str索引[i - 7, 8] = "I" + i.ToString(); str索引[i - 7, 9] = "J" + i.ToString(); } //读取数据 for (int i = 0; i < 8; i++) { for (int j = 0; j < 10; j++) { range = (Excel.Range)RSsheet.get_Range(str索引[i,j], Type.Missing); str数据[i,j] = range.Text.ToString(); this.ListBox1.Items.Add(i.ToString() + ":" + j.ToString() + "=" + str数据[i, j]); } } } catch (System.Exception ex) { this.ListBox1.Items.Insert(0,"异常! "+ex.ToString() + "-" +ex.Message +"-"+ex.Source); } finally { ExcelRS.Quit(); } } }