def __init__( self, path, engine=None, date_format=None, datetime_format=None, encoding=None, mode: str = "w", storage_options: StorageOptions = None, if_sheet_exists: str | None = None, engine_kwargs: dict[str, Any] | None = None, **kwargs, ): # Use the xlwt module as the Excel writer. import xlwt engine_kwargs = combine_kwargs(engine_kwargs, kwargs) if mode == "a": raise ValueError("Append mode is not supported with xlwt!") super().__init__( path, mode=mode, storage_options=storage_options, if_sheet_exists=if_sheet_exists, engine_kwargs=engine_kwargs, ) if encoding is None: encoding = "ascii" self.book = xlwt.Workbook(encoding=encoding) self.fm_datetime = xlwt.easyxf(num_format_str=self.datetime_format) self.fm_date = xlwt.easyxf(num_format_str=self.date_format)
def __init__( self, path: str, engine: str | None = None, date_format=None, datetime_format=None, mode: str = "w", storage_options: StorageOptions = None, if_sheet_exists: str | None = None, engine_kwargs: dict[str, Any] | None = None, **kwargs, ): from odf.opendocument import OpenDocumentSpreadsheet if mode == "a": raise ValueError("Append mode is not supported with odf!") super().__init__( path, mode=mode, storage_options=storage_options, if_sheet_exists=if_sheet_exists, engine_kwargs=engine_kwargs, ) engine_kwargs = combine_kwargs(engine_kwargs, kwargs) self.book = OpenDocumentSpreadsheet(**engine_kwargs) self._style_dict: dict[str, str] = {}
def __init__( self, path: FilePath | WriteExcelBuffer | ExcelWriter, engine: str | None = None, date_format: str | None = None, datetime_format: str | None = None, mode: str = "w", storage_options: StorageOptions = None, if_sheet_exists: str | None = None, engine_kwargs: dict[str, Any] | None = None, **kwargs, ): # Use the xlsxwriter module as the Excel writer. from xlsxwriter import Workbook engine_kwargs = combine_kwargs(engine_kwargs, kwargs) if mode == "a": raise ValueError("Append mode is not supported with xlsxwriter!") super().__init__( path, engine=engine, date_format=date_format, datetime_format=datetime_format, mode=mode, storage_options=storage_options, if_sheet_exists=if_sheet_exists, engine_kwargs=engine_kwargs, ) self._book = Workbook(self._handles.handle, **engine_kwargs)
def __init__( self, path, engine=None, date_format=None, datetime_format=None, mode: str = "w", storage_options: StorageOptions = None, if_sheet_exists: str | None = None, engine_kwargs: dict[str, Any] | None = None, **kwargs, ): # Use the openpyxl module as the Excel writer. from openpyxl.workbook import Workbook engine_kwargs = combine_kwargs(engine_kwargs, kwargs) super().__init__( path, mode=mode, storage_options=storage_options, if_sheet_exists=if_sheet_exists, engine_kwargs=engine_kwargs, ) # ExcelWriter replaced "a" by "r+" to allow us to first read the excel file from # the file and later write to it if "r+" in self.mode: # Load from existing workbook from openpyxl import load_workbook self.book = load_workbook(self.handles.handle) self.handles.handle.seek(0) self.sheets = { name: self.book[name] for name in self.book.sheetnames } else: # Create workbook object with default optimized_write=True. self.book = Workbook() if self.book.worksheets: self.book.remove(self.book.worksheets[0])