NetTalk Central

Author Topic: export to excel in hand code - without browse  (Read 3578 times)

Robert Iliuta

  • Sr. Member
  • ****
  • Posts: 472
    • View Profile
    • Email
export to excel in hand code - without browse
« 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

MyBrainIsFull

  • Full Member
  • ***
  • Posts: 134
    • View Profile
Re: export to excel in hand code - without browse
« Reply #1 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

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: export to excel in hand code - without browse
« Reply #2 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.

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: export to excel in hand code - without browse
« Reply #3 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