read data out of htm-file

[tobias_tessmer82@web.de]

dear guys

i got the problem that i want to get some data out of a htm-file. that is why i have to choose a format that is more "universal" than an excel-file

the problem is i got a excel-file and save it as htm/html - file because i got a excel-book with more than 20 linked spreadsheets in it and there is

no other format in excel that can handle this linking by being universal enough to start my program on some other pc's

so i dont want to manage it in excel because there are usually some version-conflicts using the original program of the project i am working on.

so is it basically possible to get data out of a htm-file and if the answer is yes how....??

[Norbert_B]

Tobias,

i am not familiar with html files created by excel esp. with links of worksheets.
Nevertheless, html files are ASCII-files which follow a certain layout. The "layout" is called tags. Therefore, your wanted information is included in the file between a series of different tags.
If you like to learn about html, you can take a look into self-html.

Now, a way which should work, but could be very cumbersomely to go through: just parse the html-file until you find the data. The easiest point here is if your data always has some kind of header you can directly search....

hope this helps,
Norbert B.

[tobias_tessmer82@web.de]

thx norbert for your information i managed the fact to read out the ascci code but as you mentioned it is very hard to find out where the data is i need for my programm

thx for the help with the explanation-link

do you see another possibillity to handle an excel doc with certain links in it (worksheets) maybe another more "universal"-format

or is there a chance to read the information from the panel of a htm/html doc

answers are welcome.....

thx crash

[Norbert_B]

Tobias,

there could be several ways to solve your request.
As far as i understand you like to create an offline analysis of your data. Datasource is excel.
If you can switch to "online analysis", you could use ActiveX to fetch data from excel and perharps write results back to it from LV.
If you stay offline, you have to choose a mechanic which works out for you. Since it seems to me that the file format is kind of given, you have to go through the analysis regardless of its effort (which can get very ugly....).
In any case, you can view a file as a stream of data. The only question is how this stream looks like. This defines how you have to interpret the stream. ASCII-files can be interpreted very easy since you can use all the nice stringfunction (search and so on). Disadvantage is that these mechanics are slow. Binary files are faster, but you have to know very good how the file was created.
Again, in any case, you have to know where the data are....
So i fear that you have to go the whole way and analyse the files to know where to search for your content.....

Norbert

[tobias_tessmer82@web.de]

 i know some stuff about the online-analyse-methods via activeX container and that stuff

i was willing to do it like this but as you say it works online....

"so i think i have to take the long road down to ascii-town" as you allready mentioned

 thx for all norbert it was nice to meet you

c u again tobi...