Mountain View, CA (PressExposure) February 28, 2011 -- TikiReports, the trusted reporting solution, today announced the release of version 1.1, adding support to merge multiple Excel files to generate reports.
Today's business use Excel for a variety of purposes, from sales receipts to purchase orders to ledgers, etc. But all this data is contained in different files making it difficult to generate reports/obtain useful information. The data from all these files must first be merged. There are existing enterprise solutions, but these are usually expensive, need dedicated hardware and are high on maintenance.
TikiReports-Excel is extremely flexible. Merge disparate data from multiple Excel spreadsheets into a single table:
Combine/Merge full columns/tables on a spreadsheet from multiple Excel files to a single table.
Combine/Merge individual cells on a spreadsheet to a single table from multiple Excel files.
Combine/Merge ranges(tables) on spreadsheet from multiple Excel files.
Mix individual cells and ranges OR individual cells and columns to merge/combine them to a single table from multiple Excel files.
The resulting data (Report) can be exported back to Excel for further reporting with pivot tables/charts/etc.
TikiReports-Excel is super easy to use. The software has only two simple wizard steps:
Step 1: Select the Excel files to combine/merge
Step 2: Select the data in the Excel file to combine/merge. Sample contents of the Excel file are shown for easy selection.
In two simple steps the report is ready. The resulting data (Report) can be exported back to Excel for further reporting with pivot tables/charts/etc.
TikiReports-Excel is easy to install/maintain. No database needed, no expensive hardware, this is a simple tool for Windows. It is provided with an installer and uninstaller.
In conclusion, TikiReports-Excel provides an easy, flexible and affordable solution for combining numerous Excel files and generating insightful reports. Reports that can be exported back to Excel for further reporting with pivot tables/charts/etc.
The trial version is available from http://www.tikireports.com/excel/. Also note the current special introduction price!!