- Cloudmersive Documentation

Node.JS Python C# Java PHP Objective-C Ruby Apex C/C++ cURL Swift JavaScript Go

Run this command to install the SDK:

npm install cloudmersive-convert-api-client --save

Or add this snippet to your package.json:

  "dependencies": {
    "cloudmersive-convert-api-client": "^2.6.3"
  }

var CloudmersiveConvertApiClient = require('cloudmersive-convert-api-client');
var defaultClient = CloudmersiveConvertApiClient.ApiClient.instance;

// Configure API key authorization: Apikey
var Apikey = defaultClient.authentications['Apikey'];
Apikey.apiKey = 'YOUR API KEY';



var apiInstance = new CloudmersiveConvertApiClient.EditDocumentApi();

var input = new CloudmersiveConvertApiClient.AppendXlsxRowRequest(); // AppendXlsxRowRequest | Document input request


var callback = function(error, data, response) {
  if (error) {
    console.error(error);
  } else {
    console.log('API called successfully. Returned data: ' + data);
  }
};
apiInstance.editDocumentXlsxAppendRow(input, callback);

Run this command to install the SDK:

pip install cloudmersive-convert-api-client

from __future__ import print_function
import time
import cloudmersive_convert_api_client
from cloudmersive_convert_api_client.rest import ApiException
from pprint import pprint

# Configure API key authorization: Apikey
configuration = cloudmersive_convert_api_client.Configuration()
configuration.api_key['Apikey'] = 'YOUR_API_KEY'



# create an instance of the API class
api_instance = cloudmersive_convert_api_client.EditDocumentApi(cloudmersive_convert_api_client.ApiClient(configuration))
input = cloudmersive_convert_api_client.AppendXlsxRowRequest() # AppendXlsxRowRequest | Document input request

try:
    # Append row to a Excel XLSX spreadsheet, worksheet
    api_response = api_instance.edit_document_xlsx_append_row(input)
    pprint(api_response)
except ApiException as e:
    print("Exception when calling EditDocumentApi->edit_document_xlsx_append_row: %s\n" % e)

.NET Framework | .NET Core

Run this command to install the SDK:

Install-Package Cloudmersive.APIClient.NET.DocumentAndDataConvert -Version 3.4.2

using System;
using System.Diagnostics;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Api;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Client;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Model;

namespace Example
{
    public class EditDocumentXlsxAppendRowExample
    {
        public void main()
        {
            // Configure API key authorization: Apikey
            Configuration.Default.AddApiKey("Apikey", "YOUR_API_KEY");
            
            

            var apiInstance = new EditDocumentApi();
            var input = new AppendXlsxRowRequest(); // AppendXlsxRowRequest | Document input request

            try
            {
                // Append row to a Excel XLSX spreadsheet, worksheet
                AppendXlsxRowResponse result = apiInstance.EditDocumentXlsxAppendRow(input);
                Debug.WriteLine(result);
            }
            catch (Exception e)
            {
                Debug.Print("Exception when calling EditDocumentApi.EditDocumentXlsxAppendRow: " + e.Message );
            }
        }
    }
}

using System;
using System.Diagnostics;
using Cloudmersive.APIClient.NETCore.DocumentAndDataConvert.Api;
using Cloudmersive.APIClient.NETCore.DocumentAndDataConvert.Client;
using Cloudmersive.APIClient.NETCore.DocumentAndDataConvert.Model;

namespace Example
{
    public class EditDocumentXlsxAppendRowExample
    {
        public void main()
        {
            // Configure API key authorization: Apikey
            Configuration.Default.AddApiKey("Apikey", "YOUR_API_KEY");
            
            

            var apiInstance = new EditDocumentApi();
            var input = new AppendXlsxRowRequest(); // AppendXlsxRowRequest | Document input request

            try
            {
                // Append row to a Excel XLSX spreadsheet, worksheet
                AppendXlsxRowResponse result = apiInstance.EditDocumentXlsxAppendRow(input);
                Debug.WriteLine(result);
            }
            catch (Exception e)
            {
                Debug.Print("Exception when calling EditDocumentApi.EditDocumentXlsxAppendRow: " + e.Message );
            }
        }
    }
}

