Using PHP to convert XLSX to PNG
Use the sample PHP code below to easily and quickly convert XLSX files to the PNG format. Offering the ability to display Microsoft Excel spreadsheets in a high quality image format, get started converting XLSX files in minutes and integrate directly into your PHP application to save time and effort. We provide a free Test account to try the service out, comprehensive documentation and support from developers.
PHP Code Sample
1. Install the Zamzar SDK
composer require zamzar/zamzar-php2. Convert a file
<?php
// Signup for a Zamzar API Account or retrieve your existing API Key from https://developers.zamzar.com
$zamzar = new \Zamzar\ZamzarClient('YOUR_API_KEY_GOES_HERE');
// Converts /tmp/example.xlsx to /tmp/example.png
$zamzar
->jobs->create([
'source_file' => '/tmp/example.xlsx',
'target_format' => 'png'
])
->waitForCompletion();
->downloadTargetFiles('/tmp/');
->deleteAllFiles();Why Use Zamzar?
Highly Reliable
Our conversion service is there when you need it. Converting since 2006, our API had >99.99% uptime over the last 12 months.
Cloud API
Our cloud based platform scales to meet your demands, whether it's 1 file or 100,000. We manage everything so you don't have to.
All the formats
We support a huge range of conversions - over 1,100 in all. Including documents, videos, images, audio, eBooks, CAD files and more.
Secure & compliant
Our API uses strong encryption of data in transit (and at rest), firewalls, process isolation and state of the art data centers. We are fully GDPR compliant.
One simple API for all your file conversions. Supported on any platform.
Get Started NowCustomer Reviews
We have found our experience with Zamzar over the years we have used it to be fantastic.
They were receptive to a tiered pricing structure as our requirements changed, have a friendly support team that is always helpful and their API that we use daily to send documents to for conversion has always been available and had no issues.
Robin L
The service just works. We've tried other file conversion services in the past, and the results were very disappointing.
With Zamzar, the results are consistently good. Also, their support is friendly and responsive.
Bruno D
We needed a product to upload HTML content, convert and download as a PDF. Zamzar's API provided not only the service required but easy to understand stepped-process to implement.
This business process was critical - but I don't believe we ever had a failure over years of daily use.
Davd M
As Used By
Security and Compliance
Security
Physical access to Zamzar infrastructure is strictly controlled at perimeter and building ingress points by professional security staff utilising video surveillance.
Data Transfer
All traffic to and from Zamzar servers is secured by TLS/SSL. No third-party is able to read or tamper with data exchanged in connections to our servers.
Data at Rest
We encrypt files stored on disk with a unique key and multi-factor encryption so that data is unreadable if hardware is physically compromised.
Passwords
Zamzar API user passwords are stored in our database after being salted and hashed using the secure Bcrypt encryption algorithm.
Firewalls
Zamzar uses multiple different firewall technologies to ensure that different components of its systems are logically isolated from one another.
Using XLSX with PHP
Reading Excel files with PHP is not straight-forward but there's an excellent open source solution (licensed under LGPL version 3) known as PHP Spreadsheet. Perhaps unlike other libraries the best way to use this is to convert the excel sheets into PHP arrays and then use the data in PHP. There are three easy to follow steps that need to be followed - from loading the file in, to defining the reader options to then being able to load and display the data.
Another option is to use the open source, community driven PEAR package for generating Excel Spreadsheets.
A third alternative is using the Zamzar API. The API will allow you to manipulate your Excel file seamlessly and with the same quality as the native Microsoft Office toolset. There's no need to worry about hosting, and with S3 Integration you can automatically import and export to S3 with just two lines of code. There's a dedicated support team in place who can provide assistance at any stage of the process plus there's an extensive documentation library that should cover any issues/FAQ's.
Resources:
- PHPSpreadsheet a PHP library used to manipulate Microsoft Excel Documents
- Spreadsheet_Excel_Writer by PEAR is used to create Excel files.
Related StackOverflow Questions:
Using PNG with PHP
Depending on your specific needs there are a number of commercial and open source libraries that will enable you to convert or manipulate PNG files. One consideration is whether you want the outputted PNG file to be transparent. You could consider using GD which is a good PHP image library with extensive documentation.
Another open source option is ImageMagick which has a very powerful suite of tools and dedicated PHP libraries you can hook into. You can use ImageMagick via PHP for either file conversion or image manipulation, but the underlying tooling will need to be setup and configured on any servers you run your code on.
If you'd prefer to use commercial software with a dedicated developer support team to help you, and a powerful image rendering engine you could consider using the Zamzar API. With code examples in many of the major languages including PHP, simple low cost conversion credits and support for direct import and export to S3, it may cover most of the use cases you require. Feel free to reach out to our support team with any questions or dip into the getting started guide in our docs.