Export Table to Excel

HCL Domino Domino Forum
1

I want to export a table taht is inside a mail to Excel. I’m a little lost.

I’d like to create a button that does this process automatically. I’ve been researching and through Designer I can create an agent to appear in Actions in Lotus Notes. I don’t know if this is a good idea.

I get to call and open Excel from Actions.

Set objdoc = CreateObject(“Excel.Application”)
objdoc.Visible = True
Set objword = objdoc.Documents.Add()

I also get to copy whatever is in the clipboard.

For me, ideally, the user selects the table and then click Actions button and automatically it copied to the clipboard, opened excel and pasted.

Someone can help me with this?

Dim cursor As Variant
Set cursor = objdoc.Selection
objdoc.Selection.Paste

2

Subject: Y’may need a couple of agents to handle it.

@Commands include some commands through the UI, that is, when editing with a Notes form.

The level of control an @Command can perform is lower, e.g., selecting a table that’s the entire content of the form.

If you want to get to the point of parsing all this data, well, there are some capabilities available, but they’re not that easy to use. You’d probably have to track down each cell and push it over to Excel. To investigate that, there’s NotesRichTextRange class.

For more capability, a third party, GeniiSoft, developed Midas.