Yet another excel import thread

Classic Servoy
1

Hello, this subject has been tossed around for a while, but I haven’t seen it addressed recently. Currently we have the need for functions that do stuff like:

  • Display a report with the content of the excel file (like asking the user to confirm before updating the DB)
  • Import the excel data to a table and complete other field with default values
  • Or read the excel data and based on that CREATE transactions in different tables (meaning data is not imported as-is, its transformed and stored in various tables)

In these cases the user doesnt have to know which connections, tables or field mapping are used in order to do that, its all done programatically. Is there a way to do this without having to acquire the IT2BE dataplugin? I feel this is way too essential to be left out of servoy, specially considering the fact that most of us are migrating from other development platforms and/or have to integrate with other systems through files.

Thanks in advance for your inputs…

2

There is a feature request open on JIRA regarding Excel:

You may wish to considering voting for it, if you haven’t already done so.

We migrated to Servoy from VFP where importing Excel files was a one line command…we miss that in Servoy.

3

Yep, I had voted for it. Do you know if there are any workarounds for this?

4

One of our customers receives Excel spreadsheets containing detail costs from various vendors. Our customer saves the spreadsheet as a comma delimited CSV file which is a file save option in Excel. We then read the CSV file as a text file and parse the data line by line. As each line is read, we create a new record and populate it with the extracted data.

Perhaps, someone else has a more eloquent work around.

5

In VFP, you certainly had 'Import From … Type XL8" but that only handled up to Excel 97 format.