If you are writing python 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) Open up your package manager and run the command
pip install api2pdf
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.
from api2pdf import Api2Pdf a2p_client = Api2Pdf('YOUR-API-KEY') api_response = a2p_client.LibreOffice.html_to_xlsx('http://www.api2pdf.com/wp-content/uploads/2021/01/sampleTables.html') print(api_response.result)
And that’s it! Modify the code as you see fit. Hopefully this saves you time and makes converting converting HTML to excel files easy and painless for those writing python code.
We have a whole python 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.pythonTags: html to excel api, html to excel python, html to xlsx api, html to xlsx python, libreoffice html to excel, libreoffice html to xlsx, python libreoffice xlsx
Comments are closed.