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
