Convert Microsot Excel (XLSX) to PDF with Python and xtopdf (Python)

2015-11-22T22:15:25-08:00

Python recipe 579128 by Vasudev Ram (excel, formats, openpyxl, pdf, python, xlsx, xtopdf).

This recipe shows how the basics of to convert the text data in a Microsoft Excel file (XLSX format) to PDF (Portable Document Format). It uses openpyxl to read the XLSX file and xtopdf to generate the PDF file.

Convert JSON to PDF with Python and xtopdf (Python)

2014-12-10T18:02:14-08:00

Python recipe 578979 by Vasudev Ram (json, pdfwriter, sys).

This recipe show the basic steps needed to convert JSON input to PDF output, using Python and xtopdf, a PDF creation toolkit. xtopdf is itself written in Pytho, and uses the ReportLab toolkit internally.

We set up some needed values, such as the output PDF file name, the font name and size, the header and footer, and the input lines for the body of the PDF output; all these values are passed in JSON format (in a single dictionary) to a function that uses those values to generate a PDF file with the desired content.

The code is intentionally kept simple so as to require the least amount of code needed to demonstrate the techniques involved. But it can be generalized or extended to more complex situations.

Convert HTML text to PDF with Beautiful Soup and xtopdf (Python)

2015-01-28T22:20:53-08:00

Python recipe 579014 by Vasudev Ram (file, format, pdf, pdfwriter, python, reportgeneration, reporting, reportlab, xtopdf).

This recipe shows how to convert the text in an HTML document to PDF. It uses the Beautiful Soup and xtopdf Python libraries. Beautiful Soup is a library for HTML parsing and content extraction. xtopdf is a library for PDF creation from other formats, including text and many others.

Generate a PDF invoice with xtopdf and Python (Python)

2015-10-07T18:02:46-07:00

Python recipe 579108 by Vasudev Ram (pdf, pdfwriter, pdf_generation, python, python2, xtopdf).

This recipe shows the basics of how to generate invoices as PDF documents, using xtopdf, a Python toolkit for PDF creation. An example of creating a simple invoice through Python and xtopdf code is shown.

xtopdf is available on Bitbucket at:

https://bitbucket.org/vasudevram/xtopdf

and you can find many links with examples of using xtopdf, how to install it, etc., from this Google search:

https://google.com/search?q=xtopdf

This sub-feed of my blog:

http://jugad2.blogspot.com/search/label/xtopdf

gives access to all my blog posts labelled xtopdf.

Convert Excel to PDF with xlwings and xtopdf (Python)

2015-02-22T10:42:18-08:00

Python recipe 579026 by Vasudev Ram (excel, pdf, pdfwriter, reportlab, xlwings, xtopdf).

This recipe shows how to get the text content from an Excel file and convert it to PDF, using the xlwings and xtopdf Python libraries. It also shows how to create an Excel file programmatically using xlwings.

Printing an ASCII table to PDF (Python)

2015-04-02T18:38:04-07:00

Python recipe 579043 by Vasudev Ram (ascii, pdf, pdf_generation, xtopdf).

This recipe shows how to print part of an ASCII table to PDF. It shows it for the first 32 ASCII characters, the control characters, i.e. the characters with ASCII codes 0 to 31. The same logic can be extended to print the remaining ASCII characters, either upto code 127 or 255, depending on your definition of ASCII, and also on whether your PDF font supports printing all those characters.

Read CSV with D and write it to PDF with Python (Python)

2016-10-26T17:49:00-07:00

Python recipe 580710 by Vasudev Ram (conversion, csv, data, files, formats, pdf, pdf_generation, xtopdf).

This recipe shows how to read data from a CSV file with a D program and write that data to a PDF file with a Python program - all in a single command-line invocation (after writing the individual programs, of course).

It requires the xtopdf toolkit, which you can get from:

https://bitbucket.org/vasudevram/xtopdf

Instructions for installing xtopdf:

http://jugad2.blogspot.in/2012/07/guide-to-installing-and-using-xtopdf.html

xtopdf in turn requires the open source version of the ReportLab toolkit, which you can get from:

http://www.reportlab.com/ftp (http://www.reportlab.com/ftp/reportlab-1.21.1.tar.gz)

It also requires the DMD compiler to compile the D program - this was the version used:

DMD32 D Compiler v2.071.2

Publish SQLite data to PDF using named tuples (Python)

2015-02-24T22:08:11-08:00

Python recipe 579027 by Vasudev Ram (conversion, pdf, pdfwriter, sql, sqlite, sqlite3, xtopdf).

This recipe shows how to publish SQLite data to PDF, using named tuples from the collections module of Python, the sqlite3 library, and the xtopdf library for PDF generation.

Use PrettyTable and xtopdf to create PDF tables with borders, alignment and padding (Python)

