XLSX to PNG PHP API

Convert XLSX files to PNG images using our PHP XLSX to PNG API.

Why PSPDFKit API?

SOC 2 Compliant

Build the workflows you need without worrying about security. We don’t store any document data, and our API endpoints are served through encrypted connections.

Easy Integration

Get up and running in hours, not weeks. Access well-documented APIs and code samples that make integrating with your existing workflows a snap.

One Document, Endless Actions

With access to more than 30 tools, you can process one document in multiple ways by combining API actions. Convert, OCR, rotate, and watermark with one API call.

Simple and Transparent Pricing

Pay only for the number of documents you process. You won’t need to consider file size, datasets being merged, or different API actions being called.

Try It Out

This example will convert your uploaded XLSX file to a PNG image.

1

Use Your Free API Calls

Sign up to process 100 documents per month for free, or log in to automatically add your API key to sample code.

Add a File

Add a XLSX file named document.xlsx to your project folder. You can also use our sample file. The file name is case sensitive. Make sure the file name matches the file name in the sample code.

Run the Code

Copy the code and run it from the same folder you added the files to. For more information, see our language-specific getting started guides.

View the Results

Open image.png in your project folder to view the results.

curl -X POST https://api.pspdfkit.com/build \
  -H "Authorization: Bearer your_api_key_here" \
  -o image.png \
  --fail \
  -F document=@document.xlsx \
  -F instructions='{
      "parts": [
        {
          "file": "document"
        }
      ],
      "output": {
        "type": "image",
        "format": "png",
        "dpi": 500
      }
    }'
package com.example.pspdfkit;

import java.io.File;
import java.io.IOException;
import java.nio.file.FileSystems;
import java.nio.file.Files;
import java.nio.file.StandardCopyOption;

import org.json.JSONArray;
import org.json.JSONObject;

import okhttp3.MediaType;
import okhttp3.MultipartBody;
import okhttp3.OkHttpClient;
import okhttp3.Request;
import okhttp3.RequestBody;
import okhttp3.Response;

public final class PspdfkitApiExample {
  public static void main(final String[] args) throws IOException {
    final RequestBody body = new MultipartBody.Builder()
      .setType(MultipartBody.FORM)
      .addFormDataPart(
        "document",
        "document.xlsx",
        RequestBody.create(
          new File("document.xlsx"),
          MediaType.parse("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
        )
      )
      .addFormDataPart(
        "instructions",
        new JSONObject()
          .put("parts", new JSONArray()
            .put(new JSONObject()
              .put("file", "document")
            )
          )
          .put("output", new JSONObject()
            .put("type", "image")
            .put("format", "png")
            .put("dpi", 500)
          ).toString()
      )
      .build();

    final Request request = new Request.Builder()
      .url("https://api.pspdfkit.com/build")
      .method("POST", body)
      .addHeader("Authorization", "Bearer your_api_key_here")
      .build();

    final OkHttpClient client = new OkHttpClient()
      .newBuilder()
      .build();

    final Response response = client.newCall(request).execute();

    if (response.isSuccessful()) {
      Files.copy(
        response.body().byteStream(),
        FileSystems.getDefault().getPath("image.png"),
        StandardCopyOption.REPLACE_EXISTING
      );
    } else {
      // Handle the error
      throw new IOException(response.body().string());
    }
  }
}
using System;
using System.IO;
using System.Net;
using RestSharp;

namespace PspdfkitApiDemo
{
  class Program
  {
    static void Main(string[] args)
    {
      var client = new RestClient("https://api.pspdfkit.com/build");

      var request = new RestRequest(Method.POST)
        .AddHeader("Authorization", "Bearer your_api_key_here")
        .AddFile("document", "document.xlsx")
        .AddParameter("instructions", new JsonObject
        {
          ["parts"] = new JsonArray
          {
            new JsonObject
            {
              ["file"] = "document"
            }
          },
          ["output"] = new JsonObject
          {
            ["type"] = "image",
            ["format"] = "png",
            ["dpi"] = 500
          }
        }.ToString());

      request.AdvancedResponseWriter = (responseStream, response) =>
      {
        if (response.StatusCode == HttpStatusCode.OK)
        {
          using (responseStream)
          {
            using var outputFileWriter = File.OpenWrite("image.png");
            responseStream.CopyTo(outputFileWriter);
          }
        }
        else
        {
          var responseStreamReader = new StreamReader(responseStream);
          Console.Write(responseStreamReader.ReadToEnd());
        }
      };

      client.Execute(request);
    }
  }
}
const axios = require('axios')
const FormData = require('form-data')
const fs = require('fs')

const formData = new FormData()
formData.append('instructions', JSON.stringify({
  parts: [
    {
      file: "document"
    }
  ],
  output: {
    type: "image",
    format: "png",
    dpi: 500
  }
}))
formData.append('document', fs.createReadStream('document.xlsx'))

;(async () => {
  try {
    const response = await axios.post('https://api.pspdfkit.com/build', formData, {
      headers: formData.getHeaders({
          'Authorization': 'Bearer your_api_key_here'
      }),
      responseType: "stream"
    })

    response.data.pipe(fs.createWriteStream("image.png"))
  } catch (e) {
    const errorString = await streamToString(e.response.data)
    console.log(errorString)
  }
})()

function streamToString(stream) {
  const chunks = []
  return new Promise((resolve, reject) => {
    stream.on("data", (chunk) => chunks.push(Buffer.from(chunk)))
    stream.on("error", (err) => reject(err))
    stream.on("end", () => resolve(Buffer.concat(chunks).toString("utf8")))
  })
}
import requests
import json

instructions = {
  'parts': [
    {
      'file': 'document'
    }
  ],
  'output': {
    'type': 'image',
    'format': 'png',
    'dpi': 500
  }
}

response = requests.request(
  'POST',
  'https://api.pspdfkit.com/build',
  headers = {
    'Authorization': 'Bearer your_api_key_here'
  },
  files = {
    'document': open('document.xlsx', 'rb')
  },
  data = {
    'instructions': json.dumps(instructions)
  },
  stream = True
)

if response.ok:
  with open('image.png', 'wb') as fd:
    for chunk in response.iter_content(chunk_size=8096):
      fd.write(chunk)
else:
  print(response.text)
  exit()
<?php

$FileHandle = fopen('image.png', 'w+');

$curl = curl_init();

$instructions = '{
  "parts": [
    {
      "file": "document"
    }
  ],
  "output": {
    "type": "image",
    "format": "png",
    "dpi": 500
  }
}';