To install with Maven, add a reference to the repository in pom.xml:

<repositories>
    <repository>
        <id>jitpack.io</id>
        <url>https://jitpack.io</url>
    </repository>
</repositories>

And add a reference to the dependency in pom.xml:

<dependencies>
<dependency>
    <groupId>com.github.Cloudmersive</groupId>
    <artifactId>Cloudmersive.APIClient.Java</artifactId>
    <version>v4.25</version>
</dependency>
</dependencies>

To install with Gradle, add it in your root build.gradle at the end of repositories:

allprojects {
	repositories {
		...
		maven { url 'https://jitpack.io' }
	}
}

And add the dependency in build.gradle:

dependencies {
        implementation 'com.github.Cloudmersive:Cloudmersive.APIClient.Java:v4.25'
}

// Import classes:
//import com.cloudmersive.client.invoker.ApiClient;
//import com.cloudmersive.client.invoker.ApiException;
//import com.cloudmersive.client.invoker.Configuration;
//import com.cloudmersive.client.invoker.auth.*;
//import com.cloudmersive.client.EditDocumentApi;

ApiClient defaultClient = Configuration.getDefaultApiClient();

// Configure API key authorization: Apikey
ApiKeyAuth Apikey = (ApiKeyAuth) defaultClient.getAuthentication("Apikey");
Apikey.setApiKey("YOUR API KEY");
// Uncomment the following line to set a prefix for the API key, e.g. "Token" (defaults to null)
//Apikey.setApiKeyPrefix("Token");

EditDocumentApi apiInstance = new EditDocumentApi();
AppendXlsxRowRequest input = new AppendXlsxRowRequest(); // AppendXlsxRowRequest | Document input request
try {
    AppendXlsxRowResponse result = apiInstance.editDocumentXlsxAppendRow(input);
    System.out.println(result);
} catch (ApiException e) {
    System.err.println("Exception when calling EditDocumentApi#editDocumentXlsxAppendRow");
    e.printStackTrace();
}

Run this command to install the SDK:

composer require cloudmersive/cloudmersive_document_convert_api_client

<?php
require_once(__DIR__ . '/vendor/autoload.php');

// Configure API key authorization: Apikey
$config = Swagger\Client\Configuration::getDefaultConfiguration()->setApiKey('Apikey', 'YOUR_API_KEY');



$apiInstance = new Swagger\Client\Api\EditDocumentApi(
    
    
    new GuzzleHttp\Client(),
    $config
);
$input = new \Swagger\Client\Model\AppendXlsxRowRequest(); // \Swagger\Client\Model\AppendXlsxRowRequest | Document input request

try {
    $result = $apiInstance->editDocumentXlsxAppendRow($input);
    print_r($result);
} catch (Exception $e) {
    echo 'Exception when calling EditDocumentApi->editDocumentXlsxAppendRow: ', $e->getMessage(), PHP_EOL;
}
?>

Add the Objective-C client to your Podfile:

pod 'CloudmersiveDocumentAndDataConvertApiClient', '~> 1.0'

CMDefaultConfiguration *apiConfig = [CMDefaultConfiguration sharedConfig];

// Configure API key authorization: (authentication scheme: Apikey)
[apiConfig setApiKey:@"YOUR_API_KEY" forApiKeyIdentifier:@"Apikey"];




CMAppendXlsxRowRequest* input = [[CMAppendXlsxRowRequest alloc] init]; // Document input request

CMEditDocumentApi*apiInstance = [[CMEditDocumentApi alloc] init];

// Append row to a Excel XLSX spreadsheet, worksheet
[apiInstance editDocumentXlsxAppendRowWithInput:input
          completionHandler: ^(CMAppendXlsxRowResponse* output, NSError* error) {
                        if (output) {
                            NSLog(@"%@", output);
                        }
                        if (error) {
                            NSLog(@"Error calling CMEditDocumentApi->editDocumentXlsxAppendRow: %@", error);
                        }
                    }];

