C#Excel文件上传生成.docx

public bool uploadFile(string path)/上?传? string dt = path.Split(); string cc = ; string strUploadUrl = /PolicyManager/PolicyImport.aspx;/批量?上?传?政t策?的?地?址 string strRequesMsg = string.Empty; ;/返回?的?数y据Y信?息 #region 获?取?批量?上?传?政t策?页3面?信?息 try string NO = textBox1.Text; string postlogin = txt_UserName=*&txt_password=*&text_code= + NO + &dl=%E7%99%BB+%E5%BD%95; http.ResponseEncoding = UTF-8; string str1 = http.PostString(/CallMeLogin.aspx, postlogin, /home/main.html); strRequesMsg = http.GetString(strUploadUrl, false, /index.aspx); cc = http.GetStrCookies(); catch return false; string sta = value=0-9A-z/+=+; Regex stat= new Regex(sta); MatchCollection statt=stat.Matches(strRequesMsg); string state = ; try state = statt0.Value.Replace(value=, ); catch return false; #endregion #region 生成http协-议头部?信?息 var boundary = - + DateTime.Now.Ticks.ToString(x); var sbHead = new StringBuilder(); var sbFoot = new StringBuilder(); /http协-议头 sbHead.Append(- + boundary); sbHead.Append(rn); sbHead.Append(Content-Disposition: form-data; name=_MSPVSTATE + ); sbHead.Append(rnrn); sbHead.Append(state); sbHead.Append(rn); sbHead.Append(- + boundary); sbHead.Append(rn); sbHead.Append(Content-Disposition: form-data; name=_MSPVSTATE_ZIP + ); sbHead.Append(rnrn); sbHead.Append(statt1.Value.Replace(value=, ); sbHead.Append(rn); sbHead.Append(- + boundary); sbHead.Append(rn); sbHead.Append(Content-Disposition: form-data; name=_VIEWSTATE + ); sbHead.Append(rnrnrn); sbHead.Append(- + boundary); sbHead.Append(rn); sbHead.Append(Content-Disposition: form-data; name=fupExcel; filename= + dtdt.Length - 1 + ); sbHead.Append(rn); sbHead.Append(Content-Type: application/vnd.ms-excel); sbHead.Append(rnrn); /http协-议尾2 sbFoot.Append(rn); sbFoot.Append(- + boundary); sbFoot.Append(rn); sbFoot.Append(Content-Disposition: form-data; name=btnImport); sbFoot.Append(rnrnrn); sbFoot.Append(Content-Disposition: form-data; name=ExcelName); sbFoot.Append(rnrnrn); sbFoot.Append(导?入?); sbFoot.Append(rn); sbFoot.Append(- + boundary + -); sbFoot.Append(rn); #endregion var dataHead = Encoding.GetEncoding(gb2312).GetBytes(sbHead.ToString(); var dataFoot = Encoding.GetEncoding(gb2312).GetBytes(sbFoot.ToString(); byte dataFile = null; FileStream excelStream = null; try excelStream = new FileStream(path, FileMode.Open, FileAccess.Read); dataFile = new byteexcelStream.Length; excelStream.Read(dataFile, 0, dataFile.Length); catch (Exception ex) return false; finally if (excelStream != null) excelStream.Close(); #region 执行D上?传?操作 try var uploadRequest = HttpWebRequest.Create(/PolicyManager/PolicyImport.aspx) as HttpWebRequest; uploadRequest.Method = POST; uploadRequest.ServicePoint.Expect100Continue = false; / 取?消?100-continue uploadRequest.CookieContainer = http.GetContainerFromString(cc, ); uploadRequest.ContentLength = dataHead.Length + dataFile.Length + dataFoot.Length; uploadRequest.Accept = text/html, application/xhtml+xml, */*; uploadRequest.Headers.Add(Accept-Language, zh-CN); uploadRequest.Referer = /policymanager/policyimport.aspx; uploadRequest.UserAgent = Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0); uploadRequest.Headers.Add(Accept-Encoding, gzip, deflate); uploadRequest.ContentType = multipart/form-data; boundary= + boundary; uploadRequest.Host = ; uploadRequest.AllowAutoRedirect = false; var reqStream = uploadRequest.GetRequestStream(); reqStream.Write(dataHead, 0, dataHead.Length); reqStream.Write(dataFile, 0, dataFile.Length); reqStream.Write(dataFoot, 0, dataFoot.Length); reqStream.Close(); var response = uploadRequest.GetResponse(); using (var resStream = response.GetResponseStream() using (var reader = new StreamReader(resStream, Encoding.GetEncoding(utf-8) strRequesMsg = reader.ReadToEnd(); response.Close(); Regex itemReg = new Regex(0-9+条?政t策?被?成功|导?入?到?数y据Y库a！?, RegexOptions.IgnoreCase); if (itemReg.IsMatch(strRequesMsg) return true; else return true; catch return false; #endregion private void button4_Click(object sender, EventArgs e) string path = textBox8.Text; if (uploadFile(path) = true) MessageBox.Show(上?传?成功|); else MessageBox.Show(上?传?失败); public void CreatExcel1(string path, DataTable dt)/生成Excel System.Reflection.Missing miss = System.Reflection.Missing.Value; Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbooks books = (Microsoft.Office.Interop.Excel.Workbooks)excel.Workbooks; Microsoft.Office.Interop.Excel.Workbook book = (Microsoft.Office.Interop.Excel.Workbook)(books.Add(C:UsersAdministratorDesktop8000yi模板?8000yi.xls); Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.ActiveSheet; for (int i = 0; i dt.Rows.Count; i+) sheet.Cellsi + 2, 1 = CZ; sheet.Cellsi + 2, 2 = dt.Rowsi7.ToString(); sheet.Cellsi + 2, 3 = ; sheet.Cellsi + 2, 4 = dt.Rowsi8.ToString(); sheet.Cellsi + 2, 5 = dt.Rowsi10.ToString(); sheet.Cellsi + 2, 6 = ; sheet.Cellsi + 2, 7 = 单程; sheet.Cellsi + 2, 8 = dt.Rowsi11.ToString(); sheet.Cellsi + 2, 9 = dt.Rowsi11.ToString(); sheet.Cellsi + 2, 10 = ; sheet.Cellsi + 2, 11 = ; sheet.Cellsi + 2, 12 = B2B; sheet.Cellsi + 2, 13 = dt.Rowsi9.ToString(); sheet.Cellsi + 2, 14 = dt.Rowsi3.ToString(); sheet.Cellsi + 2, 15 = dt.Rowsi4.ToString(); sheet.Cellsi + 2, 16 = dt.Rowsi5.ToString(); sheet.Cellsi + 2, 17 = dt.Rowsi6.ToString(); sheet.Cellsi + 2, 18 = ; sheet.Cellsi + 2, 19