JustLabel <\> Techs
Go to download

Excel printing

This tutorial will show you how you can generate Excel spreadsheets with which you can easily run serial printouts by completing data for individual placeholders in the columns of the spreadsheet.

Printing process using Excel sheet

If you have the label template in your database, you can download spreadseet from the Templates by simply clicking on the Download spreadsheet button in the actions section of a specific template.

The print process looks like this:

  1. Download the spreadsheet
  2. Complete the data for placeholders in the appropriate columns
  3. Press the Print button

Tutorial example dataset

This tutorial is based on highly personalized settings. The user can have any names of printers and print queues, he can have any names of labels as well as any names of placeholders. Therefore, we need to prepare a set of data on which we will build the following example. Below we present a set of exemplary data along with a description of individual elements. This will allow you to easily transfer the logic of the example to real customer use case.

  • printer – the name of printer defined in Printers tab – our example: testPrinter
  • printer queue – the name of printer queue, which by default is automatically created in Printouts tab – our example: pq_testPrinter
  • template – the name of label template, we want to print – our example: testTemplate
  • placeholders – the names of placeholders used in the template:
    • namePlaceholder
    • descriptionPlaceholder

Practice printing using Excel

To do this exercise we will use the printer names, queues and template with placeholders from the section above. You can create a sample template or recreate the example using just real data.

Reproduce the steps

  1. Open the Templates page and clock the Download spreadsheet.. button in Actions column for a desired template. In our example, the template name is testTemplate
  2. In the Download spreadsheet popup window choose the desired printer and printer queue from the drop-down list. In our example, printer name is `T
  3. If authorization via API Key has been enabled for a given queue, also select the appropriate one from the drop-down list (more information on authorization of printouts can be found in this tutorial)
  4. Open the downloaded file and allow scripts execution
  5. Complete the data in the columns ordinal, namePlaceholder and descriptionPlaceholder (or other, compatible with placeholders’ names in your template) with any values you want to print
  6. Click the Print button

Our example Excel spreadsheet would look like this for three labels with some example values:

Table of contents