CODEWITHSUNDEEP
openedgeprogress-4gl
Thiru
Thiru

Reputation: 251

How can I import data from excel?

I am new to progress and I would like to know if there is a way to import data from excel. So far I have done only for CSV. Please share your Exp here!!! I would appreciate that.

Upvotes: 0

Views: 716

Answers (1)

Jensd
Jensd

Reputation: 8031

By far the easiest way for you is to save the excel sheet as CSV and then simply import that. If that's not possible you could take a look at automation of excel to perhaps trigger a Save AS CSV and then import that.

Here's a quite good example in the KnowledgeBase. Please note that there might be changes due to different versions of Excel (also possibly of Progress).

There might also be DotNet APIs that might help you. Look for those in Microsofts documentation in that case.

Upvotes: 2

Related Questions