Average Ratings 0 Ratings
Average Ratings 0 Ratings
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
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