def add_worksheet(self, name=None): """ Add a new worksheet to the Excel workbook. Args: name: The worksheet name. Defaults to 'Sheet1', etc. Returns: Reference to a worksheet object. """ sheet_index = len(self.worksheets_objs) name = self._check_sheetname(name) # Encode any string options passed by the user. name = encode_utf8(name) # Initialisation data to pass to the worksheet. init_data = { 'name': name, 'index': sheet_index, 'str_table': self.str_table, 'worksheet_meta': self.worksheet_meta, 'optimization': self.optimization, 'tmpdir': self.tmpdir, 'date_1904': self.date_1904, } worksheet = Worksheet() worksheet._initialize(init_data) self.worksheets_objs.append(worksheet) self.sheetnames.append(name) return worksheet
def _add_sheet(self, name, is_chartsheet): # Utility for shared code in add_worksheet() and add_chartsheet(). sheet_index = len(self.worksheets_objs) name = self._check_sheetname(name, is_chartsheet) # Initialisation data to pass to the worksheet. init_data = { 'name': name, 'index': sheet_index, 'str_table': self.str_table, 'worksheet_meta': self.worksheet_meta, 'optimization': self.optimization, 'tmpdir': self.tmpdir, 'date_1904': self.date_1904, 'strings_to_numbers': self.strings_to_numbers, 'strings_to_formulas': self.strings_to_formulas, 'strings_to_urls': self.strings_to_urls, 'default_date_format': self.default_date_format, 'default_url_format': self.default_url_format, 'excel2003_style': self.excel2003_style, } if is_chartsheet: worksheet = Chartsheet() else: worksheet = Worksheet() worksheet._initialize(init_data) self.worksheets_objs.append(worksheet) self.sheetnames.append(name) return worksheet
def add_worksheet(self, name=None): """ Add a new worksheet to the Excel workbook. Args: name: The worksheet name. Defaults to 'Sheet1', etc. Returns: Reference to a worksheet object. """ sheet_index = len(self.worksheets_objs) name = self._check_sheetname(name) # Initialisation data to pass to the worksheet. init_data = { 'name': name, 'index': sheet_index, 'str_table': self.str_table, 'worksheet_meta': self.worksheet_meta, 'optimization': self.optimization, 'tmpdir': self.tmpdir, 'date_1904': self.date_1904, 'strings_to_numbers': self.strings_to_numbers, 'strings_to_formulas': self.strings_to_formulas, 'strings_to_urls': self.strings_to_urls, 'default_date_format': self.default_date_format, 'default_url_format': self.default_url_format, } worksheet = Worksheet() worksheet._initialize(init_data) self.worksheets_objs.append(worksheet) self.sheetnames.append(name) return worksheet