[rdnzl-devel] Re: Rdnzl Excel/Access

[Edi Weitz]

[Please use the mailing list.]

Hi,

On Thu, 11 Jan 2007 14:14:22 -0800 (PST), Jacobite <jacobite1607 at yahoo.com> wrote:

> I noticed your posted on Corman Lisp forum and I had a question that
> you might be able to answer. I have been trying to learn .net
> programming in Corman Lisp, playing with your example of reading
> from an Microsoft Excel file. I happened to notice that Excel stayed
> open in the background. My questions are:
>
> 1- How do you close Excel cleanly? 
> 2- Also how do I write to the excel file and save it?
> 3- How do you switch which Sheet tabs you are on?
> 4- Can you point me in the direction of example program, such as the
> Excel example on your webpage, that shows reading/writing to
> Microsoft Access.
>
> By the way your examples have worked beautifully. Any help you could
> provide would be greatly appreciated.

I'm afraid I can't be very helpful here as all your question are more
related to Office automation than to RDNZL itself.  I just adapted an
existing C# example (see link from RDNZL website) and that's what you
should probably do as well if you're looking for more.  There's most
likely /lots/ of C# code out there which does what you want.

If you've found something and if you have problems adapting the C#
code to Lisp, ask on the mailing list and I'll try to help.

Cheers,
Edi.