typeddfs._mixins._excel_mixins

Mixin for Excel/ODF IO.

Module Contents

class typeddfs._mixins._excel_mixins._ExcelMixin

classmethod read_excel(cls, io, sheet_name: _SheetNamesOrIndices = 0, *args, **kwargs) → __qualname__

classmethod read_ods(cls, io, sheet_name: _SheetNamesOrIndices = 0, **kwargs) → __qualname__

Reads OpenDocument ODS/ODT files. Prefer this method over read_excel().

classmethod read_xls(cls, io, sheet_name: _SheetNamesOrIndices = 0, **kwargs) → __qualname__

Reads legacy XLS Excel files. Prefer this method over read_excel().

classmethod read_xlsb(cls, io, sheet_name: _SheetNamesOrIndices = 0, **kwargs) → __qualname__

Reads XLSB Excel files. This is a relatively uncommon format. Prefer this method over read_excel().

classmethod read_xlsx(cls, io, sheet_name: _SheetNamesOrIndices = 0, **kwargs) → __qualname__

Reads XLSX Excel files. Prefer this method over read_excel().

to_excel(self, excel_writer, *args, **kwargs) → Optional[str]

to_ods(self, ods_writer, *args, **kwargs) → Optional[str]

Writes OpenDocument ODS/ODT files. Prefer this method over write_excel().

to_xls(self, excel_writer, *args, **kwargs) → Optional[str]

Reads legacy XLS Excel files. Prefer this method over write_excel().

to_xlsb(self, excel_writer, *args, **kwargs) → Optional[str]

Writes XLSB Excel files. This is a relatively uncommon format. Prefer this method over write_excel().

to_xlsx(self, excel_writer, *args, **kwargs) → Optional[str]

Writes XLSX Excel files. Prefer this method over write_excel().