2015-01-24T21:21:27-08:00

Python recipe 579012 by Vasudev Ram (data, pdf, prettytable, string, tabular, xtopdf).

This recipe shows how to create tabular data in PDF format, supporting neat borders, and alignment and padding of columns, using the Python libraries called PrettyTable and xtopdf.

Publish databases to PDF with PyDAL (a Python DB library) and xtopdf (Python)

2015-01-15T16:09:27-08:00

Python recipe 579004 by Vasudev Ram (database, pdf, pydal, python, python_developer_tools, sql, web2py, xtopdf).

This recipe shows how to use the PyDAL database library for Python, together with xtopdf, a PDF creation library for Python, to publish database data to PDF. PyDAL was earlier a part of the web2py Python web framework, and then was split out into a separate library that does not need to be used with web2py. It supports access to many popular relational databases, both open source and proprietary.

Batch conversion of text files to PDF with fileinput and xtopdf (Python)

2016-11-07T20:28:01-08:00

Python recipe 580715 by Vasudev Ram (batch, batchmode, conversion, files, pdf, pdfwriter, python, text, text_processing, utilities, xtopdf).

This recipe shows how to do a batch conversion of the content of multiple text files into a single PDF file, with a) an automatic page break after the content of each text file (in the PDF output), b) page numbering, and c) a header and footer on each page.

It uses the fileinput module (part of the Python standard library), and xtopdf, a Python library for conversion of other formats to PDF.

xtopdf is available here: https://bitbucket.org/vasudevram/xtopdf

and a guide to installing and using xtopdf is here:

http://jugad2.blogspot.in/2012/07/guide-to-installing-and-using-xtopdf.html

Here is a sample run of the program:

python BTTP123.pdf text1.txt text2.txt text3.txt

This will read the content from the three text files specified and write it into the PDF file specified, neatly formatted.

[xtopdf] Publish Delimiter-Separated Values (DSV data) to PDF (Python)

2016-12-17T19:08:33-08:00

Python recipe 580736 by Vasudev Ram (commandline, csv, data, files, formats, pdf, pdf_generation, python, tsv, utilities, xtopdf).

This recipe shows how to publish delimiter-separated values (a commonly used tabular data format) to PDF, using the xtopdf toolkit for PDF creation. It lets the user specify the delimiter via one of two command-line options - an ASCII code or an ASCII character. As Unix filters tend to do, it can operate either on standard input or on input filenames given as command-line arguments. In the case of multiple inputs via files, each input goes to a separate PDF output file.

Convert wildcard text files to PDF with xtopdf (e.g. report*.txt) (Python)

2016-12-06T20:37:30-08:00

Python recipe 580727 by Vasudev Ram (conversion, files, globbing, patterns, pdf, pdfwriter, pdf_generation, text_processing, wildcard, xtopdf).

This recipe shows how to convert all text files matching a filename wildcard to PDF, using the xtopdf PDF creation toolkit. For example, if you specify report.txt as the wildcard, all files in the current directory that match report.txt, will be converted to PDF, each in a separate PDF file. The original text files are not changed.

Here is a guide to installing and using xtopdf:

http://jugad2.blogspot.in/2012/07/guide-to-installing-and-using-xtopdf.html

More details on running the program, and sample output, are available here:

http://jugad2.blogspot.in/2016/12/xtopdf-wildcard-text-files-to-pdf-with.html

Python-controlled Unix pipeline to generate PDF (Python)

2016-01-07T18:02:52-08:00

Python recipe 579146 by Vasudev Ram (linux, pdf, pdf_generation, pipe, pipelining, python, python2, unix).

This recipe shows how to create a Unix pipeline that generates PDF output, under the control of a Python program. It is tested on Linux. It uses nl, a standard Linux command that adds line numbers to its input, and selpg, a custom Linux command-line utility, that selects only specified pages from its input, together in a pipeline (nl | selpg). The Python program sets up and starts that pipeline running, and then reads input from it and generates PDF output.

Generate a PDF cheat sheet for converting 0 to 255 between bin / oct / dec / hex (Python)

2016-10-10T20:40:48-07:00

Python recipe 580706 by Vasudev Ram (binary, conversion, decimal, hexadecimal, octal, pdfwriter, pdf_generation, python, utility, xtopdf).

This recipe shows how to generate a PDF cheat sheet, that contains a table for conversion of the numbers 0 to 255 (the numbers that can fit in one byte) between binary, octal, decimal and hexadecimal representations. The table has four columns, one for each of those bases, and 256 rows, for the numbers 0 to 255.

TO use the table, you can look for a number, say in decimal, in the Dec(imal) column (or use the search function of your PDF viewer), then when you find it in some row, just look at the other 3 columns in that row, to find the value of that number in binary, octal and hexadecimal. And use the same procedure if starting with a number in any of the other three bases.

