Open Source Spreadsheet Software - Page 4

Update: It is probably wise to try to do a zip repair step on corrupt xlsx files as a first step before trying to invoke other methods. Microsoft recommends several methods for recovering from Excel corruption. This Excel add-in brings into one toolbar these methods while adding four data recovery methods of its own. For MS methods for recovering from Excel file corruption, see: http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx or here: http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx. Requires at least Excel 2003 and Windows XP.

This project adds a ribbon to excel with a number of statistical buttons. This is not intended to be a full statistical analysis package (like R), but only a source for quick visualizations and calculations. For Excel2007 and up

Java tool that takes a source and a compare file as input and then generates following files if any differences are encountered: -Source file with differences marked and -Compare file with differences marked -Difference dump file containg all locations of differences, src value, compare value

Do you have a haystack (legacy) of Excel files that reference each other and you can't see clear anymore? This tools crawls Excel files and builds up a visual graph. It shows which files might be outdated because they reference a file which was modified more recently. The graph is dynamic, you can choose between different layout algorithms and rearrange by hand. Allows you to quickly open the file, dump the graph, dump all links within a file, highlight all the cells that reference other excel files. This tool was intended for internal use but made available here on SF. Time for support is limited

An Excel that creates a powerpoint presentation of nicely formatted slides from the rows in a spreadsheet. Create your own ttemplates to include any fields from the spreadsheet customize your layout. More info on Tiran: http://tirandagan.com

The project is used to design Excel and HTML report. The new idea it brings to us is that we can develop reports with VBA macros, just as the importance of css to html. And we and change the report without compile the projects...

A C#/.Net library for creating powerful reports in Excel from an Excel template. The template can modified by the costumer (just basic Excel skills are needed) so each costumer can influence the design of his reports (e.g. bills).

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.

Expr4J aims to provide a general purpose expression parser, which is also compatible with Microsoft Excel. It will provide an implementation of the built in functions in MS Excel as well as a calculation engine.

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 application is client/server based, modular and extensible. FIX Agora is working with the Financial Information eXchange ("FIX") protocol. The FIX protocol is an industry driven standard for the electronic communication of trade related messages, released and maintained by FIX Protocol, Ltd. FIX Agora is a 100% Java open source implementation running on Windows, Linux/UNIX and Mac OS (client only). It requires Oracle® JRE version of 1.6 or higher.

Desarrollo de un sencillo programa para facturación electrónica de acuerdo a la legislación mexicana

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.

This is a finances manager that can help you control your finances.

Fireworkz combines the features of Wordz (a word processor that you can use to write letters, reports, books, invitations, shopping lists, schedules and other documents) and Resultz (a spreadsheet that you can use to perform calculations, analyse figures, and produce colourful charts) enabling you to do even more; incorporate live results in your reports, or perform an automatic mail-merge to your friends or customers. If you are using Microsoft® Windows®, Linux or macOS, and don't know what RISC OS is, you may be better off using LibreOffice!

Fiscal Calendar in Excel generates an elegant calendar based on the year you type into cell J1, with July 1 being the first day of the fiscal year. The fiscal month begins on the last Monday of the previous month with a full work week (5 days). For example, the Monday ten days before Thanksgiving will be the first week of fiscal month December (November 13 in 2017). Fiscal Calendar in Excel allows you highlight certain business days each month and it'll highlight holidays every year. If you don't like the automated dates, manually set them on the second sheet.

FlexiSheet is a multi-dimensional spreadsheet in the spirit of Lotus Improv. FlexiSheet runs on MacOS X.

Calendar for freelancers. You keep customers , incomes , outcomes , tasks also. Of course your secretary or parthners or anyone who has internet access and the password can use it too. Visit now WWW.VALID.GR for DEMO....

The application can be used for administrating all costs around your vehicle, you're able to add your tankfill and several special payments as insurance and motor vehicle tax. It will able to generate different statistics and reports.

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.

This Perl utility script will allow you to quick strip the split or utility file and display transaction month and year information. It is intended simply to save time when uploading using that export in any spreadsheet tool to perform analysis.

gspread is a Python API for Google Sheets. A service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs [sic]. Since it’s a separate account, by default it does not have access to any spreadsheet until you share it with this account. Just like any other Google account. To access spreadsheets via Google Sheets API you need to authenticate and authorize your application. Older versions of gspread have used oauth2client. Google has deprecated it in favor of google-auth. If you’re still using oauth2client credentials, the library will convert these to google-auth for you, but you can change your code to use the new credentials to make sure nothing breaks in the future. If you familiar with the Jupyter Notebook, Google Colaboratory is probably the easiest way to get started using gspread.

HSSFTemplates is a Servlet based template processor built around the Jakarta POI project. It has been moved to the Carbon Five Open Source project where its been renamed SST.

The software reads XML files with equity stock order details and submits them to the TWS API from Interactive Brokers for execution. The software also visualizes all order status, error messages, and connection status. Also useful for order latency monit

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.