!Plz Help Want to put documents in worksheet of an Excel file

HCL Domino Domino Forum
1

Hi,

I have to write an agent by which a weekly status report should be generated. report should contain a collection of documents whom status is OPEN. but problem is i have to put that document in an Excel file This Excel file may contain 4 worksheet as i have four collection of documents each collection of docs in a sperate sheet.

I have’t any idia that how we can make more then one worksheet in Excel file and how to put documents one by one inside that worksheet.In lotus notes help we have’t any exmple??/ “Code for R5 Web client”

Please advice me for the same or plz suggest me some sample code.

Thanx in advance

Regards

Mudit

2

Subject: !!!Plz Help Want to put documents in worksheet of an Excel file

Mudit, there are lot of topics on Excel export in Notes 4 and 5 forum. I think you can even find it here in this forum.

Just go through them. It will be a big code to write it here for you.

Search for “Lotus Export” in forum.

–Phani

3

Subject: !!!Plz Help Want to put documents in worksheet of an Excel file

If you want to know how to add new sheets to an Excel workbook, then I would suggest that you consult the documentation for the Excel OLE class.

4

Subject: !!!Plz Help Want to put documents in worksheet of an Excel file

This is what i use.Worksheets.Add ,.Worksheets(.Worksheets.Count), , -4167

This adds a worksheet to the end (Sheet4)You can use this multiple times to add multiple sheets

hth

John