def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
assert prop.creator == '*.*'
assert prop.last_modified_by == 'Charlie Clark'
assert prop.created == datetime(2010, 4, 9, 20, 43, 12)
assert prop.modified == datetime(2014, 1, 2, 14, 53, 6)
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
assert prop.creator == '*.*'
assert prop.last_modified_by == 'Charlie Clark'
assert prop.created == datetime(2010, 4, 9, 20, 43, 12)
assert prop.modified == datetime(2014, 1, 2, 14, 53, 6)
def _load_workbook(wb, archive, filename, use_iterators):
valid_files = archive.namelist()
# get workbook-level information
wb.properties = read_properties_core(archive.read(ARC_CORE))
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
style_table = read_style_table(archive.read(ARC_STYLE))
# get worksheets
wb.worksheets = [] # remove preset worksheet
sheet_names = read_sheets_titles(archive.read(ARC_WORKBOOK))
for i, sheet_name in enumerate(sheet_names):
sheet_codename = 'sheet%d.xml' % (i + 1)
worksheet_path = '%s/%s' % (PACKAGE_WORKSHEETS, sheet_codename)
if not worksheet_path in valid_files:
continue
if not use_iterators:
new_ws = read_worksheet(archive.read(worksheet_path), wb,
sheet_name, string_table, style_table)
else:
xml_source = unpack_worksheet(archive, worksheet_path)
new_ws = read_worksheet(xml_source, wb, sheet_name, string_table,
style_table, filename, sheet_codename)
#new_ws = read_worksheet(archive.read(worksheet_path), wb, sheet_name, string_table, style_table, filename, sheet_codename)
wb.add_sheet(new_ws, index=i)
wb._named_ranges = read_named_ranges(archive.read(ARC_WORKBOOK), wb)
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.creator, '*.*')
eq_(prop.last_modified_by, u'Aurélien Campéas')
eq_(prop.created, datetime(2010, 4, 9, 20, 43, 12))
eq_(prop.modified, datetime(2011, 2, 9, 13, 49, 32))
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.creator, '*.*')
eq_(prop.last_modified_by, u'Aurélien Campéas')
eq_(prop.created, datetime(2010, 4, 9, 20, 43, 12))
eq_(prop.modified, datetime(2011, 2, 9, 13, 49, 32))
def _load_workbook(wb, archive, filename, use_iterators):
valid_files = archive.namelist()
# get workbook-level information
wb.properties = read_properties_core(archive.read(ARC_CORE))
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
style_table = read_style_table(archive.read(ARC_STYLE))
# get worksheets
wb.worksheets = [] # remove preset worksheet
sheet_names = read_sheets_titles(archive.read(ARC_WORKBOOK))
for i, sheet_name in enumerate(sheet_names):
sheet_codename = 'sheet%d.xml' % (i + 1)
worksheet_path = '%s/%s' % (PACKAGE_WORKSHEETS, sheet_codename)
if not worksheet_path in valid_files:
continue
if not use_iterators:
new_ws = read_worksheet(archive.read(worksheet_path), wb, sheet_name, string_table, style_table)
else:
xml_source = unpack_worksheet(archive, worksheet_path)
new_ws = read_worksheet(xml_source, wb, sheet_name, string_table, style_table, filename, sheet_codename)
#new_ws = read_worksheet(archive.read(worksheet_path), wb, sheet_name, string_table, style_table, filename, sheet_codename)
wb.add_sheet(new_ws, index = i)
wb._named_ranges = read_named_ranges(archive.read(ARC_WORKBOOK), wb)
def test_read_properties_libreeoffice(datadir):
datadir.join("genuine").chdir()
archive = ZipFile("empty_libre.xlsx")
content = archive.read(ARC_CORE)
prop = read_properties_core(content)
assert prop.excel_base_date == CALENDAR_WINDOWS_1900
assert prop.creator == ''
assert prop.last_modified_by == ''
def test_read_properties_libreeoffice(datadir):
datadir.join("genuine").chdir()
archive = ZipFile("empty_libre.xlsx")
content = archive.read(ARC_CORE)
prop = read_properties_core(content)
assert prop.excel_base_date == CALENDAR_WINDOWS_1900
assert prop.creator == ''
assert prop.last_modified_by == ''
def test_read_properties_core(datadir):
datadir.join("genuine").chdir()
archive = ZipFile("empty.xlsx")
content = archive.read(ARC_CORE)
prop = read_properties_core(content)
assert prop.creator == '*.*'
assert prop.excel_base_date == CALENDAR_WINDOWS_1900
assert prop.last_modified_by == 'Charlie Clark'
assert prop.created == datetime(2010, 4, 9, 20, 43, 12)
assert prop.modified == datetime(2014, 1, 2, 14, 53, 6)
def test_read_properties_core(datadir):
datadir.join("genuine").chdir()
archive = ZipFile("empty.xlsx")
content = archive.read(ARC_CORE)
prop = read_properties_core(content)
assert prop.creator == '*.*'
assert prop.excel_base_date == CALENDAR_WINDOWS_1900
assert prop.last_modified_by == 'Charlie Clark'
assert prop.created == datetime(2010, 4, 9, 20, 43, 12)
assert prop.modified == datetime(2014, 1, 2, 14, 53, 6)
def _load_workbook(wb, archive, filename, use_iterators, keep_vba):
valid_files = archive.namelist()
# If are going to preserve the vba then attach the archive to the
# workbook so that is available for the save.
if keep_vba:
wb.vba_archive = archive
# get workbook-level information
try:
wb.properties = read_properties_core(archive.read(ARC_CORE))
wb.read_workbook_settings(archive.read(ARC_WORKBOOK))
except KeyError:
wb.properties = DocumentProperties()
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
try:
wb.loaded_theme = archive.read(ARC_THEME) # some writers don't output a theme, live with it (fixes #160)
except KeyError:
assert wb.loaded_theme == None, "even though the theme information is missing there is a theme object ?"
style_properties = read_style_table(archive.read(ARC_STYLE))
style_table = style_properties.pop('table')
wb.style_properties = style_properties
wb.properties.excel_base_date = read_excel_base_date(xml_source=archive.read(ARC_WORKBOOK))
# get worksheets
wb.worksheets = [] # remove preset worksheet
content_types = read_content_types(archive.read(ARC_CONTENT_TYPES))
sheet_types = [(sheet, contyp) for sheet, contyp in content_types if contyp in WORK_OR_CHART_TYPE]
sheet_names = read_sheets_titles(archive.read(ARC_WORKBOOK))
worksheet_names = [worksheet for worksheet, sheet_type in zip(sheet_names, sheet_types) if sheet_type[1] == VALID_WORKSHEET]
for i, sheet_name in enumerate(worksheet_names):
sheet_codename = 'sheet%d.xml' % (i + 1)
worksheet_path = '%s/%s' % (PACKAGE_WORKSHEETS, sheet_codename)
if not worksheet_path in valid_files:
continue
if not use_iterators:
new_ws = read_worksheet(archive.read(worksheet_path), wb, sheet_name, string_table, style_table, style_properties['color_index'], keep_vba=keep_vba)
else:
xml_source = unpack_worksheet(archive, worksheet_path)
new_ws = read_worksheet(xml_source, wb, sheet_name, string_table, style_table, style_properties['color_index'], filename, sheet_codename)
wb.add_sheet(new_ws, index=i)
wb._named_ranges = read_named_ranges(archive.read(ARC_WORKBOOK), wb)
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.creator, "*.*")
try:
# Python 2
eacute = unichr(233)
except NameError:
# Python 3
eacute = chr(233)
eq_(prop.last_modified_by, "Aur" + eacute + "lien Camp" + eacute + "as")
eq_(prop.created, datetime(2010, 4, 9, 20, 43, 12))
eq_(prop.modified, datetime(2011, 2, 9, 13, 49, 32))
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.creator, '*.*')
try:
# Python 2
eacute = unichr(233)
except NameError:
# Python 3
eacute = chr(233)
eq_(prop.last_modified_by, 'Charlie Clark')
eq_(prop.created, datetime(2010, 4, 9, 20, 43, 12))
eq_(prop.modified, datetime(2014, 1, 2, 14, 53, 6))
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.creator, "*.*")
try:
# Python 2
eacute = unichr(233)
except NameError:
# Python 3
eacute = chr(233)
eq_(prop.last_modified_by, "Charlie Clark")
eq_(prop.created, datetime(2010, 4, 9, 20, 43, 12))
eq_(prop.modified, datetime(2014, 1, 2, 14, 53, 6))
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.creator, '*.*')
try:
# Python 2
eacute = unichr(233)
except NameError:
# Python 3
eacute = chr(233)
eq_(prop.last_modified_by,
'Aur' + eacute + 'lien Camp' + eacute + 'as')
eq_(prop.created, datetime(2010, 4, 9, 20, 43, 12))
eq_(prop.modified, datetime(2011, 2, 9, 13, 49, 32))
def _load_workbook(wb, archive, filename, use_iterators):
valid_files = archive.namelist()
# get workbook-level information
try:
wb.properties = read_properties_core(archive.read(ARC_CORE))
except KeyError:
wb.properties = DocumentProperties()
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
try:
wb.loaded_theme = archive.read(ARC_THEME) # some writers don't output a theme, live with it (fixes #160)
except KeyError:
assert wb.loaded_theme == None, "even though the theme information is missing there is a theme object ?"
style_table = read_style_table(archive.read(ARC_STYLE))
wb.properties.excel_base_date = read_excel_base_date(xml_source=archive.read(ARC_WORKBOOK))
# get worksheets
wb.worksheets = [] # remove preset worksheet
sheet_names = read_sheets_titles(archive.read(ARC_WORKBOOK))
for i, sheet_name in enumerate(sheet_names):
sheet_codename = 'sheet%d.xml' % (i + 1)
worksheet_path = '%s/%s' % (PACKAGE_WORKSHEETS, sheet_codename)
if not worksheet_path in valid_files:
continue
if not use_iterators:
new_ws = read_worksheet(archive.read(worksheet_path), wb, sheet_name, string_table, style_table)
else:
xml_source = unpack_worksheet(archive, worksheet_path)
new_ws = read_worksheet(xml_source, wb, sheet_name, string_table, style_table, filename, sheet_codename)
wb.add_sheet(new_ws, index=i)
wb._named_ranges = read_named_ranges(archive.read(ARC_WORKBOOK), wb)
def _load_workbook(wb, archive, filename, use_iterators, keep_vba):
valid_files = archive.namelist()
# If are going to preserve the vba then attach a copy of the archive to the
# workbook so that is available for the save.
if keep_vba:
try:
f = open(filename, 'rb')
s = f.read()
f.close()
except:
pos = filename.tell()
filename.seek(0)
s = filename.read()
filename.seek(pos)
wb.vba_archive = ZipFile(BytesIO(s), 'r')
if use_iterators:
wb._archive = ZipFile(filename)
# get workbook-level information
try:
wb.properties = read_properties_core(archive.read(ARC_CORE))
wb.read_workbook_settings(archive.read(ARC_WORKBOOK))
except KeyError:
wb.properties = DocumentProperties()
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
try:
wb.loaded_theme = archive.read(
ARC_THEME
) # some writers don't output a theme, live with it (fixes #160)
except KeyError:
assert wb.loaded_theme == None, "even though the theme information is missing there is a theme object ?"
style_properties = read_style_table(archive.read(ARC_STYLE))
style_table = style_properties.pop('table')
wb.style_properties = style_properties
wb.properties.excel_base_date = read_excel_base_date(
xml_source=archive.read(ARC_WORKBOOK))
# get worksheets
wb.worksheets = [] # remove preset worksheet
for sheet in detect_worksheets(archive):
sheet_name = sheet['title']
worksheet_path = '%s/%s' % (PACKAGE_XL, sheet['path'])
if not worksheet_path in valid_files:
continue
if not use_iterators:
new_ws = read_worksheet(
archive.read(worksheet_path),
wb,
sheet_name,
string_table,
style_table,
color_index=style_properties['color_index'],
keep_vba=keep_vba)
else:
new_ws = read_worksheet(
None,
wb,
sheet_name,
string_table,
style_table,
color_index=style_properties['color_index'],
worksheet_path=worksheet_path)
wb.add_sheet(new_ws)
if not use_iterators:
# load comments into the worksheet cells
comments_file = get_comments_file(worksheet_path, archive,
valid_files)
if comments_file is not None:
read_comments(new_ws, archive.read(comments_file))
wb._named_ranges = read_named_ranges(archive.read(ARC_WORKBOOK), wb)
if isinstance(filename, file):
# fileobject must have been opened with 'rb' flag
# it is required by zipfile
if 'b' not in filename.mode:
raise OpenModeError("File-object must be opened in binary mode")
try:
archive = ZipFile(filename, 'r', ZIP_DEFLATED)
except (BadZipfile, RuntimeError, IOError, ValueError), e:
raise InvalidFileException(unicode(e))
wb = Workbook()
wb._set_optimized_read()
try:
# get workbook-level information
wb.properties = read_properties_core(archive.read(ARC_CORE))
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
style_table = read_style_table(archive.read(ARC_STYLE))
# get worksheets
wb.worksheets = [] # remove preset worksheet
sheet_names = read_sheets_titles(archive.read(ARC_APP))
for i, sheet_name in enumerate(sheet_names):
sheet_codename = 'sheet%d.xml' % (i + 1)
worksheet_path = '%s/%s' % (PACKAGE_WORKSHEETS, sheet_codename)
if not use_iterators:
new_ws = read_worksheet(archive.read(worksheet_path), wb, sheet_name, string_table, style_table)
def _load_workbook(wb, archive, filename, read_only, keep_vba):
valid_files = archive.namelist()
# If are going to preserve the vba then attach a copy of the archive to the
# workbook so that is available for the save.
if keep_vba:
try:
f = open(filename, 'rb')
s = f.read()
f.close()
except:
pos = filename.tell()
filename.seek(0)
s = filename.read()
filename.seek(pos)
wb.vba_archive = ZipFile(BytesIO(s), 'r')
if read_only:
wb._archive = ZipFile(filename)
# get workbook-level information
try:
wb.properties = read_properties_core(archive.read(ARC_CORE))
except KeyError:
wb.properties = DocumentProperties()
wb._read_workbook_settings(archive.read(ARC_WORKBOOK))
# what content types do we have?
cts = dict(read_content_types(archive))
rels = dict
strings_path = cts.get(SHARED_STRINGS)
if strings_path is not None:
if strings_path.startswith("/"):
strings_path = strings_path[1:]
shared_strings = read_string_table(archive.read(strings_path))
else:
shared_strings = []
try:
wb.loaded_theme = archive.read(ARC_THEME) # some writers don't output a theme, live with it (fixes #160)
except KeyError:
assert wb.loaded_theme == None, "even though the theme information is missing there is a theme object ?"
style_table, color_index, cond_styles = read_style_table(archive.read(ARC_STYLE))
wb.shared_styles = style_table
wb.style_properties = {'dxf_list':cond_styles}
wb.cond_styles = cond_styles
wb.properties.excel_base_date = read_excel_base_date(xml_source=archive.read(ARC_WORKBOOK))
# get worksheets
wb.worksheets = [] # remove preset worksheet
for sheet in detect_worksheets(archive):
sheet_name = sheet['title']
worksheet_path = sheet['path']
if not worksheet_path in valid_files:
continue
if not read_only:
new_ws = read_worksheet(archive.read(worksheet_path), wb,
sheet_name, shared_strings, style_table,
color_index=color_index,
keep_vba=keep_vba)
else:
new_ws = read_worksheet(None, wb, sheet_name, shared_strings,
style_table,
color_index=color_index,
worksheet_path=worksheet_path)
new_ws.sheet_state = sheet.get('state') or 'visible'
wb._add_sheet(new_ws)
if not read_only:
# load comments into the worksheet cells
comments_file = get_comments_file(worksheet_path, archive, valid_files)
if comments_file is not None:
read_comments(new_ws, archive.read(comments_file))
wb._named_ranges = list(read_named_ranges(archive.read(ARC_WORKBOOK), wb))
if EXTERNAL_LINK in cts:
rels = read_rels(archive)
wb._external_links = list(detect_external_links(rels, archive))
def _load_workbook(wb, archive, filename, read_only, keep_vba):
valid_files = archive.namelist()
# If are going to preserve the vba then attach a copy of the archive to the
# workbook so that is available for the save.
if keep_vba:
try:
f = open(filename, 'rb')
s = f.read()
f.close()
except:
pos = filename.tell()
filename.seek(0)
s = filename.read()
filename.seek(pos)
wb.vba_archive = ZipFile(BytesIO(s), 'r')
if read_only:
wb._archive = ZipFile(filename)
# get workbook-level information
try:
wb.properties = read_properties_core(archive.read(ARC_CORE))
except KeyError:
wb.properties = DocumentProperties()
wb._read_workbook_settings(archive.read(ARC_WORKBOOK))
# what content types do we have?
cts = dict(read_content_types(archive))
rels = dict
strings_path = cts.get(SHARED_STRINGS)
if strings_path is not None:
if strings_path.startswith("/"):
strings_path = strings_path[1:]
shared_strings = read_string_table(archive.read(strings_path))
else:
shared_strings = []
try:
wb.loaded_theme = archive.read(
ARC_THEME
) # some writers don't output a theme, live with it (fixes #160)
except KeyError:
assert wb.loaded_theme == None, "even though the theme information is missing there is a theme object ?"
style_table, color_index, cond_styles = read_style_table(
archive.read(ARC_STYLE))
wb.shared_styles = style_table
wb.style_properties = {'dxf_list': cond_styles}
wb.cond_styles = cond_styles
wb.properties.excel_base_date = read_excel_base_date(
xml_source=archive.read(ARC_WORKBOOK))
# get worksheets
wb.worksheets = [] # remove preset worksheet
for sheet in detect_worksheets(archive):
sheet_name = sheet['title']
worksheet_path = sheet['path']
if not worksheet_path in valid_files:
continue
if not read_only:
new_ws = read_worksheet(archive.read(worksheet_path),
wb,
sheet_name,
shared_strings,
style_table,
color_index=color_index,
keep_vba=keep_vba)
else:
new_ws = read_worksheet(None,
wb,
sheet_name,
shared_strings,
style_table,
color_index=color_index,
worksheet_path=worksheet_path)
new_ws.sheet_state = sheet.get('state') or 'visible'
wb._add_sheet(new_ws)
if not read_only:
# load comments into the worksheet cells
comments_file = get_comments_file(worksheet_path, archive,
valid_files)
if comments_file is not None:
read_comments(new_ws, archive.read(comments_file))
drawings_file = get_drawings_file(worksheet_path, archive,
valid_files)
if drawings_file is not None:
read_drawings(new_ws, drawings_file, archive, valid_files)
wb._named_ranges = list(read_named_ranges(archive.read(ARC_WORKBOOK), wb))
wb.code_name = read_workbook_code_name(archive.read(ARC_WORKBOOK))
if EXTERNAL_LINK in cts:
rels = read_rels(archive)
wb._external_links = list(detect_external_links(rels, archive))
def _load_workbook(wb, archive, filename, use_iterators, keep_vba):
valid_files = archive.namelist()
# If are going to preserve the vba then attach the archive to the
# workbook so that is available for the save.
if keep_vba:
wb.vba_archive = archive
if use_iterators:
wb._archive = ZipFile(filename)
# get workbook-level information
try:
wb.properties = read_properties_core(archive.read(ARC_CORE))
wb.read_workbook_settings(archive.read(ARC_WORKBOOK))
except KeyError:
wb.properties = DocumentProperties()
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
try:
wb.loaded_theme = archive.read(
ARC_THEME
) # some writers don't output a theme, live with it (fixes #160)
except KeyError:
assert wb.loaded_theme == None, "even though the theme information is missing there is a theme object ?"
style_properties = read_style_table(archive.read(ARC_STYLE))
style_table = style_properties.pop('table')
wb.style_properties = style_properties
wb.properties.excel_base_date = read_excel_base_date(
xml_source=archive.read(ARC_WORKBOOK))
# get worksheets
wb.worksheets = [] # remove preset worksheet
content_types = read_content_types(archive.read(ARC_CONTENT_TYPES))
sheet_types = [(sheet, contyp) for sheet, contyp in content_types
if contyp in WORK_OR_CHART_TYPE]
sheet_names = read_sheets_titles(archive.read(ARC_WORKBOOK))
worksheet_names = [
worksheet for worksheet, sheet_type in zip(sheet_names, sheet_types)
if sheet_type[1] == VALID_WORKSHEET
]
for i, sheet_name in enumerate(worksheet_names):
sheet_codename = 'sheet%d.xml' % (i + 1)
worksheet_path = '%s/%s' % (PACKAGE_WORKSHEETS, sheet_codename)
if not worksheet_path in valid_files:
continue
if not use_iterators:
new_ws = read_worksheet(
archive.read(worksheet_path),
wb,
sheet_name,
string_table,
style_table,
color_index=style_properties['color_index'],
keep_vba=keep_vba)
else:
new_ws = read_worksheet(
None,
wb,
sheet_name,
string_table,
style_table,
color_index=style_properties['color_index'],
sheet_codename=sheet_codename)
wb.add_sheet(new_ws, index=i)
if not use_iterators:
# load comments into the worksheet cells
comments_file = get_comments_file(sheet_codename, archive,
valid_files)
if comments_file is not None:
read_comments(new_ws, archive.read(comments_file))
wb._named_ranges = read_named_ranges(archive.read(ARC_WORKBOOK), wb)
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.excel_base_date, CALENDAR_WINDOWS_1900)
def _load_workbook(wb, archive, filename, use_iterators, keep_vba):
valid_files = archive.namelist()
# If are going to preserve the vba then attach a copy of the archive to the
# workbook so that is available for the save.
if keep_vba:
try:
f = open(filename, 'rb')
s = f.read()
f.close()
except:
pos = filename.tell()
filename.seek(0)
s = filename.read()
filename.seek(pos)
wb.vba_archive = ZipFile(BytesIO(s), 'r')
if use_iterators:
wb._archive = ZipFile(filename)
# get workbook-level information
try:
wb.properties = read_properties_core(archive.read(ARC_CORE))
wb.read_workbook_settings(archive.read(ARC_WORKBOOK))
except KeyError:
wb.properties = DocumentProperties()
try:
shared_strings = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
shared_strings = []
try:
wb.loaded_theme = archive.read(ARC_THEME) # some writers don't output a theme, live with it (fixes #160)
except KeyError:
assert wb.loaded_theme == None, "even though the theme information is missing there is a theme object ?"
style_properties = read_style_table(archive.read(ARC_STYLE))
style_table = style_properties.pop('table')
wb.shared_styles = style_properties.pop('list')
wb.style_properties = style_properties
wb.properties.excel_base_date = read_excel_base_date(xml_source=archive.read(ARC_WORKBOOK))
# get worksheets
wb.worksheets = [] # remove preset worksheet
for sheet in detect_worksheets(archive):
sheet_name = sheet['title']
worksheet_path = sheet['path']
if not worksheet_path in valid_files:
continue
if not use_iterators:
new_ws = read_worksheet(archive.read(worksheet_path), wb,
sheet_name, shared_strings, style_table,
color_index=style_properties['color_index'],
keep_vba=keep_vba)
else:
new_ws = read_worksheet(None, wb, sheet_name, shared_strings,
style_table,
color_index=style_properties['color_index'],
worksheet_path=worksheet_path)
wb.add_sheet(new_ws)
if not use_iterators:
# load comments into the worksheet cells
comments_file = get_comments_file(worksheet_path, archive, valid_files)
if comments_file is not None:
read_comments(new_ws, archive.read(comments_file))
wb._named_ranges = list(read_named_ranges(archive.read(ARC_WORKBOOK), wb))
def test_read_properties_core(self):
content = self.archive.read(ARC_CORE)
prop = read_properties_core(content)
eq_(prop.excel_base_date, CALENDAR_WINDOWS_1900)
if isinstance(filename, file):
# fileobject must have been opened with 'rb' flag
# it is required by zipfile
if 'b' not in filename.mode:
raise OpenModeError("File-object must be opened in binary mode")
try:
archive = ZipFile(filename, 'r', ZIP_DEFLATED)
except (BadZipfile, RuntimeError, IOError, ValueError), e:
raise InvalidFileException(unicode(e))
wb = Workbook()
wb._set_optimized_read()
try:
# get workbook-level information
wb.properties = read_properties_core(archive.read(ARC_CORE))
try:
string_table = read_string_table(archive.read(ARC_SHARED_STRINGS))
except KeyError:
string_table = {}
style_table = read_style_table(archive.read(ARC_STYLE))
# get worksheets
wb.worksheets = [] # remove preset worksheet
sheet_names = read_sheets_titles(archive.read(ARC_APP))
for i, sheet_name in enumerate(sheet_names):
sheet_codename = 'sheet%d.xml' % (i + 1)
worksheet_path = '%s/%s' % (PACKAGE_WORKSHEETS, sheet_codename)
if not use_iterators:
new_ws = read_worksheet(archive.read(worksheet_path), wb,
