excel in qc

chiara's picture

someone can tell me how can I take and display data in QC from an excel sheet? The excel sheet has 3 colums, with some names and geolocations as cities.

Thanks in advance, Chiara

cybero's picture
Re: excel in qc

I import Excel as .xls or in .csv form and convert it into XML after having checked that I've got the data and results entered as suits what I want to out put.

You can use Oxygen XML Editor to do this or else use the freeware [& compile at source] csv2xml from sourceforge.

Then you can just use the structure tools to get the data from the XML structure.

Hope that helps.

Have a nice day :-)


See attached working proof of concept - a rough draft, but it should give you an example to test out your planned composition with in regards of the XML import.

PreviewAttachmentSize
xls2xml.zip4.91 KB

DanieleCiabba's picture
Re: excel in qc

Ciao Chiara, credo che la via dell'xml sia l'unica per ora... ciao Daniele

cybero's picture
Re: excel in qc

Buona Giornata,

Basta tenere la selezione di esportazione discreto & pertinentemente dettagliat

[Just keep the export selection discrete & pertinently detailed]

:-)

chiara's picture
Re: excel in qc

Thank you very much for your reply and for the example you made ;-) My interactive project is a bit difficult, 'cause uses via terminal also a jar named twitter4j that make query and streaming from some twitter's accounts. I put data that comes from a txt file into excel in order to use the google api on the map. Better if i write an email...