Is it possible in Notes to grab an Excel attachment from an e-mail and convert/export it to a text file, programatically? I’d like to create a mailbox that will only receive these types of e-mails and run an agent on each one to grab, convert, and FTP to another server using LEI.
Subject: Programatically convert Excel file to CSV
Not sure about the FTP/LEI thing but in concept you should be able to do the XL → csv conversion. Since this will be some kind of server initiated process, you’ll need Excel installed on the server so it can access the OLE/COM methods. There are tons of sample code for how to read and write XL files posted here (check the faq of faqs and the OLE/COM faq as well as the sandbox, searching, and openntf.org).
Do you need the CSV file? Where is it going and what is LEI doing with it? Maybe there’s something more direct you could do.
Doug
Subject: RE: Programatically convert Excel file to CSV
Thanks for the heads up on the sample code, I’ll go look for it. I don’t need to store the CSV in my db as long as it ends up on the remote server. The LEI process will just be to grab the file from my db and put it on another server that will serve as a repository. The CSVs that end up on that server will be part of an Infogix automated process.