def get_macrosheets(self):
if self._macrosheets is None:
self._macrosheets = {}
for sheet in self.xls_workbook.Excel4MacroSheets:
macrosheet = Boundsheet(sheet.name, 'Macrosheet')
self.load_cells(macrosheet, sheet)
self._macrosheets[sheet.name] = macrosheet
return self._macrosheets
def get_macrosheets(self):
if self._macrosheets is None:
self._macrosheets = {}
for sheet in self.xls_workbook.sheets():
if sheet.boundsheet_type == xlrd2.biffh.XL_MACROSHEET:
macrosheet = Boundsheet(sheet.name, 'Macrosheet')
self.load_cells(macrosheet, sheet)
self._macrosheets[sheet.name] = macrosheet
return self._macrosheets
def get_worksheets(self):
if self._worksheets is None:
self._worksheets = {}
for sheet in self.xls_workbook.sheets():
if sheet.boundsheet_type == xlrd2.biffh.XL_WORKSHEET:
worksheet = Boundsheet(sheet.name, 'Worksheet')
self.load_cells(worksheet, sheet)
self._worksheets[sheet.name] = worksheet
return self._worksheets