Excel Table Formatting

[Ending]

Ok, I've spent pretty well 3 hours searching around for this...

What I'm looking for is a search engine that will read an Excel exported html spreadsheet and return the requested data.

I have most of the data together, exported, the menus finished, just lacking some sort of search engine to finish this off.

Basically its for looking up pipes, steel, concrete, whatever the person selects there will be different forms to search each of the different database html pages.




If anyone knows of some code (I'm most familiar with Javascript, HTML, XML, and different chunks of C++) that could possible search an entire document, grab the info, display it up, ALONG with the proper fields, I'd be more thrilled then a beer for each hand and the Cowboy's cheerleaders putting a strip tease for my next birthday.

(Ex:

Size | Description | Matrix
1" | Buttweld | P

That is what I would like displayed as an example if I did a search on 1" [with the chance that many hundred could be found in one database].)

Thanks in advance.


Ah, FYI, I'm also on an Intranet so security shouldn't be any problem.

[ray326]

Is there anything magic about the HTML export? I.e. could you use a different format? Why exactly are you doing it this way?

[Ending]

Well, basically I've put together some rather large databases that I export into HTML. I'm basically building a website for a internet.

People load up a page.
Select what type of building material they are looking for.
A search page pops up.
Type in any information needed, more info, better results.
It searches the selected material pages I have selected for it to search.
Then displays results in a table format that could be printed out.

The results would include any selected choices they made before doing the final search.

So if they want prices, codes, descriptions, etc... Or all.

I'm doing it this way, because the company I work for mainly uses Excel (don't ask me why, it seems to be the more popular choice over WinEst or Access). I'm just trying to make it as user friendly as possible when it comes to updating records. Load Excel, make changes, export the HTML sheet, place it in the proper folder, done.

Have a feeling I might have to go with the access route... *Grumble* Probley have to include a list of instructions as to how to make reports, heh.

Anyone else happen to know or is able to produce the type of code I'm looking for? So far no one on the entire net has anything like this and I don't have a ton of time to create a script for this. =( (Probley work on it later in a couple of weeks...)

If not, thanks anyway to the people who at least viewed the post.

[Fang]

Sounds like a job for PHP.
PHP could easily search an excel .csv file and display the results as a html page.

[ray326]

If you can't put it in a real database and online it's read-only then I agree with Fang but I'd go with tab separated instead of CSV -- even easier to parse, regardless of back end.

[Ending]

Well, I'm only good with the langauges I posted at the top there... I figured PHP would crack it pretty easy. If there is some way of creating a notepad with just spaces I could program a C++ program... *Shrugs*

Thanks anyway eh?

[ray326]

Tab separated would be a snap in C++.