Javascript : Javascript form error Excel web query

[sudris]

Dear Friends

Please excuse me if this is not the correct section for this thread.

I'm trying to import html based table in excel using web query. data gets fetched for the default selected items in the dropdown box but not for other items. I guess, a javascript seems to be the catch.

I've to select other items form the dropdown box and click on 'Go' to get the table in web browser but have no clue how to get it done automated for excel web query.

here the link to the page.

I'm not so familiar with html and javascript, please help me out.
Thanks

[sudris]

Nobody?

[gep13]

Hello,

Are you talking about an Excel file that lives on the client machine? Or are you talking about a file that lives on the server?

If on the client then JavaScript/jQuery will really be your only option. You will find an example of how this can be done here:

http://www.databison.com/index.php/r...avascript-sql/

Gary

[sudris]

Gary, thanks for your reply. It is a client side file.
The link you provided gives a way to write to excel file. This definitely covers the latter half of the goal.
Could you please provide any example for JavaScript or JQuery. I've very little idea about this part.
I would not like to be spoon-fed but an example would be great.

Besides, I guess, the server sends back the data to web browser as "post" method is used. Will it be possible to use "get" method and communicate directly to the server directly.

Thanks

[SambaNeko]

I understood OP's request as: he wants to take the data table from the page he linked, and make an Excel file out of it. Is that right?

If so, that would require PHP (or other server-side language). You'd need to fetch the page's contents, get the markup that forms the table, put that in its own file, and save that file as .xls.

[sudris]

SambaNeko, you got me right. I want the resulting table to be stored in excel or csv.
It would be so kind of you to present a simple example.

[gep13]

Hello,

Ah ok, I see what is being requested.

sudris, in order to provide an example, we would need to know which server side language you are able to use. Can you provide details of your experience level, or availability of a server side language that you want to use.

Gary

[sudris]

Gary, thanks.
Honestly, I'm not into any programming but had very little experience with SQL. And if I've not mistaken, this particular server relies on PHP, I might be wrong though.

Would definitely try to understand php and sql in much depth as I am close to beginner level.
To get started, I would need a simple example(with one or two parameters) preferably in PHP in context to the particular link I had posted.

[sudris]

Hi Gary, would it be possible to get any example?