0845 130 8499
x
x

SheetSmart

Automate and Elevate Your IBM i Reporting with SheetSmart

Are you still spending hours managing Excel-style reports?

If you use Microsoft Excel or similar files to analyse your business data, you’ll know how time-consuming it can be. Compiling, downloading, and formatting spreadsheets, or setting up complex formulas such as pivot tables, Vlookups, and conditional formatting, can take up hours every week.

In fact, a 2022 survey revealed that while business users spend an average of 20 hours per month working with spreadsheets, around 70% are not proficient in Excel. That means valuable time and productivity are being lost to repetitive manual tasks.


Introducing SheetSmart from IMS

Now, there’s a faster, smarter way to generate Excel-based reports directly from your IBM i.

Developed by the IMS team, SheetSmart lets you receive ready-formatted Excel reports within seconds — straight from your IBM i — without the need for any third-party software. It’s designed to be compatible with a wide range of IBM i OS versions, making it an ideal solution for both modern and heritage systems.

Watch the video overview

 

Save Hours of Work Every Week

With SheetSmart, you can automatically generate Excel spreadsheets that include advanced features such as:

  • Data validation
  • Conditional formatting
  • Logical functions


The solution supports over 250 Excel-based formulae and functions!

Use almost any data on your IBM i, and create polished, professional reports, formatted exactly to your requirements, which can be automatically emailed to multiple recipients.

The Sheetsmart development is an extension of Scott Klement’s open source RPGLE code for interfacing with POI Java software, originally developed circa 2007.

We’ve added more than 4500 lines of open source code, almost doubling the number of lines, compared to Scott’s original RPGLE source. This has enabled us to create more complex spreadsheets programmatically.

Simple, Transparent Pricing

Forget recurring license fees.
With SheetSmart, you only pay for:

  • The initial setup time, and
  • The time required for our developers to build each report to your specification.

Once created, your reports can be automatically emailed to one or multiple recipients at preset times or regular intervals.

Why Choose SheetSmart?

  • Save time and eliminate manual spreadsheet tasks
  • Increase productivity and efficiency
  • Utilise almost any data on your IBM i
  • No ongoing licensing costs
  • Works with older IBM i OS versions*
  • Supports over 250 Excel-based functions
  • Fully customisable reports

Endless Possibilities

SheetSmart can generate a professional Excel spreadsheet from virtually any data on your IBM i, giving you flexible, reliable reporting without the headaches of manual formatting or external tools.

*Available features may vary depending on your IBM i OS version


Contact Us today to arrange your free demo.