Creating Excel sheet as a template

HCL Domino Domino Forum
1

hi,

I am lookinh forward to create a excel template in lotus notes. Lets say; we have a wookbook. In that we have 5 sheets. On sheet 1 there is some data & on sheet other sheets we have some related data & pie charts & graphs related with that data.

All i want is; to use this wookbook as a template; include this in lotus notes & when ever user click on an action button ( i want to call this excel sheet on a button click); he/she is able to access this template. And as per user requirements, they can edit/modify the data in the sheets & save them to notes.

how can i do this. i know how 2 create excel sheets in LN. ( ex:- using the

Set xlobject = CreateObject(“Excel.Application”)

Set NewBook = xlobj.Workbooks.Add

& adding sheet into it using:-

Set xlSheet = xlobj.Sheets(“Sheet1”) )

can anyone please guide me how to put this default data on the sheet & use it as a template. i want user to edit the sheet & save its new copy.

thanks in advance,

Ray

2

Subject: Creating Excel sheet as a template

This script is what you need.

Set xlApp = CreateObject ( “Excel.Application” )

Set xlBook = xlApp.Workbooks.Open ( “C:\Your Directory\Your File.xls” )

Set xlsheet = xlBook.Worksheets ( “Worksheetname” )

string$ = xlSheet.Cells ( row# , col# ).Value

xlApp.Workbooks( 1 ).Close

xlApp.Quit

3

Subject: RE: Creating Excel sheet as a template

Well, i am not clear with this suggestion. can you just explain me about it?

Does that mean that the .xsl file needs to be saved in users’s C: drive or any drive whose path is given?

If so, can be please explain me its fesibility? since different user will access this Database from different GEO locations & its not possible to trace them & save the same xsl sheet template into everyone’s system?

please help!