Search Results for "excel vba library"

GeoTools is an open source (LGPL) Java code library which provides standards compliant methods for the manipulation of geospatial data. GeoTools is an Open Source Geospatial Foundation project. The GeoTools library data structures are based on Open Geospatial Consortium (OGC) specifications.

DBConvert is a cross converter for HanDBase-, List-, JFile-, MobileDB-, PilotDB-, MariaDB-, MySQL-, PostgreSQL-, SQLite-, MS-Access-, SQL Server-, Firebird- , DBase- and Foxpro- databases, as well as MS-Excel and Calc spreadsheets, CSV- , JSON-, vCard-, hCard-, jCard-, xCard-, YAML- and XML files. Source files: https://github.com/TvBreukelen/fnpdbservices

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...

ORBADA is a database, SQL, query client using JDBC drivers. It is a tool to administrate and manage database structure. It Is for Oracle, SQLite, Firebird, HSQLDB, DerbyDB, MySQL, PostgreSQL and other databases.

DataCleaner is a data quality analysis application and a solution platform for DQ solutions. It's core is a strong data profiling engine, which is extensible and thereby adds data cleansing, transformations, enrichment, deduplication, matching and merging. Website: http://datacleaner.github.io

EXZELLENZ is a pure-Java program to manipulate table data in Oracle database through Microsoft Excel file (in xls and xlsx formats). Using Apache POI and JDBC API, this program can be used to download, insert, update, and delete data in database tables. It does not use any Office VBA, so you don't need to change the Excel security settings, and no need to worry the 32/64bit compatibility. Written in Pure-Java means that you can also run this program in Windows, *nix or Mac environment, as long...

Technical analysis library with indicators like ADX, MACD, RSI, Stochastic, TRIX... includes also candlestick pattern recognition. Useful for trading application developpers using either Excel, .NET, Mono, Java, Perl or C/C++.

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 *...

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.

Csvtosql is a library and tool to convert any CSV-based data. It accepts multiple data formats (such as CSV, Excel, or arrays), converts it into SQL statements, and writes the data back in multiple formats (textfile, database).

This program converts, compares, merges, normalizes, and refactors data to and from disparate sources (CSV, Excel, and any JDBC/ODBC database) for use in a Java program.

tinySQL is a SQL engine written in Java. It uses dBase format files compatible with MS Excel. tinySQL comes with a command line interpreter which you can use to create, drop, or update tables. A GUI for tinySQL can be found at www.sqlmagic.com