How to get worksheets from an Excel XLSX spreadsheet in Java

If you have ever tried to parse an Excel spreadsheet yourself, you probably know how complicated they really are. Simply obtaining worksheet names from an XLSX file can be quite challenging, as you have to dive through multiple layers of formatting limbo to find your desired information. To make things much simpler, today’s tutorial will use an API to get this done for you in a fraction of the time.

We begin with a reference to jitpack in our respositories.

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

Then our dependency reference for the Cloudmersive API client.

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

And finally, our function call, which looks like this here:

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

Done.