curl_setopt_array($curl, array(
  CURLOPT_URL => 'https://api.pspdfkit.com/build',
  CURLOPT_CUSTOMREQUEST => 'POST',
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_POSTFIELDS => array(
    'instructions' => $instructions,
    'document' => new CURLFILE('document.xlsx')
  ),
  CURLOPT_HTTPHEADER => array(
    'Authorization: Bearer your_api_key_here'
  ),
  CURLOPT_FILE => $FileHandle,
));

$response = curl_exec($curl);

curl_close($curl);

fclose($FileHandle);

Using Postman? Download our official collection and start using the API with a single click. Read more 

Your API Key

Rendering a Single Page

The default is to render the first page, but you can also render any other page of the document by adding the pages option.

This will render the fifth page (remember pages are indexed starting from 0):

"output": {
  "type": "image",
  "pages": {"start": 4, "end": 4},
  "format": "png",
  "width": 500
}

Rendering Multiple Pages

In addition to rendering just a single page (the default is the first), you can also render multiple pages at the same time. Simply add the pages option.

Note: You can only render 50 pages in a single request. Requesting more than 50 pages will result in a status 400 being returned.

The following example will return a ZIP file containing all pages:

"output": {
  "type": "image",
  "pages": {"start": 0, "end": -1},
  "format": "png",
  "width": 500
}

You can also render a subset of pages. This will render pages 2, 3, and 4:

"output": {
  "type": "image",
  "pages": {"start": 1, "end": 3},
  "format": "png",
  "width": 500
}

The files in the ZIP file will be named <page_number>.png

Controlling Image Dimensions

You can give the output images a specific width or height, or you can render them with a specific resolution. You can only choose one of those three options. Specifying more than one will result in a status 400 being returned.

Depending on which option you choose, one or both dimensions will be determined based on the dimensions of the page in the document. The following will go into detail about each of the three options.

Note: There is a limit to the final resolution of the resulting images. Any image is not allowed to be bigger than 34 million pixels (4960×7016px), regardless of the aspect ratio. Requesting a bigger image will result in a status 400 being returned.

You can specify the width . In this case, all rendered pages will have the same width, but they’ll have varying heights depending on the page dimensions in the document:

"output": {
  "type": "image",
  "format": "png",
  "width": 768
}

You can specify the height . In this case, all rendered pages will have the same height, but they’ll have varying widths depending on the page dimensions in the document:

"output": {
  "type": "image",
  "format": "png",
  "height": 1024
}

And finally, you can specify the dpi . In this case, the width and height of the rendered pages depends only on the page dimensions:

"output": {
  "type": "image",
  "format": "png",
  "dpi": 72
}