VeryDOC Knowledge Base

[VeryDOC Release Notes] VeryDOC Releases a new version of doc2any SDK today

2015/02/252015/02/25

Hi,

I ultimately made it working and converting on server 2012.

However i have two conversion issues:

1. some xls/xlsx files with big amount of columns give as an output pdf with the columns printed on multiple pages. My users want to have all columns fit single PDF page.

2. Some users sent binary Excel files (XLSB) - converter gives an error.

Please advise.

Customer
---------------------------------
Thanks for your information, just a question, how did you got it working on Windows Server 2012?

1. You can choose A3 landscape paper size when convert xls/xlsx to PDF file, the output PDF file will be good to fit all excel columns.
2. Our product is not support XLSB format, we will add the support for XLSB for you asap.

VeryDOC
---------------------------------
I found out on 2012 server by default windows service cannot communicate with office com components. I made DCOM configuration for Word and Excel to allow windows service user to launch office components. Then some system folders required additional security setting for the windows service user.

I spent many hours drilling ProcMonitor output to find out this.

What about xls/xlsx with big number of columns? Landscape not always a case. It could not be enough in some cases. Is there any parameter (something like fit_to_page or so) to always fit the PDF page regardless of column numbers?

Customer
---------------------------------
There is no fit_to_page option, you need to choose a bigger paper size to fit page contents, such as A0 paper size.

VeryDOC
---------------------------------
Another question: there is a "lib" folder in "doc2any" with 7z and some more files. What that files for? Do i have to deploy them?

Customer
---------------------------------
The files in "lib" folder are used to parse DOC, DOCX, XLS, XLSX formats without depend on MS Office and OpenOffice.

They will do the conversion work without MS Office and OpenOffice installed. If you will install MS Office into your system for conversion, you needn't the files in "lib" folder.

VeryDOC
---------------------------------

VeryDOC has upgrade doc2any SDK today, please download new version from following URL,

https://www.verydoc.com/doc-to-any.html
https://www.verydoc.com/doc2any_sdk.zip

The new version of doc2any SDK has following new features,

1. Support XLSB format as input format,
2. Support ODP format as input format,
3. Add "-fitpageforoffice" option to scale Excel Sheets' Contents to fit Printer's paper wide,

Please run following command line to test the new version,

..\bin\example_vc_test.exe -printerpaper 3000x3000pt -useoffice 1 -useprinter example.xls _example_1.pdf

..\bin\example_vc_test.exe -printerpaper 612x792pt -fitpageforoffice -useoffice 1 -useprinter example.xls _example_2.pdf

..\bin\example_vc_test.exe -printerpaper 612x792pt -fitpageforoffice -useoffice 1 -useprinter example.xlsb _example_xlsb_2.pdf

..\bin\example_vc_test.exe test_training.odp test_training.odp.pdf

You can use "-printerpaper 612x792pt -fitpageforoffice" options to scale Excel contents to fit Letter paper size automatically.

VeryDOC

See Also:

VeryPDFComRunCmd COM does allow you to call MS Office and Any EXE application from ASP, PHP, C#, .NET etc. program languages.
https://www.verydoc.com/blog/verydoc-release-notes-verydoc-releases-an-exe-com-of-verypdfcomruncmd-exe-today-verypdf-exe-com-does-allow-you-to-call-ms-office-and-any-exe-application-from-asp-php-c-net-etc-program-languag.html

VeryDOC DOC to Any Converter Command Line v3.5 Release Notes. Convert Word to PDF without Office and OpenOffice.
https://www.verydoc.com/blog/verydoc-doc-to-any-converter-command-line-v3-5-release-notes-convert-word-to-pdf-without-office-and-openoffice.html

DOC to Any Converter

Converting Office Documents to PDF with the Office Interop Assemblies

2015/02/19

Office, SharePoint 2010, SharePoint 2013, Office Interop Assemblies, PDF Conversion, SharePoint 2010, SharePoint 2013

