ariadne logo

Creating Excel files on your system i

If you need help with any of the techniques described below, feel free to contact our support team.

Excel logoWhy create Excel files on your system i?

Why create an Excel file? Because that's the format in which your users and customers want their data, especially if the data involves a lot of numbers and they would like to do further calculations on it.

Why create the files on your system i? Because that's usually where the data is and because creating them there makes everybody's life easier.

In the past, creating an Excel spreadsheet from system i data normally meant having to run a file transfer on a PC. Sometimes that was fine, but often there were problems:

CoolSpools lets you create Excel spreadsheets from your system i data right on the system i itself.

No PC is required to create the files, so you can integrate their creation with your overnight batch jobs and there's no need to rely on your users to run file transfers at the right time.

Of course, once you've created the files on the system i, your users can access them from a PC. That's easy, and there are several choices for how to do it (more...).

With CoolSpools the process of creating Excel files from your system i data can be made:

There are two types of system i data you can choose to convert to Excel format:

CoolSpools Spool Converter Logo

Spooled files (printer output)

CoolSpools Database Logo

Database files (physical, logical and DDM files)

The Excel files that are produced are fully functional, native Excel-format files and compatible with Excel 97 and later.

You have a choice of Excel 97-2003 format (.xls) or Excel 2007 (.xlsx) format.

Both of these product options let you enhance the appearance of your Excel output using styles to apply color, fonts, backgrounds, patterns, borders etc.

You can even apply conditional formatting to do things like coloring high values red and low values green!

Twitter Facebook Linkedin Youtube

© Ariadne Software Ltd. 2016

Search |

Sitemap |

Terms and Privacy

Life Enterprise Technology Group IBM business partner logo