Search Results for "gui sql database"

...Quadratic is a Web-based spreadsheet application that runs in the browser and as a native app (via Electron). Our goal is to build a spreadsheet that enables you to pull your data from its source (SaaS, Database, CSV, API, etc) and then work with that data using the most popular data science tools today (Python, Pandas, SQL, JS, Excel Formulas, etc). Quadratic has no environment to configure. The grid runs entirely in the browser with no backend service. This makes our grids completely portable and very easy to share. Quadratic has Python library support built-in. ...

Free alternative for Office productivity tools: Apache OpenOffice - formerly known as OpenOffice.org - is an open-source office productivity software suite containing word processor, spreadsheet, presentation, graphics, formula editor, and database management applications. OpenOffice is available in many languages, works on all common computers, stores data in ODF - the international open standard format - and is able to read and write files in other formats, included the format used by the...

XLS/Loader is a user-friendly, Java™-based GUI tool that quickly and easily transfers a Microsoft Excel worksheet — provided it is structured as simple table — into your RDBMS (supports Oracle™, MariaDB/MySQL™, and PostgreSQL). Requires at least Java™ 11.

Large Excel file combiner including multiple sheets support xls and xlsx. 1. File Selection: Users can browse and select multiple Excel files to be combined, making it easy to work with multiple data sources. 2. License Expiry Check: The application checks the license expiry date, ensuring that users are informed if their license has expired before performing any operations. 3. Data Combining: Users can combine data from multiple Excel files into a single dataset. This...

https://sourceforge.net/projects/in2sql Video for best usage https://rb.gy/tvl8lk This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data. *Creates table base on data from a relational database *Generate a pivot report using the same external connection (1) *Some ad-hoc tools are available - like "keep only" and "remove only" *you can use the row limit option for exploring the largest dataset *The ODBC connection manager is available *auto-build query tool can create SQL select statement by using different database tables with matching them by column name * creating connections for PowerQuery news and updates -- change list -- v05 beta export tables and SQL to CSV files treat CSV like relational tables -- add Cloud ClickHouse Source resolve the problem with an untrusted source changed Sql Editor fixed behavior for "update rows"

GelSheet is a free and open source web spreadsheet that allow users to create, edit and export in many formats your everyday work. It's intended to run either standalone or integrated within another web tool. It was born as a part of Opengoo web office

The Oracle ExcelDocumentType project provides an open source Oracle PL/SQL user defined type and utilities designed to generate fully functional Microsoft Excel spreadsheets from within the database. The code generates Excel XML data.

Templates for integrating the data structures of Compiere, Openbravo or ADempiere for all kind of Pentaho Data Integration processes. Later on we plan to migrate these to Talend too.

A tool to query arrays in memory using SQL. It groups the arrays in tables and returns arrays as result set. It can be used in spreadsheets, as a script language library and everywhere is needed an interactive tool to query data in memory.

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.

QExcel Converter SQL QT4, Import xml excel/openoffice 2003 format, sqlite3 sql text/binary, edit table and export to various Format, Pdf XSL format objects Apache fop JAVA(XSL-FO), XML/XSLT , excel, SQL text sqlite3 dump file and MYSQL SQL to XML/XSL.

Read data from Excel 97+ spread sheets without Microsoft! Provides an API to write applications that read Excel documents. The xlreader tool converts data to tab delimited, CSV or SQL inserts. Written in C. Based on the the Java version by Andrew Khan.