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.
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.
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...
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.
Ciao Chiara, credo che la via dell'xml sia l'unica per ora... ciao Daniele
Buona Giornata,
Basta tenere la selezione di esportazione discreto & pertinentemente dettagliat
[Just keep the export selection discrete & pertinently detailed]
:-)
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...