public int toSheet(C2017sum item, Excel.Worksheet thisWorkSheet, int curRow, int incRow) { thisWorkSheet.Cells[2, 2] = item.机构; thisWorkSheet.Cells[3, 2] = item.姓名; thisWorkSheet.Cells[3, 4] = item.职工号; thisWorkSheet.Cells[4, 2] = item.身份证号码; thisWorkSheet.Cells[7, 1] = item.年合计收入; thisWorkSheet.Cells[7, 2] = item.工资; thisWorkSheet.Cells[7, 3] = item.奖金; thisWorkSheet.Cells[7, 4] = item.奖励性补贴; string srcStr = "1:9"; var srcSheet = thisWorkSheet.Range[srcStr]; curRow = curRow + incRow; string dstStr = $"{curRow}:{curRow + incRow - 1}"; var dstSheet = thisWorkSheet.Range[dstStr]; WriteLine($"src:{srcStr}, dst:{dstStr}"); srcSheet.Copy(dstSheet); return(curRow); }
public int toSheet2(C2017sum item, Excel.Worksheet thisWorkSheet, int curRow, int incRow, int itemCount, int itemPerPage) { thisWorkSheet.Cells[2, 2] = item.机构; thisWorkSheet.Cells[3, 2] = item.姓名; thisWorkSheet.Cells[3, 4] = item.职工号; thisWorkSheet.Cells[4, 2] = item.身份证号码; thisWorkSheet.Cells[7, 1] = item.年合计收入; thisWorkSheet.Cells[7, 2] = item.工资; thisWorkSheet.Cells[7, 3] = item.奖金; thisWorkSheet.Cells[7, 4] = item.奖励性补贴; string srcStr = "1:9"; var srcSheet = thisWorkSheet.Range[srcStr]; curRow = curRow + incRow * itemPerPage; if (curRow >= (itemCount + 1) * incRow + 1) { int pageNum = curRow / (incRow * itemPerPage); WriteLine($"分页:{pageNum}"); curRow = curRow - pageNum * itemPerPage * incRow + incRow; } string dstStr = $"{curRow}:{curRow + incRow - 1}"; WriteLine($"src:{srcStr}, dst:{dstStr}"); var dstSheet = thisWorkSheet.Range[dstStr]; srcSheet.Copy(dstSheet); return(curRow); }