NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Robert Iliuta on October 22, 2014, 03:32:11 AM

Title: export to excel in hand code - without browse
Post by: Robert Iliuta on October 22, 2014, 03:32:11 AM

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

Title: Re: export to excel in hand code - without browse
Post by: MyBrainIsFull on October 22, 2014, 04:03:02 AM

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

Title: Re: export to excel in hand code - without browse
Post by: kevin plummer on October 22, 2014, 04:55:39 PM

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.

Title: Re: export to excel in hand code - without browse
Post by: Bruce on October 22, 2014, 09:44:14 PM

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