def test_create_simple_xls(self):
wb, _ = self.create_simple_xls()
wb.save(in_tst_output_dir('simple.xls'))
self.assertTrue(
filecmp.cmp(in_tst_dir('simple.xls'),
in_tst_output_dir('simple.xls'),
shallow=False))
def test_create_mini_xls(self):
book = xlwt.Workbook()
sheet = book.add_sheet('xlwt was here')
book.save(in_tst_output_dir('mini.xls'))
self.assertTrue(filecmp.cmp(in_tst_dir('mini.xls'),
in_tst_output_dir('mini.xls'),
shallow=False))
def test_create_mini_xls(self):
book = xlwt.Workbook()
sheet = book.add_sheet('xlwt was here')
book.save(in_tst_output_dir('mini.xls'))
self.assertTrue(filecmp.cmp(in_tst_dir('mini.xls'),
in_tst_output_dir('mini.xls'),
shallow=False))
def test_create_bitmap_from_file(self):
book = xlwt.Workbook()
sheet = book.add_sheet('bitmap test')
sheet.insert_bitmap("tests/python.bmp", 1, 1)
book.save(in_tst_output_dir('bitmaps.xls'))
self.assertTrue(filecmp.cmp(in_tst_dir('bitmaps.xls'),
in_tst_output_dir('bitmaps.xls'),
shallow=False))
def test_create_bitmap_from_file(self):
book = xlwt.Workbook()
sheet = book.add_sheet('bitmap test')
sheet.insert_bitmap("tests/python.bmp", 1, 1)
book.save(in_tst_output_dir('bitmaps.xls'))
self.assertTrue(filecmp.cmp(in_tst_dir('bitmaps.xls'),
in_tst_output_dir('bitmaps.xls'),
shallow=False))
def test_create_bitmap_from_memory(self):
book = xlwt.Workbook()
sheet = book.add_sheet('bitmap test')
with open ("tests/python.bmp", "rb") as bmpfile:
bmpdata = bmpfile.read()
sheet.insert_bitmap_data(bmpdata, 1, 1)
book.save(in_tst_output_dir('bitmaps.xls'))
self.assertTrue(filecmp.cmp(in_tst_dir('bitmaps.xls'),
in_tst_output_dir('bitmaps.xls'),
shallow=False))
def test_create_bitmap_from_memory(self):
book = xlwt.Workbook()
sheet = book.add_sheet('bitmap test')
with open ("tests/python.bmp", "rb") as bmpfile:
bmpdata = bmpfile.read()
sheet.insert_bitmap_data(bmpdata, 1, 1)
book.save(in_tst_output_dir('bitmaps.xls'))
self.assertTrue(filecmp.cmp(in_tst_dir('bitmaps.xls'),
in_tst_output_dir('bitmaps.xls'),
shallow=False))
def test_create_less_simple_xls(self):
wb, ws = self.create_simple_xls()
more_content = [[
u'A{0}'.format(i),
u'Zażółć gęślą jaźń {0} {1}'.format(i, LOREM_IPSUM),
] for idx, i in enumerate(range(1000, 1050))]
for r_idx, content_row in enumerate(more_content, 3):
for c_idx, cell in enumerate(content_row):
ws.write(r_idx, c_idx, cell)
wb.save(in_tst_output_dir('less_simple.xls'))
self.assertTrue(
filecmp.cmp(in_tst_dir('less_simple.xls'),
in_tst_output_dir('less_simple.xls'),
shallow=False))
def create_simple_xls(self, filename='simple.xls', more_content=None):
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime(2010, 12, 5), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
if more_content is not None:
for r_idx, content_row in enumerate(more_content, 3):
for c_idx, cell in enumerate(content_row):
ws.write(r_idx, c_idx, cell)
wb.save(in_tst_output_dir(filename))
def create_simple_xls(self, filename='simple.xls', more_content=None):
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime(2010, 12, 5), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
if more_content is not None:
for r_idx, content_row in enumerate(more_content, 3):
for c_idx, cell in enumerate(content_row):
ws.write(r_idx, c_idx, cell)
wb.save(in_tst_output_dir(filename))
def test_create_less_simple_xls(self):
wb, ws = self.create_simple_xls()
more_content=[
[
u'A{0}'.format(i),
u'Zażółć gęślą jaźń {0} {1}'.format(i, LOREM_IPSUM),
]
for idx, i in enumerate(range(1000, 1050))
]
for r_idx, content_row in enumerate(more_content, 3):
for c_idx, cell in enumerate(content_row):
ws.write(r_idx, c_idx, cell)
wb.save(in_tst_output_dir('less_simple.xls'))
self.assertTrue(filecmp.cmp(in_tst_dir('less_simple.xls'),
in_tst_output_dir('less_simple.xls'),
shallow=False))
def create_nan_xls(self, filename='nan.xls'):
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 1)
ws.write(0, 1, float('nan'))
wb.save(in_tst_output_dir(filename))
def test_create_less_simple_xls(self):
self.create_simple_xls(filename='less_simple.xls',
more_content=[[
u'A{0}'.format(i),
u'Zażółć gęślą jaźń {0} {1}'.format(
i, LOREM_IPSUM),
] for idx, i in enumerate(range(1000, 1050))])
self.assertTrue(
filecmp.cmp(in_tst_dir('less_simple.xls'),
in_tst_output_dir('less_simple.xls'),
shallow=False))
def test_worksheet(self):
book = xlwt.Workbook()
first_page = "Page 1"
sheet = book.add_sheet(first_page)
assert sheet.get_name() == first_page
sheet.set_name('Page 2')
assert sheet.get_name() == 'Page 2'
sheet.set_header_str(first_page)
assert sheet.get_header_str() == first_page
sheet.set_footer_str(first_page)
assert sheet.get_footer_str() == first_page
sheet.set_left_margin(0.45)
assert sheet.get_left_margin() == 0.45
sheet.set_right_margin(0.45)
assert sheet.get_right_margin() == 0.45
sheet.set_top_margin(0.45)
assert sheet.get_top_margin() == 0.45
sheet.set_bottom_margin(0.45)
assert sheet.get_bottom_margin() == 0.45
sheet.set_header_margin(0.45)
assert sheet.get_header_margin() == 0.45
sheet.set_footer_margin(0.45)
assert sheet.get_footer_margin() == 0.45
sheet.set_portrait(False)
assert sheet.get_portrait() is False
sheet.set_fit_num_pages(2)
assert sheet.get_fit_num_pages() == 2
sheet.set_fit_num_pages(1)
assert sheet.get_fit_num_pages() == 1
sheet.set_fit_width_to_pages(1)
assert sheet.get_fit_width_to_pages() == 1
sheet.set_fit_height_to_pages(0)
assert sheet.get_fit_height_to_pages() == 0
book.save(in_tst_output_dir('worksheet.xls'))
def test_create_less_simple_xls(self):
self.create_simple_xls(
filename='less_simple.xls',
more_content=[
[
u'A{0}'.format(i),
u'Zażółć gęślą jaźń {0} {1}'.format(i, LOREM_IPSUM),
]
for idx, i in enumerate(range(1000, 1050))
]
)
self.assertTrue(filecmp.cmp(in_tst_dir('less_simple.xls'),
in_tst_output_dir('less_simple.xls'),
shallow=False))
def create_simple_xls(self):
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime(2010, 12, 5), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
wb.save(in_tst_output_dir('simple.xls'))
def create_simple_xls(self):
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime(2010, 12, 5), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
wb.save(in_tst_output_dir('simple.xls'))
def test_example_xls(self):
self.create_example_xls(in_tst_output_dir(EXAMPLE_XLS))
self.assertTrue(filecmp.cmp(in_tst_dir(EXAMPLE_XLS),
in_tst_output_dir(EXAMPLE_XLS),
shallow=False))
def test_example_xls(self):
create_example_xls(in_tst_output_dir(EXAMPLE_XLS))
self.assertTrue(filecmp.cmp(in_tst_dir(EXAMPLE_XLS),
in_tst_output_dir(EXAMPLE_XLS),
shallow=False))
def test_create_simple_xls(self):
self.create_simple_xls()
self.assertTrue(filecmp.cmp(in_tst_dir('simple.xls'),
in_tst_output_dir('simple.xls'),
shallow=False))
def test_create_nan_xls(self):
self.create_nan_xls()
self.assertTrue(filecmp.cmp(in_tst_dir('nan.xls'),
in_tst_output_dir('nan.xls'),
shallow=False))
def test_font_compression(self):
wb, ws = self.create_simple_xls(style_compression = 2)
wb.save(in_tst_output_dir('simple.xls'), )
def test_font_compression(self):
wb, ws = self.create_simple_xls(style_compression=2)
wb.save(in_tst_output_dir('simple.xls'), )
