def __init__(
self,
sheet,
encoding="utf-8",
auto_detect_delimiter=True,
auto_detect_float=True,
ignore_infinity=True,
auto_detect_int=True,
auto_detect_datetime=True,
delimiters=[',', '\t', ';', ' ', ':'],
pep_0515_off=True,
ignore_nan_text=False,
default_float_nan=None,
**keywords
):
SheetReader.__init__(self, sheet, **keywords)
self._encoding = encoding
self.__auto_detect_delimiter = auto_detect_delimiter
self.__auto_detect_int = auto_detect_int
self.__auto_detect_float = auto_detect_float
self.__ignore_infinity = ignore_infinity
self.__auto_detect_datetime = auto_detect_datetime
self.__delimiters = delimiters
self.__file_handle = None
self.__pep_0515_off = pep_0515_off
self.__ignore_nan_text = ignore_nan_text
self.__default_float_nan = default_float_nan
def __init__(self, sheet, encoding="utf-8",
auto_detect_float=True, ignore_infinity=True,
auto_detect_int=True, auto_detect_datetime=True,
**keywords):
SheetReader.__init__(self, sheet, **keywords)
self._encoding = encoding
self.__auto_detect_int = auto_detect_int
self.__auto_detect_float = auto_detect_float
self.__ignore_infinity = ignore_infinity
self.__auto_detect_datetime = auto_detect_datetime
def __init__(self, sheet, encoding="utf-8",
auto_detect_float=True, ignore_infinity=True,
auto_detect_int=True, auto_detect_datetime=True,
**keywords):
SheetReader.__init__(self, sheet, **keywords)
self._encoding = encoding
self.__auto_detect_int = auto_detect_int
self.__auto_detect_float = auto_detect_float
self.__ignore_infinity = ignore_infinity
self.__auto_detect_datetime = auto_detect_datetime
self.__file_handle = None
def __init__(self, sheet, **keywords):
SheetReader.__init__(self, sheet, **keywords)
self.__merged_cells = {}
self.max_row = 0
self.max_column = 0
self.__sheet_max_row = sheet.max_row
self.__sheet_max_column = sheet.max_column
for ranges in sheet.merged_cells.ranges[:]:
merged_cells = MergedCell(ranges)
merged_cells.register_cells(self.__merged_cells)
if self.max_row < merged_cells.bottom_row():
self.max_row = merged_cells.bottom_row()
if self.max_column < merged_cells.right_column():
self.max_column = merged_cells.right_column()
def __init__(self, sheet, **keywords):
SheetReader.__init__(self, sheet, **keywords)
self.__merged_cells = {}
self.max_row = 0
self.max_column = 0
self.__sheet_max_row = sheet.max_row
self.__sheet_max_column = sheet.max_column
for ranges in sheet.merged_cells.ranges[:]:
merged_cells = MergedCell(ranges)
merged_cells.register_cells(self.__merged_cells)
if self.max_row < merged_cells.bottom_row():
self.max_row = merged_cells.bottom_row()
if self.max_column < merged_cells.right_column():
self.max_column = merged_cells.right_column()
def __init__(self, sheet, auto_detect_int=True, **keywords):
SheetReader.__init__(self, sheet, **keywords)
self.__auto_detect_int = auto_detect_int
self.__hidden_cols = []
self.__hidden_rows = []
self.__merged_cells = {}
if keywords.get('detect_merged_cells') is True:
for merged_cell_ranges in sheet.merged_cells:
merged_cells = MergedCell(*merged_cell_ranges)
merged_cells.register_cells(self.__merged_cells)
if keywords.get('skip_hidden_row_and_column') is True:
for col_index, info in self._native_sheet.colinfo_map.items():
if info.hidden == 1:
self.__hidden_cols.append(col_index)
for row_index, info in self._native_sheet.rowinfo_map.items():
if info.hidden == 1:
self.__hidden_rows.append(row_index)
def __init__(self, sheet, auto_detect_int=True, date_mode=0, **keywords):
SheetReader.__init__(self, sheet, **keywords)
self.__auto_detect_int = auto_detect_int
self.__hidden_cols = []
self.__hidden_rows = []
self.__merged_cells = {}
self._book_date_mode = date_mode
if keywords.get('detect_merged_cells') is True:
for merged_cell_ranges in sheet.merged_cells:
merged_cells = MergedCell(*merged_cell_ranges)
merged_cells.register_cells(self.__merged_cells)
if keywords.get('skip_hidden_row_and_column') is True:
for col_index, info in self._native_sheet.colinfo_map.items():
if info.hidden == 1:
self.__hidden_cols.append(col_index)
for row_index, info in self._native_sheet.rowinfo_map.items():
if info.hidden == 1:
self.__hidden_rows.append(row_index)
def __init__(
self,
sheet,
encoding="utf-8",
auto_detect_float=True,
ignore_infinity=True,
auto_detect_int=True,
auto_detect_datetime=True,
pep_0515_off=True,
ignore_nan_text=False,
default_float_nan=None,
**keywords
):
SheetReader.__init__(self, sheet, **keywords)
self._encoding = encoding
self.__auto_detect_int = auto_detect_int
self.__auto_detect_float = auto_detect_float
self.__ignore_infinity = ignore_infinity
self.__auto_detect_datetime = auto_detect_datetime
self.__file_handle = None
self.__pep_0515_off = pep_0515_off
self.__ignore_nan_text = ignore_nan_text
self.__default_float_nan = default_float_nan
def __init__(self, sheet, auto_detect_int=True, **keywords):
SheetReader.__init__(self, sheet, **keywords)
self.auto_detect_int = auto_detect_int
def __init__(self, sheet, auto_detect_int=True, **keywords):
SheetReader.__init__(self, sheet, **keywords)
self.auto_detect_int = auto_detect_int
def __init__(self, query_sets, column_names, **keywords):
SheetReader.__init__(self, query_sets, **keywords)
self.__column_names = column_names
self.__query_sets = query_sets
def __init__(self, query_sets, column_names, **keywords):
SheetReader.__init__(self, query_sets, **keywords)
self.__column_names = column_names
self.__query_sets = query_sets