public static MsExcel._Workbook Shashade(MsExcel.Application appExcel) { _Workbook ExcelBooks = null; appExcel.Visible = false; ExcelBooks = appExcel.Workbooks.Add(); string Sheet_Name = "站点数据"; _Worksheet ExcelSheets = TU.Add_Sheets(ExcelBooks, Sheet_Name);//添加一个sheet ExcelSheets.Name = Sheet_Name; System.Data.DataTable dalaopo = new System.Data.DataTable("dalaopo"); dalaopo.Columns.Add("站点", typeof(double)); // dalaopo.Columns.Add("降水数据", typeof(double)); System.Data.DataTable jieguoTB = new System.Data.DataTable(); double[] n = new double[] { 129, 135, 128, 132, 99, 113, 157, 81, 70, 111, 78, 138, 103, 88, 110, 91 }; double[] T = new double[] { 5, 10, 20, 50 }; for (int i = 0; i < n.Length; i++) { List <double> gailvL = new List <double>(); for (int j = 0; j < T.Length; j++) { double gailv = 1 - 50 / (n[i] * T[j]); gailvL.Add(gailv); } double[] gailvd = gailvL.ToArray(); string[] gailvS = MYTUW.TUW.doublearrTOstring(gailvd); System.Data.DataTable jieguo = MYTUW.TUW.ArToDT1(gailvS); jieguoTB.Merge(jieguo); } #region /* for (int i = 1; i < RawDataStr_A.Length; i++) * { * char[] seperators = { ',' }; * string[] R_str1 = TU.ParseStringTo_Array<string>(RawDataStr_A[i], seperators); * * double zhandian = Convert.ToDouble(R_str1[0]); * string jiangshuistr = Convert.ToString(R_str1[R_str1.Length -1]); * double jiangshui= Convert.ToDouble(R_str1[R_str1.Length - 1]); * if (Convert .ToDouble ( jiangshuistr) > 30000) * { * string housanwei = Convert.ToString(R_str1[R_str1.Length - 1]).Substring(Convert.ToString(R_str1[R_str1.Length - 1]).Length - 3); * // Console.WriteLine(housanwei); * if (Convert .ToDouble (housanwei)>500&& Convert.ToDouble(housanwei)!=700) * { * jiangshui = Convert.ToDouble(housanwei); * } * else * { * jiangshui = 1; * } * * } * dalaopo.Rows.Add(zhandian, jiangshui * 0.1); * * * } * var groupNew = from row in dalaopo.AsEnumerable() * group row by new * { * zhandian = (row.Field<double>("站点")) * } * into groupRes * orderby groupRes.Key.zhandian * select groupRes; * //把分完组的每个表格放入DS中 * DataSet RTB_Grp = new DataSet(); * foreach (var eachGroup in groupNew) * { * System.Data.DataTable TBMid1 = eachGroup.CopyToDataTable(); * * RTB_Grp.Tables.Add(TBMid1); * } * //对每天的数据进行处理并放入 Traffic_TB中RTB_Grp.Tables .Count * for (int i=0;i< RTB_Grp.Tables.Count; i++) * { * System.Data.DataTable meigezhandian = RTB_Grp.Tables[i]; * List<double> baoyurishu = new List<double>(); * List<double> quannianyuliang = new List<double>(); * for (int j=0;j < meigezhandian.Rows.Count;j++) * { * double yuliang = Convert.ToDouble(meigezhandian.Rows[j][1]); * quannianyuliang.Add(yuliang); * if (yuliang>50) * { * baoyurishu.Add(yuliang); * } * } * double baoyutianshu = baoyurishu.Count; * double baoyuliang = baoyurishu.Sum(); * double baoyuqiangdu = baoyuliang / baoyutianshu; * double zongyuliang = quannianyuliang.Sum(); * double baoyugongxianlv = baoyuliang / zongyuliang; * jieguoTB.Rows.Add(Convert.ToDouble(meigezhandian.Rows[0][0]), baoyutianshu, * baoyuliang, baoyuqiangdu, baoyugongxianlv); * } */ #endregion MYTUW.TUW.DTToExcel(jieguoTB, ExcelSheets, 2, 1); MYTUW.TUW.Delete_sheet(appExcel, ExcelBooks); return(ExcelBooks); }