Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

Formula Foundry is an advanced add-on for Google Sheets and Microsoft Excel that enables users to edit spreadsheet formulas more effectively. It features a multiline editor that supports syntax highlighting, auto-indentation, error detection, multiple tabs, and a dark mode, creating a code-editor-like environment next to the spreadsheet interface. Additionally, users can create global variables to streamline repetitive constants and maintain a library of formula snippets for easy access. The Business plan allows for collaborative sharing of these snippets among team members. An integrated AI assistant is also available to help users generate formulas using natural language, clarify existing formulas, and troubleshoot errors. Furthermore, a formula translator facilitates the conversion of syntax between Excel and Google Sheets while identifying functions that may not be compatible. Tailored for professionals who frequently work with intricate formulas—such as those in data analysis, finance, operations, and marketing—Formula Foundry is accessible for both Google Sheets and Microsoft Excel. It provides a free plan alongside various paid options to cater to both individual users and teams, ensuring a flexible solution for diverse needs. Its comprehensive features make it an invaluable tool for streamlining spreadsheet work.

Description

The xlrd library is designed for developers looking to extract data from .xls files, which are a type of Microsoft Excel spreadsheet. This tool specifically focuses on reading data and the formatting details contained within these older Excel file formats. It's important to note that xlrd is limited to handling only .xls files moving forward. The library does not process features such as charts, macros, images, or any other embedded elements, including additional worksheets, VBA modules, or formulas, though it can retrieve the results of formula evaluations, comments, hyperlinks, and various filters such as auto, advanced, and pivot tables, as well as conditional formatting and data validation. Unfortunately, password-protected files cannot be accessed or read with this library. When using xlrd from the command line, users can view the first, second, and last rows of each sheet contained within the specified files. Additionally, it's worth mentioning that xlrd is distributed under the BSD license, providing certain freedoms for developers to utilize and modify the library as needed.

API Access

Has API No 

API Access

Has API No 

Screenshots View All

No images available

Screenshots View All

Integrations

Microsoft Excel Yes 
Google Sheets Yes 
Python No 

Integrations

Microsoft Excel Yes 
Google Sheets No 
Python Yes 

Pricing Details

$15
Pro is $15 per user/month, billed annually. A free plan and paid individual and team plans are offered; the Business plan includes shared team snippets.
Free Trial No 
Free Version Yes 

Pricing Details

Free
Free Trial No 
Free Version Yes 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows No 
Mac No 
Linux No 
Chromebook No 

Deployment

Web-Based No 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac Yes 
Linux Yes 
Chromebook No 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support No 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs No 
Webinars No 
Live Training (Online) No 
In Person No 

Types of Training

Training Docs Yes 
Webinars Yes 
Live Training (Online) No 
In Person No 

Vendor Details

Company Name

Xerx

Founded

2022

Country

Austria

Website

www.formulafoundry.io

Vendor Details

Company Name

Python Software Foundation

Country

United States

Website

pypi.org/project/xlrd/

Product Features

Spreadsheet

Analytics No 
Audit Trail No 
Calculators No 
Charting No 
Multi-User Collaboration No 
Templates No 

Product Features

Alternatives

Alternatives

warcat Reviews

warcat

Python Software Foundation