Import from Excel

HCL Domino Domino Forum
1

Hi,

I have an Excel sheet filled with rows of data. My requirement is i have to use the documents or rows in Excel sheet and create new document for each row in the Lotus notes database for a form. Can anyone help me on this.

Thanks in advance.

2

Subject: Import from Excel

My preferred solution for this would be to save the Excel table as a CSV file. Then create an LS agent which reads this file line by line. For each line create a new NotesDocument and fill the fields as needed with the contents from the line.

3

Subject: RE: Import from Excel

Can you please give me the code as how to read and create documents.

4

Subject: RE: Import from Excel

HI you may try Simply Notes ImpEx. This Shareware allows you to setup an import using normal Notes documents. you directly import and / or export to CSV, Excel or Lotus 1-2-3

checkout http://www.simply-notes.de/ImpExPro_300.zip

(the english web site has not yet been updated)

5

Subject: RE: Import from Excel

Google it. You will get it.

6

Subject: Free Lotus Notes/Domino Import Utility

If you had searched this forum you would have found many examples on how to do what you need to and many different solutions.

Anyway…

We have a Notes/Domino Import Utility you can freely download from our website that enables you to perform imports directly from Excel (and other file formats) directly into any database.

You can download it from:

Hope it helps.

Alex