Import Data from excel

hcl-bot · February 12, 2008, 5:12am

Hi,

I want to pull the data from excel to Lotus Notes. I have done this when the file is in local machine. Now the file is in a particular server. How do I do this now?

Can any one pls help me?

hcl-bot · February 12, 2008, 5:53am

Subject: Import Data from excel

Hi!

You have several option … you can using COM to import Excel files to Notes. For this you need an excel installation on the importsystem

Or you can use JAVA ( poi.apache.org ) for importing office files to notes.

I prefer the last option…

Bye

Alex

hcl-bot · February 13, 2008, 7:42am

Subject: Import Data from excel

If the file is in a particular server then the path of the file will be fixed in all cases. So while importing the data you specify that fixed path and run the code.