def makeExpensesExcel(self, targetYm, expensesList, employeeName, path): expensesName = '経費精算書' year, month = DateUtilLib.splitYm(targetYm) lastDay = DateUtilLib.getLastDay(StringOperationLib.toInt(year), StringOperationLib.toInt(month)) ym = DateUtilLib.getYmFormatJapanese(targetYm) ymd = ym + StringOperationLib.toString(lastDay) + '日' name = StringOperationLib.replace(employeeName, " ", "") excel = PythonExcelLib() excel.setPageA4 excel.setOrientation() excel.rename(expensesName) #タイトル等共通部分 self.setCommon(excel, ym, ymd, name, expensesName) #項目名 self.setExpensesTitle(excel) #データ lastRow = self.setListValue(excel, expensesList) #合計 self.setCostSumValue(excel, lastRow, 'E') #体裁 self.expensesExcelFormat(excel, copy(lastRow)) excel.save(path + expensesName + '.xlsx') #オブジェクト解放 del excel
def makeExcel(self, dt, recordMapList, totalList, name): dt = StringOperationLib.mid(dt, 1, 7) ym = DateUtilLib.getYmFormatJapanese(dt) name = StringOperationLib.replace(name, " ", "") excel = PythonExcelLib() excel.setPageA4 excel.rename('月間作業実績報告書') #タイトル等共通部分 self.setCommon(excel, ym, name) #勤怠表の項目名 self.setTimeRecordTitle(excel) #勤怠表 lastRow = self.setTimeRecordValue(excel, recordMapList) #合計行 self.setTimeRecordTotalValue(excel, totalList, copy(lastRow)) #押印欄等 self.setOtherArea(excel, copy(lastRow)) #体裁 self.setFormat(excel, copy(lastRow)) excel.save(Config.getConf('TimeRecordAutoDLinfo', 'download_path') + '本社提出用_' + ym + '勤怠表_' + name + '.xlsx') #オブジェクト解放 del excel