Add the Ruby client to your Gemfile:

gem 'cloudmersive-convert-api-client', '~> 2.1.6'

# load the gem
require 'cloudmersive-convert-api-client'
# setup authorization
CloudmersiveConvertApiClient.configure do |config|
  # Configure API key authorization: Apikey
  config.api_key['Apikey'] = 'YOUR API KEY'
  # Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)
  #config.api_key_prefix['Apikey'] = 'Bearer'
end

api_instance = CloudmersiveConvertApiClient::EditDocumentApi.new

input = CloudmersiveConvertApiClient::AppendXlsxRowRequest.new # AppendXlsxRowRequest | Document input request


begin
  #Append row to a Excel XLSX spreadsheet, worksheet
  result = api_instance.edit_document_xlsx_append_row(input)
  p result
rescue CloudmersiveConvertApiClient::ApiError => e
  puts "Exception when calling EditDocumentApi->edit_document_xlsx_append_row: #{e}"
end

Download and copy the /client folder into your Apex project:

Download Apex Client

SwagEditDocumentApi api = new SwagEditDocumentApi();
SwagClient client = api.getClient();

// Configure API key authorization: Apikey
ApiKeyAuth Apikey = (ApiKeyAuth) client.getAuthentication('Apikey');
Apikey.setApiKey('YOUR API KEY');

Map<String, Object> params = new Map<String, Object>{
    'input' => SwagAppendXlsxRowRequest.getExample()
};

try {
    // cross your fingers
    SwagAppendXlsxRowResponse result = api.editDocumentXlsxAppendRow(params);
    System.debug(result);
} catch (Swagger.ApiException e) {
    // ...handle your exceptions
}

Install libcurl in your C/C++ project:

libcurl/7.75.0

CURL *curl;
CURLcode res;
curl = curl_easy_init();
if(curl) {
     curl_easy_setopt(curl, CURLOPT_CUSTOMREQUEST, "POST");
     curl_easy_setopt(curl, CURLOPT_URL, "https://api.cloudmersive.com/convert/edit/xlsx/append-row");
     curl_easy_setopt(curl, CURLOPT_FOLLOWLOCATION, 1L);
     curl_easy_setopt(curl, CURLOPT_DEFAULT_PROTOCOL, "https");
     struct curl_slist *headers = NULL;
     headers = curl_slist_append(headers, "Content-Type: application/x-www-form-urlencoded");
     headers = curl_slist_append(headers, "Apikey: YOUR-API-KEY-HERE");
     curl_easy_setopt(curl, CURLOPT_HTTPHEADER, headers);
     const char *data = "InputFileBytes=%3Cbyte%3E&InputFileUrl=%3Cstring%3E&Path=nulla%20adipisicing%20do&WorksheetName=irure%20fugiat&Path=%3Cstring%3E&Cells=%5B%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%2C%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%5D";
     curl_easy_setopt(curl, CURLOPT_POSTFIELDS, data);
     res = curl_easy_perform(curl);
}
curl_easy_cleanup(curl);

curl --location --request POST 'https://api.cloudmersive.com/convert/edit/xlsx/append-row' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--header 'Apikey: YOUR-API-KEY-HERE' \
--data-urlencode 'InputFileBytes=<byte>' \
--data-urlencode 'InputFileUrl=<string>' \
--data-urlencode 'Path=sit in officia anim tempor' \
--data-urlencode 'WorksheetName=enim et voluptate in' \
--data-urlencode 'Path=<string>' \
--data-urlencode 'Cells=[{"Path":"<string>","TextValue":"<string>","CellIdentifier":"<string>","StyleIndex":"<integer>","Formula":"<string>"},{"Path":"<string>","TextValue":"<string>","CellIdentifier":"<string>","StyleIndex":"<integer>","Formula":"<string>"}]'

import Foundation
#if canImport(FoundationNetworking)
import FoundationNetworking
#endif

var semaphore = DispatchSemaphore (value: 0)

