Excel Formula Wizard API

curl --location --request GET 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100' --header 'Authorization: Bearer YOUR_API_KEY' 


    

import okhttp3.OkHttpClient;
import okhttp3.Request;
import okhttp3.Response;
import java.io.IOException;

public class Main {
    public static void main(String[] args) {
        OkHttpClient client = new OkHttpClient();

        // Build the GET request
        Request request = new Request.Builder()
            .url("https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100")
            .get() // Use GET method without a body
            .addHeader("Authorization", "Bearer YOUR_API_KEY")
            .build();

        // Execute the request
        try (Response response = client.newCall(request).execute()) {
            if (response.isSuccessful()) {
                // Handle the response in case of a successful request
                String responseData = response.body().string();
                System.out.println(responseData);
            } else {
                // Handle errors
                System.out.println("Request error: " + response.code());
            }
        } catch (IOException e) {
            // Handle I/O exceptions
            e.printStackTrace();
        }
    }
}

var settings = {
  "url": "https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100",
  "method": "GET",
  "timeout": 0,
  "headers": {
    "Authorization": "Bearer YOUR_API_KEY"
  },
};

$.ajax(settings).done(function (response) {
  console.log(response);
});

var xhr = new XMLHttpRequest();
xhr.withCredentials = true;
    
xhr.addEventListener("readystatechange", function() {
if(this.readyState === 4) {
    console.log(this.responseText);
    }
});
    
xhr.open("GET", "https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100");
xhr.setRequestHeader("Authorization", "Bearer YOUR_API_KEY");

var axios = require('axios');
var config = {
method: 'GET',
url: 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100',
headers: { 
    'Authorization': 'Bearer YOUR_API_KEY'
    },
};
axios(config).then(function (response) {
console.log(JSON.stringify(response.data));
})
.catch(function (error) {
console.log(error);
});

$curl = curl_init();
    
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'GET',
CURLOPT_HTTPHEADER => array(
    'Authorization: Bearer YOUR_API_KEY'
    ),
));
    
$response = curl_exec($curl);
    
curl_close($curl);
echo $response;

import requests
    
url = "https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100"
    
headers = {
    'Authorization': 'Bearer YOUR_API_KEY'
}
    
response = requests.request("GET", url, headers=headers, data=payload)
    
print(response.text)
    

require "uri"
require "net/http"
    
url = URI("https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100")
    
http = Net::HTTP.new(url.host, url.port);
request = Net::HTTP::GET.new(url)
request["Authorization"] = "Bearer YOUR_API_KEY"
    
response = http.request(request)
puts response.read_body

http --follow --timeout 3600 GET 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100' \
Authorization:'Bearer YOUR_API_KEY'

var client = new RestClient("https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100");
client.Timeout = -1;
var request = new RestRequest(Method.GET);
request.AddHeader("Authorization", "Bearer YOUR_API_KEY");
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);

package main
import (
    "fmt"
    "net/http"
    "io/ioutil"
)
func main() {
    url := "https://zylalabs.com/api/4746/excel+formula+wizard+api/5864/generator?user_content=Sum from A1:A10 if B1:B10 is apple and C1:C10 is less than 100"
    method := "GET"
    client := &http.Client {
    }
    req, err := http.NewRequest(method, url, nil)
    if err != nil {
    fmt.Println(err)
    return
    }
    req.Header.Add("Authorization", "Bearer YOUR_API_KEY")
    res, err := client.Do(req)
    if err != nil {
    fmt.Println(err)
    return
    }
    defer res.Body.Close()

    body, err := ioutil.ReadAll(res.Body)
    if err != nil {
    fmt.Println(err)
    return
    }
    fmt.Println(string(body))
}

curl --location --request GET 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"' --header 'Authorization: Bearer YOUR_API_KEY' 


    

import okhttp3.OkHttpClient;
import okhttp3.Request;
import okhttp3.Response;
import java.io.IOException;

public class Main {
    public static void main(String[] args) {
        OkHttpClient client = new OkHttpClient();

        // Build the GET request
        Request request = new Request.Builder()
            .url("https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"")
            .get() // Use GET method without a body
            .addHeader("Authorization", "Bearer YOUR_API_KEY")
            .build();

        // Execute the request
        try (Response response = client.newCall(request).execute()) {
            if (response.isSuccessful()) {
                // Handle the response in case of a successful request
                String responseData = response.body().string();
                System.out.println(responseData);
            } else {
                // Handle errors
                System.out.println("Request error: " + response.code());
            }
        } catch (IOException e) {
            // Handle I/O exceptions
            e.printStackTrace();
        }
    }
}

var settings = {
  "url": "https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"",
  "method": "GET",
  "timeout": 0,
  "headers": {
    "Authorization": "Bearer YOUR_API_KEY"
  },
};

$.ajax(settings).done(function (response) {
  console.log(response);
});

var xhr = new XMLHttpRequest();
xhr.withCredentials = true;
    
xhr.addEventListener("readystatechange", function() {
if(this.readyState === 4) {
    console.log(this.responseText);
    }
});
    
xhr.open("GET", "https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"");
xhr.setRequestHeader("Authorization", "Bearer YOUR_API_KEY");

var axios = require('axios');
var config = {
method: 'GET',
url: 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"',
headers: { 
    'Authorization': 'Bearer YOUR_API_KEY'
    },
};
axios(config).then(function (response) {
console.log(JSON.stringify(response.data));
})
.catch(function (error) {
console.log(error);
});

$curl = curl_init();
    
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'GET',
CURLOPT_HTTPHEADER => array(
    'Authorization: Bearer YOUR_API_KEY'
    ),
));
    
$response = curl_exec($curl);
    
curl_close($curl);
echo $response;

import requests
    
url = "https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")""
    
headers = {
    'Authorization': 'Bearer YOUR_API_KEY'
}
    
response = requests.request("GET", url, headers=headers, data=payload)
    
print(response.text)
    

require "uri"
require "net/http"
    
url = URI("https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"")
    
http = Net::HTTP.new(url.host, url.port);
request = Net::HTTP::GET.new(url)
request["Authorization"] = "Bearer YOUR_API_KEY"
    
response = http.request(request)
puts response.read_body

http --follow --timeout 3600 GET 'https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"' \
Authorization:'Bearer YOUR_API_KEY'

var client = new RestClient("https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")"");
client.Timeout = -1;
var request = new RestRequest(Method.GET);
request.AddHeader("Authorization", "Bearer YOUR_API_KEY");
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);

package main
import (
    "fmt"
    "net/http"
    "io/ioutil"
)
func main() {
    url := "https://zylalabs.com/api/4746/excel+formula+wizard+api/5865/explanation?user_content="=SUMIFS(A1:A10, B1:B10, \"apple\", C1:C10, \"<100\")""
    method := "GET"
    client := &http.Client {
    }
    req, err := http.NewRequest(method, url, nil)
    if err != nil {
    fmt.Println(err)
    return
    }
    req.Header.Add("Authorization", "Bearer YOUR_API_KEY")
    res, err := client.Do(req)
    if err != nil {
    fmt.Println(err)
    return
    }
    defer res.Body.Close()

    body, err := ioutil.ReadAll(res.Body)
    if err != nil {
    fmt.Println(err)
    return
    }
    fmt.Println(string(body))
}