Sheetloom is an Excel plugin for the Pentaho User Console (PUC) that makes spreadsheets visible in the repository. When a user clicks on the spreadsheet in the repository Sheetloom extracts all the named ranges (and sheet names) and looks them up in Pentaho Community Data Access framework. When a match is found, Sheetloom runs the CDA data access query and moves the data into a copy of the Excel template. Once all named ranges are exhausted Sheetloom returns the spreadsheet to the user. All authentication and authorisation is handled by the PUC.

Sheetloom architecture