let parameters = "InputFileBytes=%3Cbyte%3E&InputFileUrl=%3Cstring%3E&Path=Ut%20deserunt%20laborum%20ex&WorksheetName=labore%20consectetur%20Lorem%20cupidatat&Path=%3Cstring%3E&Cells=%5B%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%2C%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%5D"
let postData =  parameters.data(using: .utf8)

var request = URLRequest(url: URL(string: "https://api.cloudmersive.com/convert/edit/xlsx/append-row")!,timeoutInterval: Double.infinity)
request.addValue("application/x-www-form-urlencoded", forHTTPHeaderField: "Content-Type")
request.addValue("YOUR-API-KEY-HERE", forHTTPHeaderField: "Apikey")

request.httpMethod = "POST"
request.httpBody = postData

let task = URLSession.shared.dataTask(with: request) { data, response, error in 
     guard let data = data else {
          print(String(describing: error))
          semaphore.signal()
          return
     }
     print(String(data: data, encoding: .utf8)!)
     semaphore.signal()
}

task.resume()
semaphore.wait()

XHR | jQuery

This code snippet uses the built-in JavaScript XHR request capability

var data = "InputFileBytes=%3Cbyte%3E&InputFileUrl=%3Cstring%3E&Path=quis%20ad%20proident%20Excepteur%20sed&WorksheetName=Duis%20aliquip%20exercitation&Path=%3Cstring%3E&Cells=%5B%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%2C%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%5D";

var xhr = new XMLHttpRequest();
xhr.withCredentials = true;

xhr.addEventListener("readystatechange", function() {
     if(this.readyState === 4) {
          console.log(this.responseText);
     }
});

xhr.open("POST", "https://api.cloudmersive.com/convert/edit/xlsx/append-row");
xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.setRequestHeader("Apikey", "YOUR-API-KEY-HERE");

xhr.send(data);

var settings = {
     "url": "https://api.cloudmersive.com/convert/edit/xlsx/append-row",
     "method": "POST",
     "timeout": 0,
     "headers": {
          "Content-Type": "application/x-www-form-urlencoded",
          "Apikey": "YOUR-API-KEY-HERE"
     },
     "data": {
          "InputFileBytes": "<byte>",
          "InputFileUrl": "<string>",
          "Path": "velit consectetur",
          "WorksheetName": "non mollit amet f",
          "Path": "<string>",
          "Cells": "[{\"Path\":\"<string>\",\"TextValue\":\"<string>\",\"CellIdentifier\":\"<string>\",\"StyleIndex\":\"<integer>\",\"Formula\":\"<string>\"},{\"Path\":\"<string>\",\"TextValue\":\"<string>\",\"CellIdentifier\":\"<string>\",\"StyleIndex\":\"<integer>\",\"Formula\":\"<string>\"}]"
     }
};

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

package main

import (
     "fmt"
     "strings"
     "net/http"
     "io/ioutil"
)

func main() {

     url := "https://api.cloudmersive.com/convert/edit/xlsx/append-row"
     method := "POST"

     payload := strings.NewReader("InputFileBytes=%3Cbyte%3E&InputFileUrl=%3Cstring%3E&Path=amet%20fugiat&WorksheetName=ad%20enim%20laboris%20ut%20cillum&Path=%3Cstring%3E&Cells=%5B%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%2C%7B%22Path%22%3A%22%3Cstring%3E%22%2C%22TextValue%22%3A%22%3Cstring%3E%22%2C%22CellIdentifier%22%3A%22%3Cstring%3E%22%2C%22StyleIndex%22%3A%22%3Cinteger%3E%22%2C%22Formula%22%3A%22%3Cstring%3E%22%7D%5D")

     client := &http.Client {
     }
     req, err := http.NewRequest(method, url, payload)

     if err != nil {
          fmt.Println(err)
          return
     }
     req.Header.Add("Content-Type", "application/x-www-form-urlencoded")
     req.Header.Add("Apikey", "YOUR-API-KEY-HERE")

     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))
}

Walkthrough Video