Search Results for "excel 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. ...

Useful Excel sheet for Stock Option Traders. This Excel sheet can fetch the Live NSE Option Chain Data for Stocks. Fetch the live Stock Option Chain data such as Open Interest and Price at differentStrike prices, specifically few Strike Price ranges near to ATM in Excel sheet. It can be used to compare and analyze Open Interest and Price Changes at different Strike Prices. This Excel sheet collects the following data at a given Strike Price, for both Calls (CE) and Puts (PE)...

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"

A multiplatform C++ library for dynamic generation of Excel .xls files containing multiple worksheets. Unlike .csv files, these can be directly opened by Excel and thus provide an excellent way to output large data sets that require further analysis. To see the latest changes, select "Files" and view the README text displayed at the bottom of that pane. IMPORTANT: Major changes are contained in the current SVN source. If you have time please try to use it or the...

FIX Agora is a peer-to-peer OTC trading network for financial institutions with an integrated order management system. The application can act as buy side and sell side. FIX Agora supports indicative quoting, multi inquiries and processing of order requests. It is equipped with multiuser spreadsheets for price calculations as market maker. FIX Agora ships with the option for exporting trade reports into Excel® sheets and SAP® Financial Supply Chain Management (requires SAP® JCO). The...

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

Sheetster is a web-based spreadsheet editor and viewer. It can import and export the XLS and XLSX file formats and nearly the full range of Excel formula functions are supported. Most basic features are implemented as well as some of the more advanced ones. The user interface is written entirely in JavaScript and its server-side API is pure Java based on the OpenXLS spreadsheet engine. Neither the client nor the server needs Excel or any browser plugins. Sheetster is primarily intended...

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.

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.

Generating Excel 97+ files with Python 2.4+ (need decorators), importing Excel 95+ files, support for UNICODE in Excel files, using variety of formatting features and printing options, Excel files and OLE2 compound files dumper. No need in Windows/COM

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.

This open source library allows you to display System.Data.DataTable objects in Excel with titles, totals and number formating. It uses Reflection and late-binding, and is therefore compatible with multiple versions of Excel.

XB-exby-eXcelBuilder is a web app to select/format data into tabular or crosstab format, then download to a *.xls file. It is meant to be a lightweight bridge between raw data and a spreadsheet, with simple options for selection/layout of data.

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.

Framework for development of MS Excel add-ins that allow user defined functions that return more than a single value (e.g. to return table data with a single function call)

PythonOffice is a Python API for the Ms XML (Excel) Spreadsheet format. It allows you to read and write Excel XML documents from within the Python programming language. In future, support for other formats is planned, including OOo, Ms Open Xml.

convert XML to Excel file tool. Use XSLT and Xpath in XLS file, convert xml file to XLS file. You can defined format in XLS file, and write xslt in XLS file.

GenerateXLS is an ASP script that generates a comma delimited (CSV) file (that you can then open in Excel or some similar spreadsheet software) from a database.

pyXLWriter is a Python library for generating Excel compatible spreadsheets. It's a port of John McNamara's Perl Spreadsheet::WriteExcel 1.0 module (see http://www.cpan.org) to Python. Requires Python 2.1+. [Project was stopped]