0

I want to know how to use Pandoc in standalone command line manner, to convert existing Excel reports in .xlsx format to PDF.

Hard to find examples on this.

And wondering if it has API interface with Python, to be able to embed this in Python.

Palu
  • 668
  • 3
  • 11
  • 26
  • 2
    You cannot do this with pandoc alone, xlsx is not a supported format. You could try using something like libre office calc on the command line to convert to HTML, the result of which could then be passed to pandoc. Not sure how good the end-result would be though. – tarleb Nov 20 '17 at 21:12
  • Hi, because the pandoc , website says that it is a universal converter, and shows it can handle many permutations of input formats to output formats, its seems like it can be done. Another person on a blog some how fed in excel into Rmarkdown and generated Word doc/PDF. – Palu Nov 21 '17 at 00:26
  • I don't want to have a dependency of having like a full fledged suite of some Office software. Do you know of some other library that can convert XLSX to PDF without having a dependency on an office suite. And this will be put on a server, like Ubuntu. – Palu Nov 21 '17 at 00:28
  • 1
    if you can export to csv, you can use e.g. https://github.com/mb21/pandoc-placetable – mb21 Nov 21 '17 at 08:59
  • 1
    Hi, my excel files can have many things, like Charts, Pivot Tables, Shapes, ... , all kinds of things. SO I need something to handle this which means I can't convert this to CSV. – Palu Nov 21 '17 at 15:36
  • SO really need an app that can cover an Excel report that has all things to PDF. So that is the goal. – Palu Nov 21 '17 at 15:38
  • Also if this app was a command line app that can interface with Python or Java, that would good so that one could run this on either Windows or Linux platforms. – Palu Nov 21 '17 at 15:40
  • You have quite a lot of and very specific requirements. I don't think there is any one toole that does what you want, but on the off chance that there is, you could try asking here: https://softwarerecs.stackexchange.com/ – tarleb Nov 21 '17 at 19:46

0 Answers0