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 void DoWorkCalThread(Action <int> percent) { mExcel = new Excel(SalaryFile, false); mExcel.SetCurrentWorksheet(SalaryDate); percent(10); float proc = (float)0.0000; for (int i = 2; i <= mExcel.RowCount; i++) { NewStaffSalary mAssessSource = new NewStaffSalary(); mAssessSource.StaffName = mExcel.GetCell(i, 2); mAssessSource.ProbationSalary = mExcel.GetCell(i, 8); mAssessSource.FullSalary = mExcel.GetCell(i, 9); NewStaffSalaryList.Add(mAssessSource); proc = (float)i / (float)mExcel.RowCount * (float)100; percent((int)proc); } int ProcessPos = 0; AssessSourcecollection.Clear(); mExcel = new Excel(ExportFile, false); mExcel.SetCurrentWorksheet(Date); percent(10); for (int i = 2; i <= mExcel.RowCount; i++) { AssessSource mAssessSource = new AssessSource(); mAssessSource.OrderNumber = i - 1; mAssessSource.StaffName = mExcel.GetCell(i, 1); mAssessSource.StaffDep = mExcel.GetCell(i, 2); mAssessSource.StaffPostion = mExcel.GetCell(i, 3); mAssessSource.EntryTime = mExcel.GetCell(i, 4); mAssessSource.EndTime = mExcel.GetCell(i, 5); mAssessSource.PositiveTime = mExcel.GetCell(i, 6); mAssessSource.CompanyInfo = mExcel.GetCell(i, 10); FillmAssessSourceSalary(ref mAssessSource); string tempre = mAssessSource.GetTimePercent(DateXiuxiRi, Date); if (tempre != "") { mExcel.SetCellComment(i, 6, tempre); } AssessSourcecollection.Add(mAssessSource); } percent(70); SortByCompanyAndPercent(); string tempzhuanzheng = ""; mExcel.Save(); mExcel.Visible = true; tempzhuanzheng = mIniFile.IniReadValue("AssessFile", "转正导出文件", tempzhuanzheng); ExportToExcel(AppDomain.CurrentDomain.BaseDirectory + tempzhuanzheng); percent(100); mExcel.Clean(); mExcel.Dispose(); }