Solved

Coldfusion - converting Excel files to PDF

Posted on 2014-01-30
2
932 Views
Last Modified: 2014-01-30
Hello,

Does anyone know if it's possible to convert Excel files to PDF. I was looking into cfspearsheet but it seems like it's not what I'm looking for. I also looked into OpenOffice but it looks like it can only convert the files to CVS or HTML.

Thank you!
0
Comment
Question by:HumanScaleDev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 39821538
If you're using CF9+ with OpenOffice, try using <cfdocument>. Though the CF docs don't mention Excel => PDF specifically, the conversion is powered by OpenOffice. So whatever conversions OpenOffice supports, cfdocument should support too. Try something like this:

http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WS692D73AF-6338-495d-9E47-C2ECD8BF9307.html

<cfdocument
    format="pdf"
    srcfile="C:\documents\MyDocument.xls"
    filename="C:\documents\MyDocument.pdf">
</cfdocument>
0
 

Author Closing Comment

by:HumanScaleDev
ID: 39821570
Awesome! thanks!
0

Featured Post

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question