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

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.

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.

PHP Library for read Excel files

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.

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.

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

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

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.

Excel_Out is a standalone, portable Ada package for writing Excel spreadsheets with basic formattings, 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

DOCX, XLSX and PPTX files are collections of conventionally zipped mostly XML sub-files. This program first attempts repair any zip based corruption. From there it engages in four different algorithmic attempts at repair or recovery. With the first method using validation, the location of the first XML error is sought. At that point the sub-files are truncated and repaired. The second method works the same way except the XML validation is more lax. With the third, the strict XML validation is returned to and corrupt XML sub-files are truncated and repaired as before however, missing XML sub-files are brought in from blank full healthy docx, xlsx or pptx of the respective correct extension. The fourth method uses SilverCoder's DocToText to salvage text or data after which the file is opened as an old style MS Office 97 - 2003 format file including the naked recovered text or data. See my other projects here on Sourceforge for other ways to recover corrupt MS and Open Office files.

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

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

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.

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

XLW is a C++ wrapper for the Excel C API described in the Microsoft Excel 97 Developer's Kit. It makes xll programming automatic. Its powerful interface will empower your C, C# or C++ numerics by embedding them in Excel just like the built-in functions.

Simple Spreadsheet is a free electronic spreadsheet program, without the bloated feature set of commercial products. See our Facebook page for support.

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

Microsoft recommends several methods for recovering Excel data from corrupt spreadsheets. S2 Recovery Tools for Microsoft Excel makes it easy to follow these recommended routines by just pressing buttons. The application also adds five methods of its own for recovery. Additionally it has its own native previous file version recovery tool which works in any version of Vista, Windows 7 and Windows 8. Another feature of the program is a preloaded search interface for finding temporary, deleted and lost versions of your corrupt file. For completeness sake the program has shortcuts to 2 major commercial solution providers for corrupt Excel files including providing the coupon "S2SERVICES" for using Recoveronix' online corrupt file recovery service for free until Nov 1, 2014, a $39 value. This program was formerly known as Excel Recovery and more recently, S2 Services Excel Recovery.

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

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.

Excel Regex Find and Replace The "Excel Regex Find and Replace" is an add-in designed to enhance Excel's native Find and Replace functionality by incorporating regular expressions. With this add-in, users gain the ability to search and replace specific patterns of text using regular expressions, rather than simple literal matches. Regular expressions enable a wide range of advanced search criteria, including wildcards, character classes, quantifiers, and grouping, among others.