If you want to convert a document to PDF you can save it as PDF (File -> Export -> PDF). But what if you have a lot of documents you want to convert to PDF. Then the Office Interop Assemblies could help you. This blog explains how you could use the Office Interop Assemblies to convert Word, PowerPoint and Excel files to PDF.

Prerequisites:
– Microsoft Office needs to be installed
– Some dev skills

This is not something you would like to use on a large production environment. But if you are in need of a onetime solution this could be a solution. Always keep in mind that you backup your Office documents and check the results after converting.

Word

Add Assembly reference to project: Microsoft.Office.Interop.Word

Code:

var wordApp = new Microsoft.Office.Interop.Word.Application();

var wordDocument = wordApp.Documents.Open(@"C:\WordDocument.docx");

wordDocument.ExportAsFixedFormat(@"C:\NewPDFFile.PDF", Microsoft.Office.Interop.Word.WdExportFormat.wdExportFormatPDF);

wordDocument.Close(Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges,

Microsoft.Office.Interop.Word.WdOriginalFormat.wdOriginalDocumentFormat,

false); //Close document

wordApp.Quit(); //Important: When you forget this Word keeps running in the background

PowerPoint

Add Assembly reference to project: Microsoft.Office.Interop.PowerPoint

Code:

var powerpointApp = new Microsoft.Office.Interop.PowerPoint.Application();

var powerpointDocument = powerpointApp.Presentations.Open(@"C:\PowerPoint.pptx",

Microsoft.Office.Core.MsoTriState.msoTrue, //ReadOnly

Microsoft.Office.Core.MsoTriState.msoFalse, //Untitled

Microsoft.Office.Core.MsoTriState.msoFalse); //Window not visible during converting

powerpointDocument.ExportAsFixedFormat(@"C:\NewPDFFile.pdf",

Microsoft.Office.Interop.PowerPoint.PpFixedFormatType.ppFixedFormatTypePDF);

powerpointDocument.Close(); //Close document

powerpointApp.Quit(); //Important: When you forget this PowerPoint keeps running in the background

Excel

Add assembly reference to project: Microsoft.Office.Interop.Excel

Code:

var excelApp = new Microsoft.Office.Interop.Excel.Application();

var excelDocument = excelApp.Workbooks.Open(@"C:\ExcelDocument.xlsx");

excelDocument.ExportAsFixedFormat(Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF,

@"C:\NewPDFFile.pdf");

excelDocument.Close(false, "", false); //Close document

excelApp.Quit(); //Important: When you forget this Excel keeps running in the background

VeryDOC has "DOC to Any Converter Command Line" and "DOC to Any Converter SDK/COM" products, these products are support Office Interop Assemblies and other technologies, you can use "DOC to Any Converter" Command Line or SDK/COM to convert office files to PDF files with or without MS Office installed in your system,

https://www.verydoc.com/doc-to-any.html

You can call "DOC to Any Converter Command Line" or "DOC to Any Converter SDK/COM" product to convert office files to PDF files from C#, PHP, ASP, ASP.NET, Javascript, VBScript, C++, VB, Delphi, FoxPro, Java, etc. program languages,

https://www.verydoc.com/blog/verydoc-doc-to-any-converter-command-line-v3-5-release-notes-convert-word-to-pdf-without-office-and-openoffice.html

https://www.verydoc.com/blog/verydoc-release-notes-verydoc-releases-an-exe-com-of-verypdfcomruncmd-exe-today-verypdf-exe-com-does-allow-you-to-call-ms-office-and-any-exe-application-from-asp-php-c-net-etc-program-languag.html

https://www.verydoc.com/blog/how-to-call-doc2any-exe-from-php-source-code.html

PDF to Vector Converter

Do you have an API software solution we could try in order to convert our PDF’s to a clean PS or Postscript file?

2015/02/18

Hi there,

We are a printing solutions company who has their own bespoke software for printing our documents.

We are considering converting all of our documents to a more viewable PDF format.

