KB-32745: E3/Excel communication.

Question:

How can E3 communicate with Excel?

Solution:

There are a few possibilities:

  • Using DDE driver (which is indicated when you just need to exchange data between E3 and Excel);
  • Using ADO connection (which is indicated when you need Excel to work as a Database);
  • Using the object EXCEL.APPLICATION.

NOTE: attached to this article, there is a demo application that shows how to get data from an Excel spreadsheet creating an ADO connection via scripts.

Attachments:

ExcelADO

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 *