KB-91923: Exporting a report to CSV format.

Question:

Can reports with .CSV extension be generated? I’ve tried doing so with the Export method but haven’t succeeded.

Solution:

Yes, they can. When the report has been previously set up, you can add a separator by selecting a TEXT export; to do so, use the script below.
 

      Set Report = Application.LoadReport(“[Relatório1]”)
      Set reportFilter = report.GetExportFilter(“TEXT”)
      reportFilter.FileName = “C:\report.csv”
      reportFilter.TextDelimiter = “,”
      report.Export reportFilter

 
When no report has been previously created, you can generate de CSV file directly from E3Browser, via Export library .

Este artigo foi útil? Was this post helpful?
Yes0
No0

Deixe seu Comentário

Seu endereço de e-mail não será publicado. Campos marcados com asterisco são obrigatórios *