Create PDF control break reports with itertools.groupby and xtopdf (Python)

2016-07-23T22:17:29-07:00

Python recipe 580692 by Vasudev Ram (control, database, grouping, iterators, pdf, pdfwriter, pdf_generation, python, reportgeneration, reporting, sql, xtopdf).

This recipe shows how to create the classic control break style of report (a staple of data processing) using Python along with the groupby function from the itertools module, and xtopdf, a Python toolkit for PDF creation.

Put Peewee ORM data to PDF with xtopdf (Python)

2016-09-29T18:04:57-07:00

Python recipe 580704 by Vasudev Ram (conversion, converter, database, formats, orm, pdf, pdf_generation, peewee, python, python2, sqlite, xtopdf).

This recipe shows how some basics of how to fetch data from database tables managed by the Peewee ORM (a lightweight expressive ORM for Python) and write that data, formatted, to a PDF file. The recipe uses Python, the Peewee ORM and the xtopdf toolkit for PDF creation.

Publish a Windows Process List to PDF with xtopdf (Batch)

2015-12-27T20:45:32-08:00

Batch recipe 579142 by Vasudev Ram (pdf, pdfwriter, pdf_generation, processes, process_management, python, windows).

This recipe shows how you can generate a Windows process list or task list (basically, a list of running processes, with some information about each of them), to a PDF file, using the Windows TASKLIST command along with the xtopdf toolkit. The list is sorted in ascending order of memory usage of the processes, before writing it to PDF.

It differs somewhat from other xtopdf recipes, in that no additional code needs to be written, over and above what is already in the xtopdf package. We just have to use the needed commands there, in a series of commands or a pipeline.

However, one can still write additional code, by modifying the program used (StdinToPDF.py), if needed, to customize the PDF output.

Publish Firebird SQL data to PDF with xtopdf (Python)

2015-12-01T19:45:18-08:00

Python recipe 579131 by Vasudev Ram (database, firebird, pdfwriter, python, sql, xtopdf).

This recipe shows how to publish data from the Firebird RDBMS to PDF, using the xtopdf toolkit and the fbd Python driver for Firebird. Firebird is a cross-platform, open source RDBMS based on the former Interbase RDBMS from Borland, which they used to bundle with some of their developmemt tools, such as Borland C++ and Borland Delphi.

The recipe reads data from a Firebird table, using the fbd Python driver for Firebird, and writes it to PDF, using the xtopdf toolkit. See:

http://jugad2.blogspot.in/p/xtopdf-pdf-creation-library.html

for information on xtopdf.

It assumes that a Firebird database called test.fdb exists under /temp/firebird (C:\temp\firebird, really - the test was done on Windows), and that it has a contacts table with the structure shown in the code of the recipe.

More details and sample output are here:

http://jugad2.blogspot.in/2014/01/by-vasudev-ram-pdf-firebird-is-cross.html

Create tabular PDF reports with xtopdf and tablib in Python (Python)

2014-12-25T17:48:53-08:00

Python recipe 578991 by Vasudev Ram (pdf, reportgeneration, reporting, reportlab, tablib, xtopdf).

This recipe shows how to create tabular PDF reports, i.e. PDF reports containing tabular data - rows and columns, using Python, xtopdf (a PDF creation library) and tablib (a Python library for manipulating tabular data).

Most viewed recipes tagged "meta:requires=pdfwriter"

Convert Microsot Excel (XLSX) to PDF with Python and xtopdf (Python)

Convert JSON to PDF with Python and xtopdf (Python)

Convert HTML text to PDF with Beautiful Soup and xtopdf (Python)

Generate a PDF invoice with xtopdf and Python (Python)

Convert Excel to PDF with xlwings and xtopdf (Python)

Printing an ASCII table to PDF (Python)

Read CSV with D and write it to PDF with Python (Python)

Publish SQLite data to PDF using named tuples (Python)

Use PrettyTable and xtopdf to create PDF tables with borders, alignment and padding (Python)

Publish databases to PDF with PyDAL (a Python DB library) and xtopdf (Python)

Batch conversion of text files to PDF with fileinput and xtopdf (Python)

[xtopdf] Publish Delimiter-Separated Values (DSV data) to PDF (Python)

Convert wildcard text files to PDF with xtopdf (e.g. report*.txt) (Python)

Python-controlled Unix pipeline to generate PDF (Python)

Generate a PDF cheat sheet for converting 0 to 255 between bin / oct / dec / hex (Python)

Create PDF control break reports with itertools.groupby and xtopdf (Python)

Put Peewee ORM data to PDF with xtopdf (Python)

Publish a Windows Process List to PDF with xtopdf (Batch)

Publish Firebird SQL data to PDF with xtopdf (Python)

Create tabular PDF reports with xtopdf and tablib in Python (Python)