The Excel Formulas API is a powerful tool for developers who need to automate Excel calculations, integrate Excel functionality into other applications and systems, and perform complex calculations on large data sets. The API allows you to run Excel formulas by providing the formula as a parameter and returning the result. This eliminates the need to manually perform calculations in Excel, saving time and reducing the risk of errors.
The API supports a wide range of Excel functions, including mathematical, statistical, financial, and text functions, making it a versatile tool for a variety of calculations. The API is also designed to handle large data sets, making it ideal for use in data analysis and business intelligence applications.
The Excel Formulas API is easy to use and requires only the formula and input parameters to be passed as a parameter. The API returns the result in JSON format, which makes it easy to integrate into a wide variety of applications and systems.
With its powerful capabilities and easy-to-use interface, the Excel Formulas API is an essential tool for any developer working with Excel calculations, data analysis, and business intelligence. It can be used in various industries such as finance, accounting, and more.
Pass an excel formula in JSON, and receive the result of that formula.
Automating Excel calculations: The Excel Formulas API can be used to automate Excel calculations, reducing the need to manually perform calculations in Excel and saving time.
Data analysis: The API can be used to perform complex calculations on large data sets, making it ideal for use in data analysis and business intelligence applications.
Financial analysis: The API can be used to perform financial calculations, such as amortization, depreciation, and more, which is widely used in the financial industry.
Integration with other systems: The API can be used to integrate Excel functionality into other applications and systems, allowing for the automation of calculations in those systems.
Statistical analysis: The API can be used to perform statistical calculations, such as correlation, regression, and more, which is widely used in research and scientific studies.
Business Intelligence: The API can be used to perform complex calculations on large data sets, making it ideal for use in business intelligence applications, such as forecasting, budgeting and more.
Besides API call limitations per month, there are no other limitations.
Runs a computation of the provided Excel Formula, through formula parameter, and returns the result.
Don't add =
before your formulas. Use english function names. Use .
as decimal separator, ,
as function argument separator. Incapsulate strings using ""
, like "text"
. Use { }
to incapsulate arrays, like {1,2,3}
.
Run - Endpoint Features
Object | Description |
---|---|
Request Body |
[Required] Json |
{"result":"44895"}
curl --location --request POST 'https://zylalabs.com/api/956/excel+formulas+api/781/run' --header 'Authorization: Bearer YOUR_API_KEY'
--data-raw '{
"formula": "EOMONTH(DATE(2022,09,14),2)"
}'
Header | Description |
---|---|
Authorization
|
[Required] Should be Bearer access_key . See "Your API Access Key" above when you are subscribed. |
No long-term commitment. Upgrade, downgrade, or cancel anytime. Free Trial includes up to 50 requests.
The Excel Formulas API returns the result of the computed Excel formula in JSON format. The response includes a key named "result" that contains the calculated value based on the provided formula.
The Run endpoint accepts a single parameter: the formula to be computed. Users must provide the formula without an equal sign, using English function names, and appropriate syntax for strings and arrays.
The response data is structured in JSON format, containing a single key "result" that holds the computed value. For example, a response might look like: `{"result":"44895"}`.
Common use cases include automating Excel calculations, performing financial analyses, conducting statistical evaluations, and integrating Excel functionalities into other applications for data analysis.
Users can customize their requests by altering the formula parameter to include different Excel functions and input values. This allows for a wide range of calculations tailored to specific needs.
The primary field in the response is "result," which represents the outcome of the executed formula. Users can interpret this value based on the context of the formula used.
The API relies on Excel's built-in calculation engine, ensuring high accuracy for the computations. Users should ensure that the formulas are correctly formatted to avoid errors in results.
Results typically return numerical values, but can also include text strings or error messages if the formula is invalid. Users should handle different data types based on the expected output of their formulas.
Zyla API Hub is like a big store for APIs, where you can find thousands of them all in one place. We also offer dedicated support and real-time monitoring of all APIs. Once you sign up, you can pick and choose which APIs you want to use. Just remember, each API needs its own subscription. But if you subscribe to multiple ones, you'll use the same key for all of them, making things easier for you.
Prices are listed in USD (United States Dollar), EUR (Euro), CAD (Canadian Dollar), AUD (Australian Dollar), and GBP (British Pound). We accept all major debit and credit cards. Our payment system uses the latest security technology and is powered by Stripe, one of the worldβs most reliable payment companies. If you have any trouble paying by card, just contact us at [email protected]
Additionally, if you already have an active subscription in any of these currencies (USD, EUR, CAD, AUD, GBP), that currency will remain for subsequent subscriptions. You can change the currency at any time as long as you don't have any active subscriptions.
The local currency shown on the pricing page is based on the country of your IP address and is provided for reference only. The actual prices are in USD (United States Dollar). When you make a payment, the charge will appear on your card statement in USD, even if you see the equivalent amount in your local currency on our website. This means you cannot pay directly with your local currency.
Occasionally, a bank may decline the charge due to its fraud protection settings. We suggest reaching out to your bank initially to check if they are blocking our charges. Also, you can access the Billing Portal and change the card associated to make the payment. If these does not work and you need further assistance, please contact our team at [email protected]
Prices are determined by a recurring monthly or yearly subscription, depending on the chosen plan.
API calls are deducted from your plan based on successful requests. Each plan comes with a specific number of calls that you can make per month. Only successful calls, indicated by a Status 200 response, will be counted against your total. This ensures that failed or incomplete requests do not impact your monthly quota.
Zyla API Hub works on a recurring monthly subscription system. Your billing cycle will start the day you purchase one of the paid plans, and it will renew the same day of the next month. So be aware to cancel your subscription beforehand if you want to avoid future charges.
To upgrade your current subscription plan, simply go to the pricing page of the API and select the plan you want to upgrade to. The upgrade will be instant, allowing you to immediately enjoy the features of the new plan. Please note that any remaining calls from your previous plan will not be carried over to the new plan, so be aware of this when upgrading. You will be charged the full amount of the new plan.
To check how many API calls you have left for the current month, refer to the βX-Zyla-API-Calls-Monthly-Remainingβ field in the response header. For example, if your plan allows 1,000 requests per month and you've used 100, this field in the response header will indicate 900 remaining calls.
To see the maximum number of API requests your plan allows, check the βX-Zyla-RateLimit-Limitβ response header. For instance, if your plan includes 1,000 requests per month, this header will display 1,000.
The βX-Zyla-RateLimit-Resetβ header shows the number of seconds until your rate limit resets. This tells you when your request count will start fresh. For example, if it displays 3,600, it means 3,600 seconds are left until the limit resets.
Yes, you can cancel your plan anytime by going to your account and selecting the cancellation option on the Billing page. Please note that upgrades, downgrades, and cancellations take effect immediately. Additionally, upon cancellation, you will no longer have access to the service, even if you have remaining calls left in your quota.
You can contact us through our chat channel to receive immediate assistance. We are always online from 8 am to 5 pm (EST). If you reach us after that time, we will get back to you as soon as possible. Additionally, you can contact us via email at [email protected]
To give you the opportunity to experience our APIs without any commitment, we offer a 7-day free trial that allows you to make up to 50 API calls at no cost. This trial can be used only once, so we recommend applying it to the API that interests you the most. While most of our APIs offer a free trial, some may not. The trial concludes after 7 days or once you've made 50 requests, whichever occurs first. If you reach the 50 request limit during the trial, you will need to "Start Your Paid Plan" to continue making requests. You can find the "Start Your Paid Plan" button in your profile under Subscription -> Choose the API you are subscribed to -> Pricing tab. Alternatively, if you don't cancel your subscription before the 7th day, your free trial will end, and your plan will automatically be billed, granting you access to all the API calls specified in your plan. Please keep this in mind to avoid unwanted charges.
After 7 days, you will be charged the full amount for the plan you were subscribed to during the trial. Therefore, itβs important to cancel before the trial period ends. Refund requests for forgetting to cancel on time are not accepted.
When you subscribe to an API free trial, you can make up to 50 API calls. If you wish to make additional API calls beyond this limit, the API will prompt you to perform an "Start Your Paid Plan." You can find the "Start Your Paid Plan" button in your profile under Subscription -> Choose the API you are subscribed to -> Pricing tab.
Payout Orders are processed between the 20th and the 30th of each month. If you submit your request before the 20th, your payment will be processed within this timeframe.
Service Level:
100%
Response Time:
4,855ms
Service Level:
67%
Response Time:
1,077ms
Service Level:
100%
Response Time:
215ms
Service Level:
100%
Response Time:
3,963ms
Service Level:
100%
Response Time:
2,441ms
Service Level:
100%
Response Time:
2,692ms
Service Level:
100%
Response Time:
1,113ms
Service Level:
100%
Response Time:
723ms
Service Level:
100%
Response Time:
657ms
Service Level:
100%
Response Time:
360ms
Service Level:
100%
Response Time:
327ms
Service Level:
100%
Response Time:
2,054ms
Service Level:
100%
Response Time:
1,162ms
Service Level:
100%
Response Time:
1,757ms
Service Level:
100%
Response Time:
410ms
Service Level:
100%
Response Time:
1,334ms
Service Level:
100%
Response Time:
377ms
Service Level:
100%
Response Time:
126ms
Service Level:
100%
Response Time:
1,938ms
Service Level:
100%
Response Time:
1,092ms