KB-33732: Exporting data from a historic file to Excel.

Question:

How can I export data from a *.dat file into Excel?

Solution:

To do so, follow these procedures:

1. Via Organizer, add a Text-type report and access Settings tab. On it, click Browse… button and select the desired *.dat file.

2. In the desired event (for example, in a button’s Click event), add a command to execute the PrintToFile function of the previously created report.

Examples:

Reports.Report1.PrintToFile(“historic.xls”, 1, Chr(9), 1) //Exports to an XLS file, where Chr(9) is the separator character
Reports.Report1.PrintToFile(“C:\report.csv”, 1, ” ; “, 1)  //Exports to a CSV file where “;” is the separator character
Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *