0

We are considering migrating a Cold Fusion application to Drupal and I am wondering if the below 2 capabilities that are current Cold Fusion application is doing can be done within Drupal 7.

  1. The ability to create native Excel XLS and XLSX files (NOT HTML tables that Excel has to convert each time it opens) from scratch. This includes the ability to use native Excel functions, formatting, and multiple tabs/sheets. CFSPREADSHEET makes this a relatively simple task for us.

  2. The ability to export directly to a PDF file. CFPDF and CFCONTENT makes this almost as simple as wrapping the desired output in a set of tags and it’s done in many cases.

1
  • PHPExcel. It uses PHPExcel library and supports native Excel export, import. We are using it in our project and it does it well.

The PHPExcel module allows developers to export/import data to/from real Excel files.

  • Print. It allows you to generate the printer-friendly, PDF, EPUB and Email versions of any node. It supports following libraries:

I'd recommend using the dompdf library, since I'm using it an it does the job well.

0

I've made a loads of PDF's using PHP and if you need to do anything complicated (particularly with tables) dompdf just can't handle it so I've stopped using it all together.

I've had great success with fpdf however I know a colleague has been using tcpdf for some really complicated ones (tables with dynamic content that may or may not break over multiple pages).

I agree with Елин that PHPExcel is the best choice for excel files.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.