worksheet.get_Range(worksheet.Cells[j, 1], worksheet.Cells[j, 2]).Merge(0); worksheet.get_Range(worksheet.Cells[j, 1], worksheet.Cells[j, 2]).Font.Bold = true; worksheet.get_Range(worksheet.Cells[j, 1], worksheet.Cells[j, 2]).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; worksheet.Cells[j, 1] = "合計"; setCell(worksheet, j, 7, "=SUM(G4:G" + (j - 1) + ")"); setCell(worksheet, j, 8, "=SUM(H4:H" + (j - 1) + ")"); setCell(worksheet, j, 9, "=SUM(I4:I" + (j - 1) + ")"); setCell(worksheet, j, 10, "=SUM(J4:J" + (j - 1) + ")"); setCell(worksheet, j, 11, "=SUM(K4:K" + (j - 1) + ")"); setCell(worksheet, j, 12, "=SUM(L4:L" + (j - 1) + ")"); setCell(worksheet, j, 13, "=SUM(M4:M" + (j - 1) + ")"); setCell(worksheet, j, 14, "=SUM(N4:N" + (j - 1) + ")"); setCell(worksheet, j, 15, "=SUM(O4:O" + (j - 1) + ")"); setCell(worksheet, j, 16, "=SUM(P4:P" + (j - 1) + ")"); setCell(worksheet, j, 17, "=SUM(Q4:Q" + (j - 1) + ")"); setCell(worksheet, j, 18, "=SUM(R4:R" + (j - 1) + ")"); setCell(worksheet, j, 19, "=SUM(S4:S" + (j - 1) + ")"); setCell(worksheet, j, 20, "=SUM(T4:T" + (j - 1) + ")"); worksheet.get_Range("A" + j, "T" + j).Borders.LineStyle = 1; //worksheet.Delete();
((Excel.Worksheet)workbook.Sheets.get_Item(1)).Visible = Excel.XlSheetVisibility.xlSheetHidden;