 |
|
|
|
|
|
|
|
|
About
Convert Excel To PDF COM is a COM component/object designed to assist you, the
developer, to quickly add a conversion utility to your application. It can be
called from VB, VC, DELPHI, and you can watch the source file folder and convert
new uploading Excel xls files to pdf automatically. You can batch convert multiple Excel files on the fly to
pdf.
Furthermore, we provide some VB and DELPHI examples. Although you may not be using Visual Basic and DELPHI, the approach for all development environments will be similar.
Key Features
A. Batch convert Microsoft Excel xls files to pdf files quickly.
B. Can watch source file folder and convert new uploading Excel files to pdf
automatically.
C. Supports COM interface and command line arguments.
D. Can add files in subfolders to convert.
E. Supports drag & drop
F. Can create run log file.
System Requirements
1. Pentium 150 PC, or higher, 16MB RAM, or more.
2. Windows 95, or above.
3. Microsoft Excel 2000, or higher
5. Postscript printer. click here to see how to install a postscript printer.
How to install it?
The install is very easy, please see the following steps:
1. You only run czXls2Htm.exe, click "yes" on the dialog "This will install Convert Excel To
PDF, do you wish continue?"
2. Click the "next" button.
3. Select the destination directory and click "next".
4. Click the "next" button on the next dialog.
5. Click "install".
6. Click "finish".
How does "Manual Convert" work?
Click "Manual Convert" tab. You can simply press the "add files"
button then select the files to batch convert. Or,
click the "add folders" button to select the chosen folder(s). Finally
press the "convert" button.
How does "Folder Watcher" work?
Click the "Folder Watcher" tab, then click the "Add Watch" button.
This will show a "Add Watch" dialog where you can input a "Source File Path", "Dest File Path" and "File
Filter". Press "OK" and you will add a file watch to folder watcher list.
Finally
press "Start Watch".
How to install a postscript printer?
click here to get how to install a postscript printer.
The problem is that the bold, color and italic text appears jagged,
i.e. you can see the actual pixels that form the characters. What can we do to fix
this problem?
Yes, you can fix this problem, please go to the "HP Color LaserJet 4600 PostScript"
printer, select properties, Printing Preferences, Advanced, TrueType Fonts, change
to " Download as SoftFont". Then click OK, then Apply, then OK.
How to use command line run?
usage: Convert Excel To PDF <file path> [/d:dest path] [/s] [/h] [/?]
<file path>
the path and files want to be converted, for example, d:\*.xls
[/d:dest path] the dest file path
/s
include the files in subfolders
/h
hide the Convert Excel To PDF COM gui while running
/?
show help
example 1:
convert all excel xls files in disk d to pdf files, the dest path is d:\dest
Convert Excel
To PDF d:\*.xls /d:d:\dest /s
example 2:
convert all excel xls files in d:\ dir to pdf files and hide the Convert Excel To
PDF COM gui
Convert Excel To PDF
d:\*.xls /h
What's Convert Excel To PDF COM Properties?
Visible Property
Indicates whether the dialog of Convert Excel To PDF COM show. When set to true,
the dialog show, otherwise the dialog hide. You can use Visible property to check
the status of the dialog.
Syntax
boolValue = oCZXls2PdfCOM.Visible
oCZXls2PdfCOM.Visible = boolValue
Remarks
Boolean. The property is read/write. Returns true if the dialog show, or false
if not. Default is true.
VB Example
The following VB example sets the Visible property of an Convert Excel
To PDF COM object to false after initializing COM:
dim ConvertCom as object
set ConvertCom=CreateObject("czxls2pdf.ConvertApplication")
ConvertCom.Visible=true
DELPHI Example
The following DELPHI example sets the Visible property of an CZXls2PdfCOM
object to false after initializing COM:
var ConvertCom: Variant;
ConvertCom := CreateOleObject('czxls2pdf.ConvertApplication');
ConvertCom.Visible:=true;
What's Convert Excel To PDF COM Methods?
ConvertFolder Method
Convert doc files in folder to pdf files.
Syntax
strValue = oCZXls2PdfCOM.ConvertFolder(SrcFilePath,DestFilePath,IsSubFolder,BSTR
Option)Parameters
String specifying source file path, for example "c:\*.xls"
DestFilePath
String specifying destination file path, if blank then convert to current
path.
IsSubFolder
Boolean. Flag that indicates whether convert file of sub folder. If true,
convert file of sub folder. If false, do not convert file of sub folder.
Option
String, reserve.
Returns
String, return the conversion error reason, if return is blank, then
convert successfully, otherwise is error reason.
VB Example
The following VB example convert "c:\*.xls" to pdf file, not include file of
sub-folder, the conversion result is in "d:\":
dim ConvertCom as object
dim sResult as string
set ConvertCom=CreateObject("czxls2pdf.ConvertApplication")
ConvertCom.Visible=true
sResult=ConvertCom.ConvertFolder("c:\*.xls","d:\",false,"")
if sResult="" then
msgbox "Convert OK!"
else
msgbox "Convert Failure, error reason
is" & sResult
end if
set ConvertCom=nothing
DELPHI Example
The following DELPHI example convert "c:\*.xls" to pdf file, not include file
of sub-folder, the conversion result is in "d:\":
var ConvertCom: Variant;
sResult:string;
ConvertCom := CreateOleObject('czxls2pdf.ConvertApplication');
ConvertCom.Visible:=true;
sResult:=ConvertCom.ConvertFolder('c:\*.xls','d:\',false,'');
if sResult='' then
showmessage('Convert OK!')
else
showmessage('Convert failure, error reason
is ' + sResult);
ConvertCom:=UnAssigned;
How to use COM component/object in DELPHI?
1. COM Init
Example:
var ConvertCom: Variant;
ConvertCom := CreateOleObject('czxls2pdf.ConvertApplication');
2. COM Property
Example:
ConvertCom.Visible:=true;
3. COM Method
Example:
sResult:=ConvertCom.ConvertFolder('c:\*.xls','d:\',false,'');
4. Close COM
Example:
ConvertCom:=UnAssigned;
How to use COM component/object in VB?
1. COM Init
Example:
set ConvertCom=CreateObject("czxls2pdf.ConvertApplication")
2. COM Property
Example:
ConvertCom.Visible=true
3. Com Method
Example:
result=ConvertCom.ConvertFolder("c:\*.xls","d:\",false,"")
4. Close COM
Example:
set ConvertCom=nothing
How to install the PostScript Printer Driver
To be able to create a PostScript file that can be printed directly to a PostScript output device, the PostScript Printer Driver must be available on the computer. The following are the steps to install the PostScript Printer Driver. These rough steps are for a PC-compatible computer using Windows 95/98/ME/NT/2000/XP, there are some small differences between Windows 95/98/ME/NT/2000/XP, you need to adjust yourself.
Step 1:
To install a PostScript Driver, click the Start button located in the lower
left hand corner of the screen and highlight the setting options. On the sub-menu,
double click on Printers.
Step 2:
The Printers dialog box will open. It will list the printers that are now installed,
double click on Add Printer..
Step 3:
In the Wizard dialog window, select Local Printer. Click on Next.
Step 4:
A new dialog window appears with Manufacturers and Printers listed, then click
"on the Have Disk" and use the supplied driver
and input "c:\printer" path after select "on hard disk", select "HP Color LaserJet
4600 PS" printer to install. Click on Next.
Step 5:
The next window allows you to change the name of the printer, you need not rename
the name of the printer, Click on Next.
Step 6:
The next window asks you if a test page is to be printed. Select No and click
on Finish.
Step 7:
A final dialog box may ask the user to insert the Windows CD or a disk loaded
with the proper driver.
Convert Excel To PDF COM
$219.00 Unconditional 30-day money-back
guarantee
| Order Type: |
|
DEMO CONVERTERS: All Office Converter Pro | Doc Xls PPT Txt To Pdf Converter | Easy Word to Pdf Converter | Excel/Xls to Image Jpg/Jpeg Bmp Tiff Png Converter | Excel/Xls to Pdf Converter | Power Word to Pdf Converter | PowerPoint/PPT to Image Jpg/Jpeg Bmp Png Converter | PowerPoint/PPT to Pdf Converter | Quick Word to Pdf Converter | Word Excel PowerPoint to Pdf Converter | Word/Doc Excel/Xls PowerPoint/PPT To Text Converter | Word/Doc Excel/Xls to Htm Html Converter | Word/Doc Txt to Image Jpg/Jpeg Bmp Tiff Png Converter | Word/Doc to Pdf Converter & Creator Try out; Convert Mysql to Oracle | Convert Mysql to Access | Convert Oracle to Mysql | Convert MSSQL to Oracle | Convert Oracle to Access | More Converters Try out; All to Image Jpg/Jpeg Bmp Tiff Png Converter | Image TIFF Jpeg Text to Pdf Converter Try out; Htm/Html to Image Jpg/Jpeg Converter Try out; Text to Pdf Converter & Creator
See Also: Conversion Software or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS
ALL
MS OFFICE CONVERTER