Example #1
0
        //9-30
        public void MergeToFinalResult()
        {
            for (int i = 0; i < mTargetFileFormatList.Count; i++)
            {
                mFinalFileFormatList.Add(GetMergedData(mTargetFileFormatList[i]));
            }


            mExcel = new Excel(AppDomain.CurrentDomain.BaseDirectory + "导出结果.xls", true);
            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;

            mExcel.AddWorksheet(sheetname);

            int curwriteline = 1;

            for (int i = 0; i < mFinalFileFormatList.Count; i++)
            {
                OutToExcel(mFinalFileFormatList[i], ref curwriteline, mExcel);
            }
            mExcel.ColumnAutoFit(1, 20);
            MessageBox.Show("Done!");
        }