Python SheetReader.__init__ Examples

Example #1

 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

Example #2

File: _csv.py Project: schulzsebastian/qgisplugin_spreadsheet

 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

Example #3

File: csvr.py Project: EnjoyLifeFund/macHighSierra-py36-pkgs

 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

Example #4

File: xlsxr.py Project: pyexcel/pyexcel-xlsx

 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()

Example #5

File: xlsxr.py Project: RScicomp/Google-Hangouts-Web-App

 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()

Example #6

File: xlsr.py Project: vuna261/vuna

 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)

Example #7

File: xlsr.py Project: pyexcel/pyexcel-xls

 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)

Example #8

File: csvr.py Project: pyexcel/pyexcel-io

 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

Example #9

File: xls.py Project: jayvdb/pyexcel-xls

 def __init__(self, sheet, auto_detect_int=True, **keywords):
     SheetReader.__init__(self, sheet, **keywords)
     self.auto_detect_int = auto_detect_int

Example #10

File: xls.py Project: 62484m/QQ-Groups-Spider

 def __init__(self, sheet, auto_detect_int=True, **keywords):
     SheetReader.__init__(self, sheet, **keywords)
     self.auto_detect_int = auto_detect_int

Example #11

File: querysets.py Project: readflybird/pyexcel-io

 def __init__(self, query_sets, column_names, **keywords):
     SheetReader.__init__(self, query_sets, **keywords)
     self.__column_names = column_names
     self.__query_sets = query_sets

Example #12

File: querysets.py Project: caspartse/QQ-Groups-Spider

 def __init__(self, query_sets, column_names, **keywords):
     SheetReader.__init__(self, query_sets, **keywords)
     self.__column_names = column_names
     self.__query_sets = query_sets