Open Source Windows Spreadsheet Software

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 most common office suite packages. OpenOffice is also able to export files in PDF format. OpenOffice has supported extensions, in a similar manner to Mozilla Firefox, making easy to add new functionality to an existing OpenOffice installation.

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

PhpSpreadsheet is a library written in pure PHP and offers a set of classes that allow you to read and write various spreadsheet file formats such as Excel and LibreOffice Calc. PhpSpreadsheet is a library written in pure PHP and offers a set of classes that allow you to read and write various spreadsheet file formats such as Excel and LibreOffice Calc. Support for PHP versions will only be maintained for a period of six months beyond the end of life of that PHP version. Use composer to install PhpSpreadsheet into your project. Or also download the documentation and samples if you plan to use them. A good way to get started is to run some of the samples. Don't forget to download them via --prefer-source composer flag. And then serve them via PHP built-in webserver. PhpSpreadsheet relies on Composer autoloader. So before working with PhpSpreadsheet in standalone, be sure to run composer install.

JExcelApi is a java library which provides the ability to read, write, and modify Microsoft Excel spreadsheets. This project mirrors the files on http://www.jexcelapi.org, which has been known to go down on occasion.

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.

PHP Library for read Excel files

XonGrid is a free Excel library of functions to perform 1D, 2D, 3D, 4D and arbitrary dimension (ND) interpolations from scattered data.

EtherCalc is an open source, web-based spreadsheet that allows multiple users to collaborate and work remotely and in real time. Users can edit the same spreadsheet at the same time, with changes instantly reflected on screen. It accepts various mathematical formulae and other functions, and supports several default text formatting directives as well. It can be used for just about anything you’d need a desktop spreadsheet for-- accounting, inventory, scheduling, list management and so much more. EtherCalc is the improved successor to SocialCalc, optimized for simultaneous editing. It’s a great open source alternative to Google sheets, without pesky logins or editing locks.

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.

Excel_Out is a standalone, portable Ada package for writing Excel spreadsheets with basic formattings and formulas, easily and programmatically. Enables the automatic production of reports. No interaction needed with Excel or MS Office. More information on: http://excel-writer.sf.net Alire crate: https://alire.ada.dev/crates/excel_writer

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

VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility that can handle millions of rows with ease. A terminal interface for exploring and arranging tabular data. VisiData supports tsv, CSV, SQLite, JSON, xlsx (Excel), hdf5, and many other formats. Requires Linux, OS/X, or Windows (with WSL). Hundreds of other commands and options are also available; see the documentation. Code in the stable branch of this repository, including the main vd application, loaders, and plugins, is available for use and redistribution under GPLv3. VisiData is a free, open-source tool that lets you quickly open, explore, summarize, and analyze datasets in your computer’s terminal. VisiData works with CSV files, Excel spreadsheets, SQL databases, and many other data sources.

A set of User Defined Functions for Excel to create in-cell charts : Sparklines. Sparklines are the simple, intense, word-sized graphics invented by Edward Tufte. Coded in Visual Basic for Applications.

An editor for plaintext tables, consisting of columns separated by arbitrary characters and rows separated by newlines, i.e. tsv, csv and related formats. Licensed under MIT License Copyright (c) 2019 japanoise Source code: https://github.com/japanoise/csved Visit: http://albanese.atwebpages.com

This library represents XLSX files writer for Microsoft Excel 2007 and above. The main feature of this library is that it uses C++ standard file streams. On the one hand it results in almost unnoticeable memory and CPU resources consumption while processing (that may be very useful at saving a large data arrays), but on the other hand it makes unfeasible to edit data that were written. Hence, if using this library the structure of the future report should be known enough. The library is written in C++ with using STL functionality and based on the ZIP library (included), which has a free license: http://www.codeproject.com/Articles/7530/Zip-Utils-clean-elegant-simple-C-Win32 This library is distributed under the terms of the zlib license: http://www.zlib.net/zlib_license.html

Matrex is a lightweight vectorial spreadsheet: calculates blocks of values, not single cells; it is strongly multithreaded; users can work together on sheets using a server. Adapters to matlab, scilab, octave, R.

Perform automatic operations between excel files.

Get the Live NIFTY Index Option Chain Data in Excel Sheet for CE & PE. Gives the snapshot of the NIFTY option chain with change in price, OI and volume. NIFTY Trend can analyzed from this Excel based on Change in Open Interest, Price and Volume. Useful for NIFTY option chain traders. Fetch the various data such as Last Traded Price (LTP), Open Interest (OI), Change in Open Interest (%), Change in Price (%), Total Volume Traded, Buy Volume, Sell Volume, Implied Volatility (IV), etc., for both Calls and Puts. A simplified Excel sheet for traders of NIFTY Index, coded in VBA, to fetch the real-time NSE NIFTY option chain price data with different expiry dates and at a few strike prices from the underlying price. Analyze in-depth for the changes in Open Interest (OI), Changes in Price as well as the Buy, Sell Volumes, Total Volumes Traded etc., at different strike prices especially few strike prices with at the money (ATM).

The alternative fast realization of built-in spreadsheet of 1S:Enterprise system (v7.7). Features: improved user interface, correct support of large documents, fast and correct bi-directional Excel converter, multifunctional report builder.

Quite simply, SlickGrid is a JavaScript grid/spreadsheet component. It is an advanced component and is going to be a bit more difficult to learn and configure, but once you realize its full potential, it will blow your mind! SlickGrid utilizes virtual rendering to enable you to easily work with hundreds of thousands of items without any drop in performance. In fact, there is no difference in performance between working with a grid with 10 rows versus a 100’000 rows. This is achieved through virtual rendering where only what’s visible on the screen plus a small buffer is rendered. As the user scrolls, DOM nodes are continuously being created and removed. These operations are highly tuned to provide optimal performance under all browsers. The grid also adapts to the direction and speed of scroll to minimize the number of rows that need to be swapped out and to dynamically switch between synchronous and asynchronous rendering.

This Microsoft Project add-in includes over 20 features for MS Project 2013 and 2016. You'll be able to see the full chain of predecessor tasks based on the current task, audit your schedule based on industry best practices, see all tasks coming up in the next "x" weeks. This add-in also gives you the power to export a report of your entire project into Microsoft Excel with dates, dates and time, filters, and to see a "Who Does What When" table.

A spreadsheet program that registers fixed assets details (including location) & calculates depreciation. Fixed Assets Pro (Excel) is both powerful & yet easy to use. See the list of extensive features below for further details. The program is a VBA project.

This spreadsheet program makes it easy to prepare bank reconciliations and is also a resource for learning how to do a bank reconciliation. See the list of features below for further details.

Excel workbook that calculates return on investment (ROI) for estimated costs and benefits of automating software testing.

An Excel addin and server framework for implementing remote excel user-defined functions (UDFs). This framework is designed to provide a centralised warehouse of functions for Excel users (eg. within an organisation).