Open Source Spreadsheet Software

Technical analysis library with indicators like ADX, MACD, RSI, Stochastic and TRIX, plus candlestick pattern recognition. Docs: https://ta-lib.org Available natively in C/C++, Java, Rust and C# with wrappers for python, R and many other ecosystems. MOVED TO GITHUB: https://github.com/TA-Lib/ta-lib . No further support is provided on SourceForge. Release 0.4.0 is very outdated, please check github for the most recent release.

NocoDB is an open source #NoCode platform that turns any database into a smart spreadsheet. It is free & self-hostable. Let your imagination be thy limit. Create unlimited grid view, gallery view, form view from your own data. Search, sort, filter columns and rows with ultra ease. Collaborate just like spreadsheets. Invite your team with fine-grained Access Control. Share views publicly and also with password protection. Build automation with you favorite apps: Microsoft Teams Slack, Discord, Whatsapp, Twilio, Email & SMS.

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.

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) and at different Expiry Dates. > Open Interest (OI) > Change in Open Interest (in %), > Last Traded Price for NSE Stock option (in INR) > Change in Last Traded Price (%) It narrows down and fetches few selective Strike Price ranges only at Out of Money (OTM) near to ATM (At the Money) and not fetches from deep far Out of Money Strike Price data. So, it gives a simplified view on OI and Price changes. Homepage : https://www.enote.page/2022/08/stock-option-chain.html

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 xlslib-package-2.4.0b1.zip archive, and enter bug reports on any problems! Changes: - library specific strings now in their own namespace - iOS Objective-C library - most project files updated (MSVS etc) - C bridge now supports formulas Note: there is a related SF project, libxls, to read Excel files.

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.

The PalOOCa Project offers a fast, flexible and intuitive Office-based Business Intelligence solution based on Jedox. It provides an extension for OpenOffice.org Calc which allows both, read and write, access to data from within the Jedox OLAP Server via Calc. If used together with the Open Source Jedox/Palo OLAP Server it completes the Open Source MOLAP-Stack for Business Intelligence. Additionally to Jedox OLAP it is also (read-only) compatible to (almost) all OLAP servers supporting XMLA. Intended audiences are: - scientific research & teaching - financial analysis & controlling Consult the FAQ in the Wiki.

Web-based spreadsheet-like application written in PHP and uses dynamic and interactive user's interface written in JavaScript with jQuery library. Data based on XML.

A Simple contact management system, aka browser based rolodex. Includes mass mailing of html mime messages to contact lists, export to csv, Fulltext boolean searches, etc. Requires: PHP >= 4.3.1 (with register_globals OFF) & MySQL >= 4.0.1

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

ErgoTabcalc is a general calculation and report system. Calculation sequences are stored in the database. These sequences are made from simple operations on data, eg, add two table columns, or sort a table. This is similar to relational algebra.

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.

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"

The FastForward framework allows fast development of 3-tier spreadsheet applications. The spreadsheet is used as a browser, which can send and receive data. The project implements a spreadsheet add-on and data manipulation library for the web server.

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.

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.

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.

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.

Append hundreds of different XML files into one large data document, validate, and attach a stylesheet. Stitcher is a porwerful summary reporting tool. Allows for complex file storage locations of xml data. UBL, HR-ML, LandXML ... visit stitcher.org.

Text::FixedWidth is a Perl module that provides a simple object-oriented interface to parse and manipulate fixed column-width text files. The module currently exposes three public methods: new, print_all, and select_distinct.

Cycling Training Diary, Trainingstagebuch, Agenda d'Entraînement, Diario de entrenamiento, Diario di allenamento :: cycling, run, sport, diary, journal, log, blog, template based, simply store your training data, polar, hrm, upload, html, perl, mysql

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.

transform a csv-flie. This means that the rows would by convert to columns and columns to rows.