Simplicty and flexibility!


Knowledge::

DataEase 7.2 and Excel Export


Parameters


Returns/Result


Examples


Reference

DataEase 7.2 and Excel Export

One of the news in DataEase 7.0 was export to Excel. For some reason this was implemented in a completely different way than all other exports in DFW, and if it ever worked it does not any more.

 

We have had some problems understanding exactly what the goal was with this implementation. We have a feeling that as with so many of the other new features in 7.0, the target was a combination of functionalities that do not go well together.

 

1. If the goal is to export raw data to Excel for further manipulation, the best way to do it is simply to use the standard export facility in DFW and export it as a standard CSV file. CSV file is defined as an Excel file type and can be opend directly in Excel without any help of an import wizard.

 

To export to a CSV file from DFW simply chose the Export dialog from the File menu (Runtime) and type in a Export File Name with the extension .CSV ex. data.CSV

 

Then select Comma(,) as field separator and you are ready.

 

2. For those that liked the Original 7.0 Export to Excel functionality we have located a tool that does this much better and that one can access as a printer driver, and export to from both form, report and DQL.

 

The tool is Print2Excel.

Go to http://www.print2excel.com/ to download a sample or buy the full version.

 

See Also


On the forum about DataEase 7.2 and Excel Export

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

On the blog about DataEase 7.2 and Excel Export


dg3_HelpView