export data into an exel file

Classic Servoy
1

Hi at all,

I have to export my data into an exel file(or similar),does exist a way to launch this functionality from the source code?
My real necessity is to create an export of my db and reload it when I need it.(like “unload” function of sybase central).
Before create the functionality by myself I would to know if does exist something of already done.

Thanks in advance

Marco

(servoy 5.2.1 java 1.6u21 win xp)

2

See this post for example.

3

Marco R.:
My real necessity is to create an export of my db and reload it when I need it.(like “unload” function of sybase central).

Hi Marco, if you’re going to transfer data between 2 servers, please be careful with the column order.
It’s easy running into errors while importing data in the wrong column again.

do you need to transfer data between 2 sybase databases?

4

Hi Marc !
No, I would to make a photo of my actual db because I’m preparing a Sample environment with sample data and
I would reload every time the data without fill it manually and without write it into the code.

@Joas: Very interesting link! thanks!

I saw else the function getAsText() of dataset object,I’ll compare this two solution and eventually with the xml export.

The best way I have imagined is a function like “exportToExel” and another like “importFromExel” or similar format. :)

Thanks at all

Marco