Notes/Domino XPages Development Forum - How to import data to view from excel

Apr 25, 2012, 8:25 AM

7 Posts

Re: How to import data to view from excel

I can use lotus script agent to imort data from excel on local. but i put this db on server. How do I get client side excel file path and import data from client side excel file.

~Judy Ektumizenynds

Apr 25, 2012, 5:49 PM

7 Posts

Re: How to import data to view from excel

Hi,

I guess you are importing data from excel to domino view using some action button from application. If that is the case when you want to import data launch the server database and have an action with prompt asking to select you the file from system.

Hope that helps.

Thanks

~Tip Minveluakol

Apr 26, 2012, 12:52 AM

7 Posts

Re: How to import data to view from excel

Dear basu : I will try it according to your advice .thanks

~Delores Ekfreeverakol

May 22, 2012, 5:49 PM

14 Posts

Re: How to import data to view from excel

Presuming you want to give the user some option to select, you could use the NotesUIWorkspace.OpenFileDialog:

getFile = ws.OpenFileDialog(False, "Truckload Pricing Advisements","Microsoft Excel|*.xls","C:\","Import.xls")

If (Isarray(getFile)) Then

ans$ = Cstr(getFile(0))

Else

ans$ = "Cannot access a file"

End If

ans$ will be the file, if one is selected. OpenFileDialog returns an array if something is selected (and you can set to allow multiple selections) or Empty if not.

Cheers,

Brian