curso["inicio"] = row+1
curso["nombre"] = celda.value
if val== -1 and cadena_vacia == True:
curso["fin"] = row
cursos.append(curso)
if row == numRows:
curso["fin"] = row+1
cursos.append(curso)
#for curs in cursos:
# print curs
return cursos
if __name__=="__main__":
path="xls_tmp_seat.xls"
#path="xls_tmp.xls"
serializer= SerializeXMLinXLS()
wb = open_workbook(path)
cursos = getCursos(wb)
path="../files/extraidos"
for curso in cursos:
output_path = os.path.join(path,curso["nombre"])
ini = curso["inicio"]
fin = curso["fin"]
#print output_path, ini, fin
serializer.deserialize(wb, output_file=output_path, ini_row=ini, end_row=fin)
#serializer.deserialize(self, book=None, output_file="deserialized_xls.xml", sheet_name="structure", ini_row=0, end_row=1, wb_path='test.xls'):
'''
files=getFiles("xml",path)
excel=ExcelFile()
Created on 21/09/2011
@author: scalvofe
'''
import os
'''
import xml_xls_serializer.xml_maps.xml_node_mappers
from xml_xls_serializer.xml_xls_extracter.xml_extract_tag import TagExtracter
from xml_xls_serializer.xml_xls_extracter.xls_xml_mapper import ExcelMapper, MapperToXML
from xls_utils.xls import ExcelFile
MappedError=xml_xls_serializer.xml_maps.xml_node_mappers.MappedError
XlsMap=xml_xls_serializer.xml_maps.xml_node_mappers.MapperXMLinXls
from xlwt import XFStyle, Borders, Pattern, Font
'''
from xml_xls_serializer.xml_xls_serializer import SerializeXMLinXLS
from xls_utils.xls import ExcelFile
def getFiles(fileType,path):
list_of_files = [os.path.join(path,file) for file in os.listdir(path) if file.lower().endswith(fileType)]
return list_of_files
if __name__=="__main__":
path="../files/xml_files/"
files=getFiles("xml",path)
excel=ExcelFile()
serializer= SerializeXMLinXLS(files[0],excel)
titulos=["nivel","isText","numHijos","texto","atributos","posicion","nombre","nombrePadre"]
serializer.serialize(sheetName="hoja_estructura")
excel.save("hoja_de_prueba.xls")
serializado=serializer.getXMLSerializedAsXLS() #xml serializado en excel
serializer.deserialize(wb_path="hoja_de_prueba.xls", output_file="salida_.xml", sheet_name="hoja_estructura", ini_row=0, end_row=125)
