By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,799 Members | 1,283 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,799 IT Pros & Developers. It's quick & easy.

Suggestions for creating a PDF table

P: n/a
Short question:

Is there a good library for generating HTML-style tables with the equivalent
of colspans, automatically sized columns, etc. that can render directly to
PDF?

Longer question:

I'm re-doing a big chunk of locally-written code. I have a
report-generating function that takes a list of lists of lists as input and
returns either a PDF, an HTML table, or an Excel spreadsheet as requested.
For example, input might look like:

makereport('html',
headers=['Invoice number', 'Customer', 'Price'],
data=[
[['123', 'John Doe', '$50.00'],
['Ordered on 2008-01-01 via the website']],
[['124', 'Peter Bilt', '$25.99'],
['Mail via African swallow']]
])

This would result in HTML like:

<table>
<tr>
<th>Invoice number</th>
<th>Customer</th>
<th>Price</th>
</tr>
<tr class="lightbackground">
<td>123</td>
<td>John Doe</td>
<td>$50.00</td>
</tr>
<tr class="lightbackground">
<td colspan="3">Ordered on 2008-01-01 via the website</td>
</tr>
<tr class="darkerbackground">
<td>124</td>
<td>Peter Bilt</td>
<td>$25.99</td>
</tr>
<tr class="darkerbackground">
<td colspan="3">Mail via African swallow</td>
</tr>
</table>

Note particularly how the explanatory notes for each invoice are similar in
appearance to the "primary" report lines they're associated with.

Now, I have a similar transformation to PDF via pdflatex. This works fairly
well but requires a bunch of temp files and subprocesses, and I've never
been 100% happy with the LaTeX output (you have to calculate your own
column widths, for instance). Since I plan to re-write this anyway, I'd
like to find a more widely used library if one was available.

ReportLab seemed *almost* perfect, except that it doesn't support colspans.
As I hope I demonstrated in the example, most of our reports depend on that
ability.

So, again, any thoughts on a PDF generator that can generate tables with the
same kind of flexibility as HTML?
--
Kirk Strauser
Jul 28 '08 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Kirk Strauser wrote:
Short question:

Is there a good library for generating HTML-style tables with the equivalent
of colspans, automatically sized columns, etc. that can render directly to
PDF?

Longer question:

I'm re-doing a big chunk of locally-written code. I have a
report-generating function that takes a list of lists of lists as input and
returns either a PDF, an HTML table, or an Excel spreadsheet as requested.
For example, input might look like:

makereport('html',
headers=['Invoice number', 'Customer', 'Price'],
data=[
[['123', 'John Doe', '$50.00'],
['Ordered on 2008-01-01 via the website']],
[['124', 'Peter Bilt', '$25.99'],
['Mail via African swallow']]
])

This would result in HTML like:

<table>
<tr>
<th>Invoice number</th>
<th>Customer</th>
<th>Price</th>
</tr>
<tr class="lightbackground">
<td>123</td>
<td>John Doe</td>
<td>$50.00</td>
</tr>
<tr class="lightbackground">
<td colspan="3">Ordered on 2008-01-01 via the website</td>
</tr>
<tr class="darkerbackground">
<td>124</td>
<td>Peter Bilt</td>
<td>$25.99</td>
</tr>
<tr class="darkerbackground">
<td colspan="3">Mail via African swallow</td>
</tr>
</table>

Note particularly how the explanatory notes for each invoice are similar in
appearance to the "primary" report lines they're associated with.

Now, I have a similar transformation to PDF via pdflatex. This works fairly
well but requires a bunch of temp files and subprocesses, and I've never
been 100% happy with the LaTeX output (you have to calculate your own
column widths, for instance). Since I plan to re-write this anyway, I'd
like to find a more widely used library if one was available.

ReportLab seemed *almost* perfect, except that it doesn't support colspans.
As I hope I demonstrated in the example, most of our reports depend on that
ability.

So, again, any thoughts on a PDF generator that can generate tables with the
same kind of flexibility as HTML?
It does support the equivalent of colspans. See page 75 of the userguide manual.

-Larry
Jul 28 '08 #2

P: n/a
Kirk Strauser wrote:
Short question:

Is there a good library for generating HTML-style tables with the equivalent
of colspans, automatically sized columns, etc. that can render directly to
PDF?

Longer question:

I'm re-doing a big chunk of locally-written code. I have a
report-generating function that takes a list of lists of lists as input and
returns either a PDF, an HTML table, or an Excel spreadsheet as requested.
For example, input might look like:

makereport('html',
headers=['Invoice number', 'Customer', 'Price'],
data=[
[['123', 'John Doe', '$50.00'],
['Ordered on 2008-01-01 via the website']],
[['124', 'Peter Bilt', '$25.99'],
['Mail via African swallow']]
])
<snip>
Now, I have a similar transformation to PDF via pdflatex. This works fairly
well but requires a bunch of temp files and subprocesses, and I've never
been 100% happy with the LaTeX output (you have to calculate your own
column widths, for instance). Since I plan to re-write this anyway, I'd
like to find a more widely used library if one was available.

<snip>

Short answer: LaTeX should be good. Use XML source; XSLT to TeXML; TeXML
to LaTeX ( uses a python program); compile to PDF.

Longer answer: Can you provide a minimal example of the kind of
LaTeX source you would ideally like ?

If not, your problem is with LaTeX itself, which has if anything
__too_many__ ways of controlling tables rather than inadequate
ways. If so, we may be able to help with the rather arcane
transformation into TeXML format.

As for all the temp files that LaTeX creates, they are easily dealt
with using a makefile or whatever.

Bye for now,
Ken
Aug 8 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.