Search Results for "excel data mapping"

...The advantages by using CSV as input and output are the following: - Many applications allow an export of its data to CSV or Excel(were it could be saved to CSV) - It is possible to pre- and postprocess the data, e.g removing version numbers before comparing - It is easy to create CSV data from logfiles and other resources by using unix tools like sed or awk - CSV can be loaded into other applications, especially Excel, were it can be formatted by macros for analyzing.

...This SourceForge page will remain, but with limited functionality (please go to GitHub to report issues and for project downloads). It is highly configurable, and supports reading and writing with POJOs, Maps and Lists. It also has support for deep-mapping and index-based mapping with POJOs, using the powerful Dozer extension. Its flexible 'Cell Processor' API automates data type conversions (parsing and formatting Dates, Integers, Booleans etc) and enforces constraints (mandatory columns, matching against regular expressions etc) - and it's easy to write your own if required. ...

Row-Bean is a CSV-Bean JAVA API . Row-Bean provides CSV reader an writer. More ever provides a mechanism to map csv file content to java beans and revers. For each use, a XML description must describe the wished mapping. Another possibility consists in use Annotations. Use under maven : <!-- row bean with annotations...

Simple Java delimited and fixed width file parser. Handles CSV, Excel CSV, Tab, Pipe delimiters, just to name a few. Maps column positions in the file to user friendly names via XML. See "FlatPack Feature List" under News for complete feature list.

OSM XML to CSV conversion. POI only, polygons (and polylines, but not recommended) are approximated by centroid. Result is a 3-column table with lon, lat and value (for a particular key to be chosen beforehand).

dbUPLoader is a tool to import data from csv or MS-Excel files into a database. You can distribute data across several tables, create relationships between imported data and integrate sub queries to reference existing data.

Java library that easily converts a Json array to Excel or CSV

The Time Series Toolbox is a set of software components that simplify the task of building applications that record, process, store and publish time series of observations. Current main application area are sensor networks.