How to get styles from an Excel XLSX spreadsheet or worksheet in Java

Here’s a quick lesson in how to get style information out of an Excel file in Java in just a few minutes using Java.

To get the ball rolling, we need to dynamically compile our libary with Jitpack. This, in turn, requires two references to be added into pom.XML.

Repository

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

Dependency

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

OK, now we are ready to call our editDocumentXlsxGetStyles function:

// 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();
GetXlsxStylesRequest input = new GetXlsxStylesRequest(); // GetXlsxStylesRequest | Document input request
try {
GetXlsxStylesResponse result = apiInstance.editDocumentXlsxGetStyles(input);
System.out.println(result);
} catch (ApiException e) {
System.err.println("Exception when calling EditDocumentApi#editDocumentXlsxGetStyles");
e.printStackTrace();
}

Simple enough. Here’s how our output will be formatted:

{
  "Successful": true,
  "CellStyles": [
    {
      "Path": "string",
      "Name": "string",
      "FormatID": 0,
      "BuiltInID": 0
    }
  ]
}