However for printing we are looking for a PostScript solution, do you have an API software solution we could try in order to convert our PDF's to a clean PS file.

We have used GhostScript in the past and for many documents it produced files which printed too slowly for our needs.

If you could let me know I would be most grateful.

Thanks.
Customer
----------------------------------------------

Please download PDF to Vector Converter Command Line from following web page to try, you can use PDF to Vector Converter Command Line to convert PDF file to PS file quickly,

https://www.verydoc.com/pdf-to-vector.html
https://www.verydoc.com/pdf2vec_cmd.zip

for example,

pdf2vec.exe -psmode 0 C:\in.pdf C:\out.ps
pdf2vec.exe -psmode 1 C:\in.pdf C:\out.ps
pdf2vec.exe -psmode 2 C:\in.pdf C:\out.ps

VeryDOC
----------------------------------------------
Thanks for this.

My initial testing is showing some good output.

To give you some background we produce PDF output but have limited print options unless we convert the files to PS, we still need to use PCL drivers.

So far this solution looks good.

I have a few questions.

1. Can we select a number of pages (a page range) rather than produce the entire PDF to PS?

2. It seems as though using pdf2vec.exe -psmode 2 gives us the best output -psmode 0 seems to be producing huge PS and the output is erratic when sent to a printer and -psmode 1 seems to produce just one page does this sound correct for what we are trying to do?

Thanks so far for your help.

Best regards
Customer
----------------------------------------------
>>1. Can we select a number of pages (a page range) rather than produce the entire PDF to PS?

-firstpage <int> : first page to print, from 1 to max page
-lastpage <int> : last page to print, from 1 to max page

You can run following command line to select a number of pages (a page range) from PDF file to PS file,

pdf2vec.exe -psmode 0 -firstpage 10 -lastpage 20 E:\pagetest.pdf E:\pagetest.ps

pdf2vec.exe -psmode 1 -firstpage 10 -lastpage 20 E:\pagetest.pdf E:\pagetest.ps

pdf2vec.exe -psmode 2 -firstpage 10 -lastpage 20 E:\pagetest.pdf E:\pagetest.ps

>>2. It seems as though using pdf2vec.exe -psmode 2 gives us the best output psmode 0 seems to be producing huge PS and the output is erratic when sent to a printer and psmode 1 seems to produce just one page does this sound correct for what we are trying to do?

Yes, "-psmode 1" does create a PS file for each PDF page, you can write a simple script to send these PS files to target printer one by one.

"-psmode 0" and "-psmode 2" are all can convert PDF files to PS files quickly and properly, they are using different render technologies to convert PDF files to Postscript files.

You can test the output PS files carefully by these options, if you need any assistance, please feel free to let us know, we will assist you asap.

VeryDOC

PDF Compressor

How to compress, shrink and reduce PDF files? Reducing PDF file size for Email attachment.

2015/02/04

Hello,

Can you offer a special version of the pdf-compressor-software where the grade of compression is selectable and where the resulting file size is shown before the compression-process is executed?!

And do you have a pdf-software that makes it possible to increase the contrast of a scanned document because when I scan a document the background of the resulting site is usually (divergent from the original-document; using a HP-Scanner) not really white (as the original-document) it is more likely light grey?!

Best regards,
Customer
--------------------------------------------------------

How do I reduce/compress PDF file size from scanned document

Hi Guys,

I just bought a HP M1217nfw MFP, being a real estate agent, where I have to scan 20 pages per document, and the scan function with 75 dpi and output to a pdf document gives me a file of 14 Mbytes. There is no way i can send this via email. I used to be able to scan 20 pages with the HP Officejet into a much smaller file.

Any help would be appreciated on how i can get small sized scanned files. My alternative is to take back the printer to Staples

Thanks so much for your help
Customer
--------------------------------------------------------

Please download "VeryDOC PDF Compressor Command Line" from following web page to try,

