public void ExportToExcel(string SaveFileName) { Excel mexportExcel = new Excel(SaveFileName, false); string datetime = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " " + DateTime.Now.Hour.ToString() + "'" + DateTime.Now.Minute.ToString() + "'" + DateTime.Now.Second.ToString(); string sheetname = "计算转正天数" + datetime; mexportExcel.AddWorksheet(sheetname); mexportExcel.SetCurrentWorksheet(sheetname); for (int i = 0; i < AssessSourcecollection.Count; i++) { if (AssessSourcecollection[i].TimePercent == "无") { continue; } mexportExcel.SetCell(i + 1, 1, AssessSourcecollection[i].OrderNumber.ToString()); mexportExcel.SetCell(i + 1, 2, AssessSourcecollection[i].StaffName); mexportExcel.SetCell(i + 1, 3, AssessSourcecollection[i].StaffDep); mexportExcel.SetCell(i + 1, 4, AssessSourcecollection[i].StaffPostion); mexportExcel.SetSelFormatText(i + 1, 5); mexportExcel.SetCell(i + 1, 5, AssessSourcecollection[i].TimePercent); mexportExcel.SetCell(i + 1, 6, AssessSourcecollection[i].mNewStaffSalary.ProbationSalary); mexportExcel.SetCell(i + 1, 7, AssessSourcecollection[i].mNewStaffSalary.FullSalary); mexportExcel.SetCell(i + 1, 8, AssessSourcecollection[i].mNewStaffSalary.balance); mexportExcel.SetCell(i + 1, 9, AssessSourcecollection[i].CompanyInfo); } for (int i = 1; i < 10; i++) { mexportExcel.ColumnAutoFit(1, i); } mexportExcel.SaveAs2003(SaveFileName); mexportExcel.Save(); mexportExcel.Visible = true; }
public int ExcelOutResult() { TargetValues = mTargetProjectInfoArray; mExcel.AddWorksheet(StartMonth + "-" + EndMonth + "汇总"); int Row = 1; float ProjectTotalMoney = (float)0.0; List <float> SingelSumList = new List <float>(); for (int i = 0; i < mTargetProjectInfoArray.Count; i++) { if (mTargetProjectInfoArray[i].ProjectId.IndexOf("项目名称") != -1) { mExcel.SetCell(Row, 1, mTargetProjectInfoArray[i].ProjectName + splitchar); } else { mExcel.SetCell(Row, 1, mTargetProjectInfoArray[i].ProjectName + splitchar + mTargetProjectInfoArray[i].ProjectId); } mExcel.SetRangeBackground(Row, 1, Row, 8, 33); mExcel.SetCell(++Row, 1, "姓名"); mExcel.SetCell(Row, 2, "部门"); mExcel.SetCell(Row, 3, "加班费"); mExcel.SetRangeBackground(Row, 3, Row, 3, 6); float sum = (float)0.000; for (int j = 0; j < mTargetProjectInfoArray[i].MyProjectDetailCollection.Count; j++) { sum += mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffMoney; mExcel.SetCell(++Row, 1, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffName); mExcel.SetCell(Row, 2, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffDep); mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffMoney.ToString()); } SingelSumList.Add(sum); ProjectTotalMoney += sum; mExcel.SetCell(++Row, 1, "总计:"); mExcel.SetCell(Row, 3, sum.ToString()); mExcel.SetRangeBackground(Row, 1, Row, 3, 34); mExcel.SetCell(++Row, 1, "费用百分比:"); mExcel.SetRangeBackground(Row, 1, Row, 3, 34); ++Row; ++Row; } mExcel.SetCell(++Row, 1, "项目总数: " + mTargetProjectInfoArray.Count); mExcel.SetRangeBackground(Row, 1, Row, 5, 48); mExcel.SetCell(++Row, 1, "项目全部支出: " + ProjectTotalMoney.ToString()); mExcel.SetRangeBackground(Row, 1, Row, 5, 48); Row = 1; for (int i = 0; i < mTargetProjectInfoArray.Count; i++) { float precentproject = (SingelSumList[i] / ProjectTotalMoney) * (float)100.00; Row = GetPrecentRow(Row, mTargetProjectInfoArray[i]); mExcel.SetCell(Row, 3, precentproject.ToString() + "%"); Row += 2; } MessageBox.Show("合并完成!"); mExcel.Visible = true; return(1); }
public int ExcelOutResult() { TargetValues = mTargetProjectInfoArray; mExcel.AddWorksheet(StartMonth + "-" + EndMonth + "汇总"); int Row = 1; float ProjectTotalMoney = (float)0.0; List <float> SingelSumList = new List <float>(); mExcel.SetCell(Row, 1, StartMonth + "-" + EndMonth + " 项目总数: " + mTargetProjectInfoArray.Count + "个"); mExcel.SetCell(Row, 6, StartMonth + "-" + EndMonth + " 项目全部支出: " + TotalMoneyOnAllProject.ToString() + "元"); mExcel.SetRangeBackground(Row, 1, Row, 16, 48); mExcel.SetRangeFontColor(Row, 1, Row, 16, 2); ++Row; ++Row; for (int i = 0; i < mTargetProjectInfoArray.Count; i++) { if (mTargetProjectInfoArray[i].ProjectId.IndexOf("项目名称") != -1) { mExcel.SetCell(Row, 1, "No " + (i + 1).ToString() + ". " + mTargetProjectInfoArray[i].ProjectName + splitchar); } else { mExcel.SetCell(Row, 1, "No " + (i + 1).ToString() + ". " + mTargetProjectInfoArray[i].ProjectName + splitchar + mTargetProjectInfoArray[i].ProjectId); } mExcel.SetRangeBackground(Row, 1, Row, 16, 33); mExcel.SetCell(++Row, 1, "姓名"); mExcel.SetCell(Row, 2, "部门"); mExcel.SetCell(Row, 3, "加班费"); mExcel.SetRangeBackground(Row, 3, Row, 3, 6); for (int j = 0; j < mTargetProjectInfoArray[i].MyProjectDetailCollection.Count; j++) { mExcel.SetCell(++Row, 1, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffName); mExcel.SetCell(Row, 2, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffDep); mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].MyProjectDetailCollection[j].ProjectStaffMoney.ToString()); } mExcel.SetCell(++Row, 1, "项目人数:"); mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].MyProjectDetailCollection.Count.ToString() + "人"); mExcel.SetRangeBackground(Row, 1, Row, 3, 34); mExcel.SetCell(++Row, 1, "项目费用:"); mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].TotalMoney.ToString() + "元"); mExcel.SetRangeBackground(Row, 1, Row, 3, 34); mExcel.SetCell(++Row, 1, "费用百分比:"); mExcel.SetCell(Row, 3, mTargetProjectInfoArray[i].TotalPercent.ToString() + "%"); mExcel.SetRangeBackground(Row, 1, Row, 3, 34); ++Row; ++Row; } return(1); }