def test_write_puede_mover_el_cursor_para_abajo(self):
#Setup
excel = WriterExcelManager()
# Excersice
excel.write('Hola mundo', continue_in_new_line=True)
# Verify
row, column = excel.get_active_cell()
self.assertEquals((1, 0), (row, column))
def test_write_mueve_el_cursor_a_la_derecha(self):
#Setup
excel = WriterExcelManager()
# Excersice
excel.write('Hola mundo')
# Verify
row, column = excel.get_active_cell()
self.assertEquals((0, 1), (row, column))
def test_puedo_escribir_1000_columnas(self):
""" El máximo de columnas en un excel es de 65536.
"""
#Setup
excel = WriterExcelManager()
# Excersice
for i in xrange(70000):
excel.write(i)
# Verify
cantidad = excel.get_sheet_qty()
self.assertEquals(1, cantidad)
def test_crear_excel_deja_el_archivo_listo_para_usar(self):
#Setup
excel = WriterExcelManager()
# Excersice
excel.write('Hola mundo')
def test_puedo_imprimir_multiples_tipos_de_dato_y_no_falla(self):
#Setup
excel = WriterExcelManager()
excel.set_active_cell(0, 5)
# Excersice
excel.write('string')
excel.write(u'unicode')
excel.write('áéíóú'.decode('latin1'))
excel.write('áéíóú'.decode('utf-8'))
excel.write('áéíóú'.decode('utf-16'))
excel.write(unichr(40960))
excel.write(1)
excel.write(1L)
excel.write(date(2012, 12, 13))
excel.write(datetime(2012, 12, 13, 15, 15))
excel.write(time(15, 15))
excel.write(1.5)
excel.write(None)
excel.write([1, 2, 3])
excel.write((1, 2, 3))
excel.write({1: 1, 2: 2})