https://www.verydoc.com/pdfcompressor.html
https://www.verydoc.com/url/pdfcompressor.zip
https://www.verydoc.com/pdfcompressor-cmd.html

You can use "VeryDOC PDF Compressor Command Line" to compress PDF files easily by following command lines,

pdfcompressor.exe -ci jpg -cidown -cidownres 50 -gi jpg -gidown -gidownres 50 -mi fax -midown -midownres 50 C:\in.pdf C:\out.pdf

pdfcompressor.exe -jbig2 -jpx C:\in.pdf C:\out.pdf

"VeryDOC PDF Compressor Command Line" does show compression ratio information after conversion, if you encounter any problem with this version, please feel free to let us know.

VeryDOC PDF Compressor does compress PDF file size. VeryDOC PDF Compressor component serves the purpose of optimizing PDF documents specifically in preparation for certain applications such as web-based publication, data exchange or printing.

VeryDOC

PCL, PS, PDF Page Counter

PDF Parser in Spool File Page Counter SDK is not parse paper size (A4, A3 etc.) from PDF file correctly?

2015/01/062015/01/06

Hello support,

We are testing Spool File Page Counter SDK, but parser for PDF for recognizing format (A4, A3 etc.) is not working (also for test file from directory sample).

We would like to use this SDK also for parser PDF files directly.

Thank you for the solution, we will buy it developer license after solving this problem.

Thank you for any solution.

Lower priority issue: Canon PCL6 drivers are not supported, is there any way (some tested drivers for Canon) which are supported for parser by this SDK?

Thank you.
Customer
------------------------------------------------

We apologize for any inconvenience this may have caused to you, can you please send to us your sample PDF file and Canon PCL6 file? after we checked your sample files, we will figure out a solution to you asap.

btw, we have tried to parse "test_colors.pdf" file in "sample" folder, everything is fine,

vc_test.exe E:\ps-and-pcl-info-sdk\bin\sample\test_colors.pdf
=============================
Page 1 is [Color]
Page 2 is [ Gray]
Page 3 is [ BW]
=============================
Statistics: bwPageCount=2, colorPageCount=1
=======================================
File = 'E:\ps-and-pcl-info-sdk\bin\sample\test_colors.pdf'
Return Value = TRUE
bIsRenderToPDF = 1
bwPageCount = 2
colorPageCount = 1
copyCount = 1
PageWidth = 0
PageHeight = 0
PaperSizeName = ''

VeryPDF
------------------------------------------------
Hello support,

PDF PaperSizeName issue:

Column PaperWidth, Paper Height, and PaperSizeName are not working. For example in PaperSizeName we need for example A4 format for A4 pdf.

Test file is attached.

Thank you.
Customer
------------------------------------------------
Canon issue:

prn file and result is attached.

Notice: this is probably something special in Canon PCL6 driver, because, if this status page is sent to other vendor than Canon, the result is the same - 563 BW pages are printed.

Thank you
Customer
------------------------------------------------
Please download the latest version from following URL to try again, you can use this version to extract paper size from PDF file properly,

https://www.verydoc.com/ps-and-pcl-info-sdk.zip

For example,

D:\downloads2>E:\ps-and-pcl-info-sdk\bin\vc_test.exe D:\downloads\ricoh.pdf
=============================
Page 1 is [Color]
Page 2 is [Color]
Page 3 is [Color]
Page 4 is [Color]
Page 5 is [Color]
Page 6 is [Color]
=============================
Statistics: bwPageCount=0, colorPageCount=6
=======================================
File = 'D:\downloads\ricoh.pdf'
Return Value = TRUE
bIsRenderToPDF = 1
bwPageCount = 0
colorPageCount = 6
copyCount = 1
PageWidth = 5960
PageHeight = 8400
PaperSizeName = ''

VeryPDF
------------------------------------------------
Hello support,

Thank you for this version, PageWidth and PageHeight are working correctly.

Best regards
Customer

February 2025
M	T	W	T	F	S	S
« Sep
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28