export to excel in hand code - without browse

[Robert Iliuta]

Hallo,


Is there a way to simulate the code from export to excel button from a browse?
I would like to have that but without the browse.

Thank you,
Robert

[MyBrainIsFull]

But Robert, why would you not run the fill for the browse on the server
as
press button,  server code is
set(key, key)
loop (file)
   cycle condition
   temp Q  - or temp mem-file  = record
   add
end

Make Excel from temp Q
- - Blah  eg. make excel csv or whatever, serve it - or dump it to disk and serve it.

You dont really care whats on the browser

K

[kevin plummer]

CSV is pretty bland + you need to be careful with your data that has inverted comma's and comma's in it. You can use com with CS Office product but then you need to have Excel installed on the sever. The new feature creates XML styled files so you get the best of both worlds.

[Bruce]

Robert,

Take a look at the generated code in the browse. SaveToExcel I think the routine is called.
It should be straight-forward to take that code into say a source procedure and call it from anywhere.

Cheers
Bruce