def iter_rows(workbook_name, sheet_name, xml_source, shared_date, string_table, range_string='', row_offset=0, column_offset=0): archive = get_archive_file(workbook_name) source = xml_source if range_string: min_col, min_row, max_col, max_row = get_range_boundaries( range_string, row_offset, column_offset) else: min_col, min_row, max_col, max_row = read_dimension(xml_source=source) min_col = column_index_from_string(min_col) max_col = column_index_from_string(max_col) + 1 max_row += 6 style_table = read_style_table(archive.read(ARC_STYLE)) source.seek(0) p = iterparse(source) return get_squared_range(p, min_col, min_row, max_col, max_row, string_table, style_table, shared_date)
def __init__(self, parent_workbook, title, workbook_name, sheet_codename, xml_source, string_table): Worksheet.__init__(self, parent_workbook, title) self._workbook_name = workbook_name self._sheet_codename = sheet_codename self._xml_source = xml_source self._string_table = string_table min_col, min_row, max_col, max_row = read_dimension(xml_source=xml_source) self._max_row = max_row self._max_column = max_col self._dimensions = "%s%s:%s%s" % (min_col, min_row, max_col, max_row) self._shared_date = SharedDate(base_date=parent_workbook.excel_base_date)
def __init__(self, parent_workbook, title, workbook_name, sheet_codename, xml_source, string_table): Worksheet.__init__(self, parent_workbook, title) self._workbook_name = workbook_name self._sheet_codename = sheet_codename self._xml_source = xml_source self._string_table = string_table min_col, min_row, max_col, max_row = read_dimension( xml_source=xml_source) self._max_row = max_row self._max_column = max_col self._dimensions = '%s%s:%s%s' % (min_col, min_row, max_col, max_row) self._shared_date = SharedDate( base_date=parent_workbook.excel_base_date)
def iter_rows( workbook_name, sheet_name, xml_source, shared_date, string_table, range_string="", row_offset=0, column_offset=0 ): archive = get_archive_file(workbook_name) source = xml_source if range_string: min_col, min_row, max_col, max_row = get_range_boundaries(range_string, row_offset, column_offset) else: min_col, min_row, max_col, max_row = read_dimension(xml_source=source) min_col = column_index_from_string(min_col) max_col = column_index_from_string(max_col) + 1 max_row += 6 style_table = read_style_table(archive.read(ARC_STYLE)) source.seek(0) p = iterparse(source) return get_squared_range(p, min_col, min_row, max_col, max_row, string_table, style_table, shared_date)