Follow this article to convert Excel table to CSV using Java REST API. You will learn to automatically transform an Excel table to CSV online using Java-based API with the help of a Java-based Cloud SDK. It will assist you in selecting a workbook, worksheet and respective table on that particular sheet.
Prerequisite
- Create an account and get API credentials for converting an Excel table to CSV
- Download Aspose.Cells Cloud SDK for Java to transform an Excel table to a CSV-formatted stream
- Set up a Java project with the above SDK
Steps to Convert Table to CSV using Java REST Interface
- Authenticate using your Client ID, Client Secret, and the Base URL
- Create an instance of the CellsApi class to work with Excel files
- Set the name of the Excel file you want to convert
- Create and configure an UploadFileRequest with file path and storage details
- Send the file to Aspose Cloud so it’s available for processing
- Set up a ConvertTableToCsvRequest by specifying the spreadsheet, worksheet, and table name
- Call the API method to convert the specified table into CSV format
- Write the converted CSV data to a local file named first_table.csv
These steps summarize the process of how to transform an Excel table to CSV using Java Low Code API. First, you sign in to Aspose Cloud with your credentials and get everything ready to work with Excel files. Then, you upload the Excel file you want to use so it’s available for processing. After that, you pick a specific table from the file, convert it to CSV, and save the result to your computer as file_name.csv.
Code to Export Excel Table to CSV using Java RESTful Service
The above code has demonstrated the process to export Excel table to CSV. You can set the password to open the Excel file if it is protected by using the respective property in the ConvertTableToCsvRequest object. The API returns a CSV-formatted stream that can be saved on disk, in the database or communicated over the javawork.
This article has taught us the process to convert an Excel table to a CSV stream. To convert an Excel chart to a PDF, refer to the article on Convert Excel chart to PDF using Java REST API.
