🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

[SOLVED] save/export data to excel file (after crawling and extr. info w/ xpath)

User: "PASEE"
New Altair Community Member
Updated by Jocelyn
hey folks,

im working on a project where i want to download data from a website (crawl), filter this data using xpath, (maybe select some of the attributes) and save the extracted attributes to a file (e.g. excel).

what im currently doing:
1. crawl the web (using either "crawl web")
result of this step: various html files in a given directory

2. load the files and extract information with xpath (using "process documents from files" and "extract information")
result of this step: exampleSet with some metadata (file, path, date) and my xpath attributes, e.g. "title", "header1", etc..

so far, everything seems to work fine.

what's not working yet:
(just as a maybe: 3. select certain attributes (operator "select attributes" only lists the metadata attributes, but not my xpath attributes))
4. save to excel-file (i have absolutely no idea how this can be achieved)

this shouldnt be too difficult but after watching all vancouverdata/neuralmarkettrends/rapid-i tutorials i havent found out how to do it. ive tried a lot of operators and searched google and this forum but there seems to be no documentation giving answer to this question.

thanks in advance for your help!

best regards,
PASEE

Find more posts tagged with