Why PDF.co Web API
PDF.co Web API offers a collection of Web APIs and online tools. It includes functionalities such as data extraction, file conversion, and more.
The XLS to XML Web API is designed to make it easy for you to transfer data between systems over the internet. It converts your XLS files to XML while maintaining the structure and layout of text, images, tables, and other objects.
Our API engine resides and runs from the secure Amazon AWS infrastructure. Furthermore, all data transfers from your devices to our servers are secure by SSL/TLS. Check this link for more details about our security: https://pdf.co/security.
XLS to XML Web API Benefits
Manage Workbooks
When using the XLS to XML Web API, you can manage workbooks and data that were previously impossible or very difficult. In the XLS to XML, you can easily add, identify, and extract specific pieces of business data from XLS files.
Online Format
The XLS to XML Web API is used format for document storage and processing online. It allows almost any information in any written human language to communicate.
International Standards
The XLS to XML Web API is platform-independent. You can use it in Windows, Linux, Mac, and other operating systems. You can also use it on your desktop or mobile apps.
XLS to XML Web API Integrations
The PDF.co Web API has over 300+ integrations available. Here is some sample of integrations below:
- Zapier – https://pdf.co/zapier
- Integromat – https://pdf.co/integromat
- Blue Prism – https://pdf.co/blueprism
- UiPath – https://pdf.co/uipath
- Automation Anywhere – https://pdf.co/automation-anywhere
XLS to XML Web API Sample and Demo
We will use this sample XLS file to convert into XML and use the /v1/xls/convert/to/xml for the endpoints.
Now let’s take a quick look at the /v1/xls/convert/to/xml endpoint’s parameters and their uses.
Endpoint
| URL: | https://api.pdf.co/v1/xls/convert/to/xml |
| Method: | POST |
| Parameter | Description |
| url | required. Link to the source file. |
| expiration | optional. Output link expiration in minutes. Default is 60 (i.e. 60 minutes or 1 hour). After this delay generated output file(s) (if any) will be auto-removed from PDF.co temporary files storage. Max allowed expiration period depends on your current subscription plan. To store permanent input files (e.g. re-usable images, pdf, documents), please use PDF.co built-in Files Storage instead. |
| inline | optional. Must be one of: true to return data as inline or false to return link to the output file (default). |
| worksheetIndex | optional. index of the worksheet to use. |
| encrypt | optional. Enable encryption for the output file: true or false |
| async | optional. Runs processing asynchronously. Returns jobId to use with job/check: true or false |
| name | optional. Output file name. |
| profiles | optional. Must be a String. Set custom configuration. See profiles examples here |
cURL Code Snippet
curl --location --request POST 'https://api.pdf.co/v1/xls/convert/to/xml' \
--header 'x-api-key: your-api-key' \
--header 'Content-Type: application/json' \
--data-raw '{
"url": "https://docs.google.com/spreadsheets/d/1-S2p_oL40Q-KkEhSc9khiqNcNx46BuIC/edit?usp=sharing&ouid=114887936429289482092&rtpof=true&sd=true"
}'
The XLS to XML Web API cURL sample code is available here.
Let’s see the XLS to XML Web API in action using cURL.
