InterExcel400 for IBM i (AS400 / iSeries) converts IBM i reports into Excel format for further processing of data.InterExcel400 enables professional reports to be shared withnon IBM i users.
InterExcel400 improves Corporate Communication and Branding!
InterExcel400 for IBM i is an easy-to-use application that can convert an IBM i report into a MS Excel format (.xls), and place it directly on your desktop. The functionality of InterExcel400 enables you to create professional looking reports and charts that you can share with others e.g. in the conference room or as an attachement to an e-mail.
- Formatting templates for individual spool files from IBM i
- User friendly handling via WRKOUTQ kind of command
- Automatic conversion via Program Calls
- Conversion to .txt and .rtf format
- Integration with InterForm400
Formatting templates for individual spool file conversion
InterExcel400 enables creation of templates, used for conversion of specific IBM i spool files, into formatted Excel files. These templates include settings of how and where data is placed in the Excel spreadsheet, including cell font and border definition. The settings also enable deletion of blank lines and multiple headers on every page for easy handling in MS Excel.
User friendly handling via a command, similar to WRKOUTQ
InterExcel400 enables easy selection of the IBM i spool files to be converted via a command, similar to WRKOUTQ. From this easy menu structure the user can select which target format to be used for the IBM i spool conversion.
Automatic conversion via Program Calls
InterExcel400 features the possiblity of calling the InterExcel400 conversion program from own menu structures or programs for batch conversion. InterExcel400 enables dynamic naming of the saved InterExcel400 files, giving freedom in batch conversion of IBM i reports.
Using Excel "import text Wizard"
InterExcel400 features opening Excel with a text file, which will make it possible to use the MS Excel "Import Text Wizard". This gives the user complete independence which spool file to process.
Conversion to .txt and .rtf format
InterExcel400 enables spool conversion to .txt format and therefore also calling off the associated PC program like Notepad, Works or Word. When converting to .rtf format, MS Word will be called and the respective page breaks are respected, as opposed to using .txt
Integration with InterForm400
InterExcel400 enables InterForm400 users to expand the number of output formats for the distribution of documents. The InterForm400’s e-mail distribution feature will facilitate easy distribution of Excel reports via e-mail.