Excel-erator converts database files into spreadsheets in Microsoft's Excel format. Excel-erator supports both Physical files and Logical files with a single record format.
There are two commands that provide the conversion:
- Copy To Excel (CPYTOEXCEL)
- Send File Excel (SNDFEXCEL)
The Copy To Excel (CPYTOEXCEL) command takes a database file and an Integrated File System object (PC file) name as input. The file's contents are converted into a spreadsheet in Microsoft's Excel format. The converted file is then placed in the requested Integrated File System object (PC file).
By specifying the correct Integrated File System name you can place the generated file in any file system known to i5/OS including writing directly to Windows systems on the network, another System i, Novell NetWare or NFS servers.
The Send File Excel (SNDFEXCEL) command takes a database file and an email address as input. The file's contents are converted into a spreadsheet in Microsoft's Excel format. The converted file is then emailed to the requested recipient using i5/OS's built-in mail support. i5/OS delivers the mail in the manner appropriate to the recipient's mail client. The spreadsheet arrives as a MIME attachment to an email message.
When sending the email, you have a wide variety of options to tailor the delivered message to your specific needs. Addressing includes multiple recipients, copy recipients and blind copy recipients. Additionally, you can include multiple Reply-To: addresses as well as specify the email address the message appears to come from. Delivery confirmation by read receipt can also be specified.
Commands to help you trouble shoot and, optionally, automatically configure i5/OS to send mail are also included with the product.
Click here for more Info ....