If you are writing php code, you might be tasked with the strange requirement of converting HTML to a Microsoft Excel (xlsx) file. After some research, you discover that this is not as trivial as you hoped it would be. You might have ended up on stackoverflow seeing old, outdated libraries or confusing answers that ask you to use interop or LibreOffice. Let’s make your pain go away right now.
Our API will take your .html file and convert it to xlsx. Just make sure your HTML is saved as a .html file and accessible at a URL that our service can ingest. For example, see this: https://www.api2pdf.com/wp-content/uploads/2021/01/sampleTables.html — Ideally a file storage provider like S3 or Azure Blob Storage. See the code sample below.
Step 1) Install the PHP client library from github: https://github.com/Api2Pdf/api2pdf.php
Step 2) Grab an API key from https://portal.api2pdf.com. Only takes 60 seconds.
Step 3) Use the sample code below and replace “YOUR-API-KEY” with the api key you acquired in step 2.
require_once 'your-own-directory/Api2Pdf.php'; $apiClient = new Api2Pdf('YOUR-API-KEY'); $result = $apiClient->libreOfficeHtmlToXlsx('http://www.api2pdf.com/wp-content/uploads/2021/01/sampleTables.html'); echo $result->getFile();
And that’s it! Modify the code as you see fit. Hopefully this saves you time and makes converting HTML to Xlsx files easy and painless for those writing php code.
We have a whole php based client library for our API that does a lot more than just this. Check out the full library capabilities here: https://github.com/Api2Pdf/api2pdf.phpTags: html to excel api, html to excel php, html to xlsx api, html to xlsx php, libreoffice html to xlsx php, php libreoffice xlsx
Comments are closed.