Search Results for "excel database"

csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. ...

P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with...

ETL Framework is a standalone Extract Transform Load engine written in Java. It includes executables for all major platforms and can be easily integrated into other applications. Key Features: * embeddable, open source and free * fast and scalable * uses target database features to do transformations and loads * manual and automatic data mapping * data streaming * bulk data loads * data quality features using SQL, JavaScript? and regex * data transformations Requirements *...

Build a tool with nice GUI as well as powerful options to automate building SQL DDL and import statements from an Excel Sheet / Workbook.

Java CSV is a small fast open source Java library for reading and writing CSV and plain delimited text files. All kinds of CSV files can be handled, text qualified, Excel formatted, etc.

Shared Questionnaire System(SQS) is a full-functional Optical Mark Reader(OMR) form processing system implemented in Java-Swing, XSL-FO and AJAX with straightforward GUIs. It is aimed at developing social platform to share knowledge about questionnaire.

This project allows PHP programmers to export data into Excel workbook. You can create multiple sheets, use fonts, colors and borders. Exported data is in XML format, recognized by Microsoft Office Excel

A PHP webapp to upload taxonomic checklists as Excel or CSV files to be served as TDWG TCS XML/RDF. It can handle multiple checklists, has a Tapir light webservice and a taxonomic tree of species names created from taxonomy in a checklist can be browsed.

pyXLReader is a multiplatform Python library for reading Excel compatible spreadsheets (.xls). Based on JExcelApi by Andy Khan (http://www.andykhan.com).

JRower is a tool for loading database tables from flat files. You supply a XML file describing the fields in the file and their mapping to the database table columns. The data file can be a text file in CSV, delimited, fixed length, or Excel format.