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)