Importing problem

HCL Domino Domino Forum
1

HI ALL

How to import data from excel sheet to notes using inbuilt method

2

Subject: importing problem

'Try with the below code Set Excel = CreateObject(“Excel.Application”)

Excel.Visible = False

Excel.Workbooks.Open(FilePath)

Set ExcelWorkbook = Excel.ActiveWorkbook

Set ExcelSheet = ExcelWorkbook.ActiveSheet

Set ExcelCells = ExcelSheet.Cells



Set view = db.GetView("allByRefKeysPP")

Set doc=view.GetDocumentByKey(refkey,True)







'Importing the financials from the Excel sheet to Project Parameters document

r=13 ---> row

c=5  ---> Column

%rem

arrOfFields(i) – > this is your field name.

ExcelCells( r,c).Value — > In the Excel Value

%end rem

Call doc.ReplaceItemValue(arrOfFields(i),ExcelCells( r,c).Value)

3

Subject: RE: importing problem

CAN YOU SEND FULL CODE FOR THIS

4

Subject: Free Import Tool

We have a Lotus Notes / Domino import utility you can freely download from our website at:Import Utility for Notes

It automatically handles importing from Excel, CSV, Tab, Outlook and other file formats.

Lots of other great features too such as duplicate handling, document updates, etc.

Hope it helps.

Alex

5

Subject: importing problem

reddy m, I notice you post a lot of questions in this forum. Do you ever use the Search on this forum to see if your questions have already been asked by someone else?

For example, there are hundreds of threads on importing data from excel.

http://www-10.lotus.com/ldd/nd6forum.nsf/search/?SearchView&query=import%20and%20from%20and%20excel&SearchOrder=1&SearchWV=1&SearchFuzzy=1&SearchMax=0&Start=1&Count=100

Also, the people who help out here usually prefer it if you at least have a go at doing these things first, rather than posting up a question for every thing you need to do and just asking for code straight away. Search the forums, read the Designer help, have a go at the code for yourself; then if you get stuck post a question along with whatever code you have written.

6

Subject: RE: importing problem

Great post… He’s flooding (spamming I would call it) the forum and it seems like he never actually reads the reply’s (If there’s no code in it) let alone thank’s people who help him…

7

Subject: Free Import Tool

We have a Lotus Notes / Domino import utility you can freely download from our website at:Import Utility for Notes

It automatically handles importing from Excel, CSV, Tab, Outlook and other file formats.

Lots of other great features too such as duplicate handling, document updates, etc.

Hope it helps.

Alex

8

Subject: RE: importing problem

Good post David

Nothing switches people’s desire to help off quicker than the sight of “PLEASE POST FULL CODE”

Mike