def test_create_evaluate_update(self):
spreadsheet = Spreadsheet()
spreadsheet.cell_add('Sheet1!A1', value=1)
spreadsheet.cell_add('Sheet1!A2', value=2)
spreadsheet.cell_add('Sheet1!A3', formula='=SUM(Sheet1!A1, Sheet1!A2)')
spreadsheet.cell_add('Sheet1!A4', formula='=SUM(Sheet1!A1:A2)')
spreadsheet.cell_add('Sheet1!A5', formula='=SUM(Sheet1!A1:A1)')
self.assertEqual(spreadsheet.evaluate('Sheet1!A3'), 3) # test function
self.assertEqual(spreadsheet.evaluate('Sheet1!A4'), 3) # test range
self.assertEqual(spreadsheet.evaluate('Sheet1!A5'), 1) # test short range
spreadsheet.set_value('Sheet1!A2', 10)
self.assertEqual(spreadsheet.evaluate('Sheet1!A3'), 11) # test function
self.assertEqual(spreadsheet.evaluate('Sheet1!A4'), 11) # test range
self.assertEqual(spreadsheet.evaluate('Sheet1!A5'), 1) # test short range
def test_load_stream(self):
file_name = os.path.abspath("./tests/excel/VDB.xlsx")
with open(file_name, 'rb') as fin:
spreadsheet = Spreadsheet(fin)
# really just testing the loading from "fin", but check one cell to be sure it read
self.assertEqual(spreadsheet.evaluate('Sheet1!A2'), "Init")