class OutputWorkbook:
CONTRACT_SHEET = u"合同"
INVOICE_SHEET = u"箱单发票"
DETAILS_SHEET = u"出仓明细"
def __init__(self,template, **kwargs):
self.template = template
#self.dest = dest
self.wb = load_workbook(template)
self.contract = Contract(self.wb.get_sheet_by_name(self.CONTRACT_SHEET))
self.invoice = Invoice(self.wb.get_sheet_by_name(self.INVOICE_SHEET))
self.details = Details(self.wb.get_sheet_by_name(self.DETAILS_SHEET))
def get_contract_sheet(self):
return self.contract
def get_invoice_sheet(self):
return self.invoice
def get_detail_sheet(self):
return self.details
def save(self,dest=None):
if dest is None:
dest = self.template
self.contract.fix_borders()
self.details.fix_borders()
#save here
self.contract.remove_empty_rows()
self.invoice.remove_empty_rows()
self.details.remove_empty_rows()
self.wb.save(dest)
class OutputWorkbook:
CONTRACT_SHEET = u"合同"
INVOICE_SHEET = u"箱单发票"
DETAILS_SHEET = u"出仓明细"
def __init__(self, template, **kwargs):
self.template = template
#self.dest = dest
self.wb = load_workbook(template)
self.contract = Contract(self.wb.get_sheet_by_name(
self.CONTRACT_SHEET))
self.invoice = Invoice(self.wb.get_sheet_by_name(self.INVOICE_SHEET))
self.details = Details(self.wb.get_sheet_by_name(self.DETAILS_SHEET))
def get_contract_sheet(self):
return self.contract
def get_invoice_sheet(self):
return self.invoice
def get_detail_sheet(self):
return self.details
def save(self, dest=None):
if dest is None:
dest = self.template
self.contract.fix_borders()
self.details.fix_borders()
#save here
self.contract.remove_empty_rows()
self.invoice.remove_empty_rows()
self.details.remove_empty_rows()
self.wb.save(dest)
