...

View Full Version : How to create csv using importXML (Xpath)



Scharfheimlich
07-31-2012, 10:01 AM
Good morning to everybody,

as you maybe know on Google spreadsheet you can use only 50 inportXML functions at one sheet - unfortunately I have reached this limit soon... So I would like to ask you how create PHP which will create .csv file using this functions...

For example: I have circa 100+ different URLs (in ImportXML function as UR1, URL2...) from which are data taken and result in csv would look like this:

"number","Width","Length", ... etc
001,any text + ImportXML("URL1","//tr[td/text()[contains(.,'Width')]]/td[2]"),any text + ImportXML("URL1","//tr[td/text()[contains(.,'Length')]]/td[2]"), ... etc
002,any text + ImportXML("URL2","//tr[td/text()[contains(.,'Width')]]/td[2]"),any text + ImportXML("URL1","//tr[td/text()[contains(.,'Length')]]/td[2]"), ... etc


Does, please, anybody know how to do that?

With kind regards... Stefan alias "Scharfheimlich"



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum