Export notes view to MS excel. How to insert row and delete row?

HCL Domino Domino Forum
1

Hi,I am programming to export notes view to MS excel.

Anybody know how to insert a row and delete a row.

when exporting notes view to Lotus 123, we have some working codes like this, but it is not working for exporting to MS excel.

…

Set range = sheet.ranges(“A:J5”)

range.insertrows(“$Full”)

…

range.deleterows(“$Full”)

I found the code on “range” should be changed to:

sheet.range(“A” & i ) = “address1”

But , I can not figure out how to change the insertrows and deleterow.

Appreciate for any help,

thanks

2

Subject: RE: Export notes view to MS excel. How to insert row and delete row?

You’re really asking an Excel question, not a Notes question. If you don’t get a useful answer here you might try the Excel forums (or reading some of MS documentation).

I’ve always found it helpful, when trying to figure out how to OLE-automate operations in Office, to record a macro where I do whatever it is manually, then look at the generated source code.

3

Subject: RE: Export notes view to MS excel. How to insert row and delete row?

Hi Andre,Actually, it is about how to Insert or Delete a row from excel using Lotus Script code.

Basically, we now have Lotus Scrips code on a button of notes view, when use click it , the entire notes view will be exported to Lotus123 spreadsheet, it works fine. However, since Lotus will not suport Lotus 123 any more, so we have to convert it to export to MS Excel.

The lotus script codes I posted for Insert a row and Delete a row works on Louts 123, but I need the equevalent codes for Excel.

It should be simple, but I just can not figure out after tried many options. It seems Lotus123 and Excel is big difference, Not similar.

I will try some documentation from internet.

Thanks a lot,

4

Subject: RE: Export notes view to MS excel. How to insert row and delete row?

Please read what I wrote before. Doing this from LotusScript is pretty much like doing it from VB. Your problem is knowing what calls to make to the OLE automation interface – and they are the same calls no matter what program you call them from. And you can find out which calls to make by recording a macro as you do the operation in Excel, or by reading the MS documentation.

5

Subject: RE: Export notes view to MS excel. How to insert row and delete row?

Thanks a lot, Andre,After read some documentation on line, I got the answer.

Appreciate your help,