Export to excel fails

  • Thread starter Thread starter Dino Minichiello
  • Start date Start date
D

Dino Minichiello

Hello
In IE6 there is this nice function called "export to excel" which appears in
the context menu when right clicking with the mouse over a html table.
Because this functionality makes a URL request, this does not work for
Internet applications which require user authentication. Based on the fact,
that in the html table the data is already there (so why the hell it
retrieves the data again from the URL ), is there a way to hack this
functionality so that it uses the local data in the html page or any other
ways to get this working?

It is a very nice feature, but based on the fact that almost all internet
business applications requires a user login , this is very unuseful.

thank you for any hints on this.
Dino
 
Hi Dino,

Actually there is a local script that is run that is read from the
excel.exe. If you have a look at the context menu setting for this item in
your registry you will see something similar to this
HKCU\Software\Microsoft\Internet Explorer\MenuExt\E&xport to Microsoft Excel

Default value = res:\\{Office install path}\Excel.exe/3000

Where 3000 is the ID of the script that is executed from within Excel.exe.
If you have a resource editor like Resedit you can view the script and see
how it works. It definately does not do a refresh on the page, but works by
creating a selection range from the current page..Creating an Excel instance
and then exporting the selection range to the new spreadsheet.

There could be a number of reasons why this is not working. At first thought
check your Contexts value under the above registry key. It should have a
value of 1.
 
Back
Top