How to create a new Excel XLSX spreadsheet from column and row data in Java

Cloudmersive

Feb 13, 2020·1 min read

Today’s problem is the creation of a new Excel file using row and column data. We shall solve this quickly with the help of an API.

Let’s get the ball rolling by using Jitpack to dynamically compile our library using these two references in our Maven POM file.

Repositories

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

Dependencies

<dependencies>
<dependency>
    <groupId>com.github.Cloudmersive</groupId>
    <artifactId>Cloudmersive.APIClient.Java</artifactId>
    <version>v3.34</version>
</dependency>
</dependencies>

With our library ready, we are able to invoke editDocumentXlsxCreateSpreadsheetFromData:

// 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: ApikeyApiKeyAuth 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();CreateSpreadsheetFromDataRequest input = new CreateSpreadsheetFromDataRequest(); // CreateSpreadsheetFromDataRequest | Document input requesttry {CreateSpreadsheetFromDataResponse result = apiInstance.editDocumentXlsxCreateSpreadsheetFromData(input);System.out.println(result);} catch (ApiException e) {System.err.println("Exception when calling EditDocumentApi#editDocumentXlsxCreateSpreadsheetFromData");e.printStackTrace();}

And we can input our specifications like so:

{
  "WorksheetName": "string",
  "Rows": [
    {
      "Path": "string",
      "Cells": [
        {
          "Path": "string",
          "TextValue": "string",
          "CellIdentifier": "string",
          "StyleIndex": 0,
          "Formula": "string"
        }
      ]
    }
  ]
}

Done!