Import from an Excel fiel

HCL Domino Domino Forum
1

Is it possible to import data from an Excel file into a LN db without Excel being present on the machine doing the import. If it is possible could someone point me in the right direction

2

Subject: Not possible without Excel–Import from an Excel fiel

Since Notes doesn’t have a built in import function to import Excel data, the only way to accomplish this is to use OLE in LotusScript. You can not use OLE unless the server or workstation processing the agent has Excel installed on the machine. So in the case of importing excel files using a scheduled agent you would have to install Excel on the server running the agent.

hth.

Brandt

3

Subject: Import from an Excel fiel

Let 's try this 1. Change the excel data like this

Fieldname1 Fieldname2 Fieldname …N

data1 data2 data…N

data4 data5 data…

set the header same as target filed name

  1. Open target view and use import menu from Lotus Notes to import into the view.

  2. Enjoy.

I did not try for a lot of data.

4

Subject: Import from an Excel fiel

I have not checked it, but I suspect that you only need some runtime kernel to be able to access Excel data. The application itself probably not.