def test_single_workbook_with_all_features(self):
# create test reader
test_xls_path = os.path.join(test_files,'testall.xls')
r = GlobReader(test_xls_path)
# source sheet must have merged cells for test!
book = tuple(r.get_workbooks())[0][0]
self.failUnless(book.sheet_by_index(0).merged_cells)
# source book must also have a sheet other than the
# first one selected
compare([s.sheet_selected for s in book.sheets()],[0,1])
compare([s.sheet_visible for s in book.sheets()],[0,1])
# source book must have show zeros set appropriately:
compare([s.show_zero_values for s in book.sheets()],[0,0])
# send straight to writer
w = TestWriter()
r(w)
# check stuff on the writer
self.assertEqual(w.files.keys(),['testall.xls'])
self.failUnless('testall.xls' in w.closed)
self.check_file(w,test_xls_path)
def test_multiple_books(self,h):
r = GlobReader(os.path.join(test_files,'*.xls'))
book = tuple(r.get_workbooks())[0][0]
# fire methods on filter
f = ColumnTrimmer()
f.next = c = Mock()
r(f)
compare(c.method_calls,[
('start', (), {}),
('workbook', (C('xlrd.Book'), 'test.xls'),{}),
('sheet', (C('xlrd.sheet.Sheet'), u'Sheet1'),{}),
('row', (0, 0),{}),
('row', (1, 1),{}),
('cell', (0, 0, 0, 0),{}),('cell', (0, 1, 0, 1),{}),
('cell', (1, 0, 1, 0),{}),('cell', (1, 1, 1, 1),{}),
('sheet', (C('xlrd.sheet.Sheet'), u'Sheet2'),{}),
('row', (0, 0),{}),
('row', (1, 1),{}),
('cell', (0, 0, 0, 0),{}),('cell', (0, 1, 0, 1),{}),
('cell', (1, 0, 1, 0),{}),('cell', (1, 1, 1, 1),{}),
('workbook', (C('xlrd.Book'), 'testall.xls'),{}),
('sheet', (C('xlrd.sheet.Sheet'), u'Sheet1'),{}),
('row', (0, 0),{}),
('row', (1, 1),{}),
('row', (2, 2),{}),
('row', (3, 3),{}),
('row', (4, 4),{}),
('row', (5, 5),{}),
('cell', (0, 0, 0, 0),{}),('cell', (0, 1, 0, 1),{}),
('cell', (1, 0, 1, 0),{}),('cell', (1, 1, 1, 1),{}),
('cell', (2, 0, 2, 0),{}),('cell', (2, 1, 2, 1),{}),
('cell', (3, 0, 3, 0),{}),('cell', (3, 1, 3, 1),{}),
('cell', (4, 0, 4, 0),{}),('cell', (4, 1, 4, 1),{}),
('cell', (5, 0, 5, 0),{}),('cell', (5, 1, 5, 1),{}),
('sheet', (C('xlrd.sheet.Sheet'), u'Sheet2'),{}),
('row', (0, 0),{}),
('row', (1, 1),{}),
('cell', (0, 0, 0, 0),{}),('cell', (0, 1, 0, 1),{}),
('cell', (1, 0, 1, 0),{}),('cell', (1, 1, 1, 1),{}),
('workbook', (C('xlrd.Book'), 'testnoformatting.xls'), {}),
('sheet', (C('xlrd.sheet.Sheet'), u'Sheet1'), {}),
('row', (0, 0), {}),
('row', (1, 1), {}),
('row', (2, 2), {}),
('row', (3, 3), {}),
('row', (4, 4), {}),
('row', (5, 5), {}),
('cell', (0, 0, 0, 0), {}),
('cell', (0, 1, 0, 1), {}),
('cell', (1, 0, 1, 0), {}),
('cell', (1, 1, 1, 1), {}),
('cell', (2, 0, 2, 0), {}),
('cell', (2, 1, 2, 1), {}),
('cell', (3, 0, 3, 0), {}),
('cell', (3, 1, 3, 1), {}),
('cell', (4, 0, 4, 0), {}),
('cell', (4, 1, 4, 1), {}),
('cell', (5, 0, 5, 0), {}),
('cell', (5, 1, 5, 1), {}),
('sheet', (C('xlrd.sheet.Sheet'), u'Sheet2'), {}),
('row', (0, 0), {}),
('row', (1, 1), {}),
('cell', (0, 0, 0, 0), {}),
('cell', (0, 1, 0, 1), {}),
('cell', (1, 0, 1, 0), {}),
('cell', (1, 1, 1, 1), {}),
('finish', (), {})
])
self.assertEqual(len(h.records),0)
