How to insert a CELL (not a row) inside Excel via Lotus script?

HCL Domino Domino Forum
1

I’m exporting documents from Notes to excel using LotusScript code. After the export is done and the Excel file is saved, I need to do some massaging of the data inside the Excel. For this I need to know, how can I insert or delete a single Excell cell inside the column. I couldn’t find this command.

Please, give me a hint, how this command looks or where I can look for it.

Thanks!

2

Subject: How to insert a CELL (not a row) inside Excel via Lotus script?

The way to find out, and this applies to anything in excel, is to record a macro in excel to do what you need, then check the code.

So, inserting a cell and shifting the cells to the right in VBA is:

Selection.Insert Shift:=xlToRight

You need to look up the value of xlToRight in the object browser in the VBA editor, then change the syntax slightly. It becomes something like:

xlapp.selection.insert(-4161)

Not tested at all - try it and see what happens

3

Subject: RE: How to insert a CELL (not a row) inside Excel via Lotus script?

Thank you very much for you answer!