def test_leo_un_string_y_me_devuelve_el_tipo_text(self):
#Setup
filename = 'excelutils/excel_ejemplo.xls'
excel = ReaderExcelManager(filename)
excel.set_active_cell(4, 0)
expected = (u'fila 5', ReaderExcelManager.TYPE_TEXT)
# Excersice
result = excel.read()
# Verify
self.assertEquals(result, expected)
def test_reset_sheet_funciona_ok(self):
#Setup
filename = 'excelutils/excel_ejemplo.xls'
excel = ReaderExcelManager(filename)
excel.set_active_cell(3, 3)
# Excersice
excel.reset_sheet()
# Verify
row, column = excel.get_active_cell()
self.assertEquals((0, 0), (row, column))
def test_go_to_first_column_in_row_funciona_ok(self):
#Setup
filename = 'excelutils/excel_ejemplo.xls'
excel = ReaderExcelManager(filename)
excel.set_active_cell(3, 0)
# Excersice
excel.go_to_first_cell_in_column()
# Verify
row, column = excel.get_active_cell()
self.assertEquals((0, 0), (row, column))
def test_leo_un_numero_entero_y_me_devuelve_el_tipo_float(self):
#Setup
filename = 'excelutils/excel_ejemplo.xls'
excel = ReaderExcelManager(filename)
excel.set_active_cell(3, 1)
expected = (1.0, ReaderExcelManager.TYPE_FLOAT)
# Excersice
result = excel.read()
# Verify
self.assertEquals(result, expected)
def test_me_muevo_con_set_active_y_al_leer_me_devuelve_el_resultado_esperado(
self):
#Setup
filename = 'excelutils/excel_ejemplo.xls'
excel = ReaderExcelManager(filename)
excel.set_active_cell(4, 0)
expected = (u'fila 5', ReaderExcelManager.TYPE_TEXT)
# Excersice
result = excel.read()
# Verify
self.assertEquals(result, expected)
def test_leo_un_valor_y_el_cursor_se_mueve_a_la_primer_celda_de_la_fila_siguiente_si_estoy_en_la_ultima_celda_de_la_fila(
self):
#Setup
filename = 'excelutils/excel_ejemplo.xls'
excel = ReaderExcelManager(filename)
excel.set_active_cell(0, 3)
# Excersice
excel.read()
# Verify
row, column = excel.get_active_cell()
self.assertEquals((1, 0), (row, column))