Search Results for "jexcel api java"

A read-only JDBC driver for Java that uses Comma Separated Value (CSV) files as database tables. Ideal for writing data import programs and conversion programs.

jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate,...

...It is packaged as an auto executable Jar for convenient command line execution but might as well be interfaced directly by a Java class as part of a broader [yet non commercial] software. It handles attributes, repeated elements, and so on, and produces results which level up with what spreadsheets generate when they import native XML (at least in its most extensive execution mode). Please refer to the documentation for further details (PDF doc, Open Office Writer doc, and API doc). ...

...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. Super CSV is actively maintained, and the developers are ready and willing to help out if you get stuck :) Please check out the project website for examples and help getting started

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.

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 --> <dependencies> <dependency> <groupId>net.sf.csv-bean</groupId> <artifactId>row-bean-annotations</artifactId> <version>1.1.0</version> </dependency> </dependencies> <!...

"Database to CSV" allows to back-up data from database(Oracle, MySQL, SQL Server) in the form of CSV files. Each table data is stored in a separate CSV file. It also allows to load data from CSV files into the database. Program can be run from UI or from command line. There's one more advanced feature which allows merging of data from CSV file to Database. It is only available from command line. (It will take foreign keys and unique keys into consideration and then try to insert...

Java library for reading and writing of flat files. CSV, FLR (fixed length record) or mixed structures. Tree-style processing API. Adapters for SAX, Stax and XStream for transformation, data binding or serialization.

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.

Easy to use ready to go CSV File Reading utility. Read One or Multiple files into a RecordManager, quick access to the file with segmentation into Fields and Records. Merge Multiple CSV files in one. Listener to CSV Files.