Question: What is the best tool for converting Excel website reports into html or PDF formats for presentations? We have extensive reports for website data that is calculated and constructed using Excel. I was just wondering what would be the best way to convert these into html or PDF files which can be given to clients, as they would no longer contain all the raw data and equations in the actual excel sheet. Thanks.
Answer: According to your needs, maybe you can have a free trial of software VeryDOC Excel to HTML Converter. By this software, you can either convert Excel to HTML or Excel to PDF through command line. When converting Excel, this software supports all version MS Excel files like XLS, XLSX. In the following part, I will show you how to use this software.
Step 1. Download Excel to HTML Converter
- This software is command line version, when downloading finishes, there will be an zip file. Please unzip it and then you can call the executable file in MS Dos Windows.
- And as this is Windows application, now it can not work under Mac and Linux system.
Step 2. Convert Excel to HTML or Excel to PDF by command line
- When run conversion, please refer to the usage and examples.
- Usage: DOC2Any [options] <in-file> [<out-file>]
- When you need to convert Excel to HTML or Excel to PDF, please refer to the following command line templates.
doc2any.exe C:\in.xls C:\out.html
doc2any.exe C:\in.xls C:\out.pdf
doc2any.exe C:\in.xlsx C:\out.pdf
doc2any.exe C:\*.doc C:\*.pdf
doc2any.exe C:\*.doc C:\*.html
By above command line templates, you can convert Excel to HTML singly or in batch. Now let us check the conversion effect. - When you do the batch conversion, you can either use wild character or bat file.
for %F in (D:\test\*.xls) do "doc2any.exe" "%F" "%~dpnF.pdf"
for /r D:\test %F in (*.doc) do "doc2any.exe" "%F" "%~dpnF.pdf"
By this software, after conversion, all the tables and layout will be kept in output PDF or HTML file. When the output is PDF file formation, you can set password to protect output PDF file content. -
When you need to set password for the output PDF file, please refer to the following command line templates.
doc2any.exe -ownerpwd 123 -keylen 2 -encryption 3900 C:\in.doc C:\out.pdf
Related Parameters:openpwd <string> : Set 'open password' to PDF file
-ownerpwd <string> : Set 'owner password' to PDF file
-keylen <int> : Key length (40 or 128 bit)
-keylen 0: 40 bit RC4 encryption (Acrobat 3 or higher)
-keylen 1: 128 bit RC4 encryption (Acrobat 5 or higher)
-keylen 2: 128 bit RC4 encryption (Acrobat 6 or higher)
-encryption <int> : Restrictions -
When you need to convert Excel to HTML, please make sure that you have Office Excel installed. If you do not install MS Excel installed, OpenOffice can replace MS Excel when you run the conversion.
By this one software, you can either convert Excel to HTML or Excel to PDF by command line. During the using, if you have any question, please contact us as soon as possible.