These options control the behavior of the Excel converter used by Document Conversion Service. If the workbook, or any spreadsheet in the workbook is password protected and the password is not known, the options are ignored. The settings cannot be applied to a protected workbook or spreadsheet.

Table values in bold text are the default value for that setting. Not all settings have default values; these settings are optional and the appropriate setting in the spreadsheet being printed will be used.

 

Sample Profile

 

<?xml version="1.0" encoding="utf-8"?>

<Profile Type="0"

         DisplayName="TIFF 300dpi Excel Charts First, replace dates "

         Description ="Prints Excel charts, sheets with grid lines.">

  <Settings>

 

    <!-- Print Charts then workbooks, show grid lines -->

    <add Name ="Microsoft.Excel.PrintOut" Value="PrintOutChartsThenWorkbook"/>

    <add Name ="Microsoft.Excel.PageSetup.PrintGridlines" Value="True"/>

 

    <!-- Replace header/footer date fields with <AUTODATE> string -->

    <add Name ="Microsoft.Excel.ReplaceFieldDateWith"

          Value="&lt;AUTODATE&gt;"/>

    <add Name ="Microsoft.Excel.PageSetup.LeftHeader"

          Value="Sheet: &amp;A"/>

 

    <!-- Output file options -->

    <add Name="Devmode settings;Resolution" Value="300"/>

    <add Name="Save;Output File Format" Value="TIFF Multipaged"/>

    ...

    

  </Settings>

</Profile>

 

Code Sample - C#

 

PNDocConvQueueServiceLib.PNDocConvQueueItem item = null;

 

// Create the conversion item

item = new PNDocConvQueueServiceLib.PNDocConvQueueItem();

 

// Set conversion settings

item.Set("Microsoft.Excel.PrintOut""PrintOutChartsThenWorkbook");

item.Set("Microsoft.Excel.PageSetup.PrintGridlines""True");

 

// Replace header/footer date fields with <AUTODATE> string

item.Set("Microsoft.Excel.ReplaceFieldDateWith""<AUTODATE>");

item.Set("Microsoft.Excel.PageSetup.LeftHeader""Sheet: &A");

 

item.Set("Devmode settings;Resolution", "300");

item.Set("Save;Output File Format", "TIFF Multipaged");

...

// convert the file

item.Convert("Microsoft Excel",

             @"C:\Test\Report.xlsx",

             @"C:\Test\Out\ConvertedReport");

 

Code Sample - VB.NET

 

Dim item As PNDocConvQueueServiceLib.IPNDocConvQueueItem

 

 ' Create the conversion item

item = New PNDocConvQueueServiceLib.PNDocConvQueueItem()

 

' Set conversion settings

item.Set("Microsoft.Excel.PrintOut""PrintOutChartsThenWorkbook")

item.Set("Microsoft.Excel.PageSetup.PrintGridlines""True")

 

' Replace header/footer date fields with <AUTODATE> string

item.Set("Microsoft.Excel.ReplaceFieldDateWith""<AUTODATE>")

item.Set("Microsoft.Excel.PageSetup.LeftHeader""Sheet: &A");

 

item.Set("Devmode settings;Resolution""300")

item.Set("Save;Output File Format""TIFF Multipaged")

...

' convert the file

item.Convert("Microsoft Excel", _

             "C:\Test\Report.xlsx", _

             "C:\Test\Out\ConvertedReport")

 

 

Conversion Settings - Excel General  Formatting & Printing Options

Name:

Microsoft.Excel.PrintOut

 

Choose what part of the Excel spreadsheet to print.

The settings

 

For PrintOutChartsOnly, PrintOutChartsThenWorkbook and PrintOutWorkbookThenCharts, the option Microsoft.Excel.PrintOut.PrintEmbeddedChartsFirst controls if embedded charts are printed before or after any chart tabs in the spreadsheet.

 

Values:

PrintOutWorkbookOnly - prints the entire workbook just as Excel does.

 

PrintOutActiveSheetOnly - prints only the last active (selected) sheet in the workbook. This is the selected tab at the time the Excel file was last saved.

 

PrintOutSelectedSheetsOnly - prints only the selected sheets in the workbook. Multiple sheets can be selected using the Ctrl+Left Click with the mouse.

 

PrintOutSheetsWithPrintAreasOnly - prints only sheets that have a print area set.

 

PrintOutChartsOnly - prints any charts tabs and embedded charts in the workbook.

PrintOutChartsThenWorkbook - prints all chart tabs and embedded charts, then prints all sheets in the workbook.

PrintOutWorkbookThenCharts - prints all sheets in the workbook, then prints all chart tabs and embedded charts.

 

For the three options above, embedded charts can be before or after other charts, as specified by the Microsoft.Excel.PrintOut.PrintEmbeddedChartsFirst setting.

 

Name:

Microsoft.Excel.PrintHiddenWorksheets

 

Choose whether to print hidden worksheets or not.

 

Values:

False - do not print hidden worksheets.

True - print hidden worksheets.

 

Name:

Microsoft.Excel.PrintOut.PrintEmbeddedChartsFirst

 

When printing embedded charts, determines if the embedded charts are printed before or after any chart tabs in the spreadsheet. Applies only when Microsoft.Excel.PrintOut is set to print charts.

 

Values:

False - print embedded charts after all other charts.

True - print embedded charts first.

 

Name:

Microsoft.Excel.PrintSheetsRangeByIndex

 

The sheet numbers and ranges to include when printing. Separate each number and range with a comma. For example, "1, 3-5" prints sheet 1 and sheets 3 through 5. Numbers in the range exceeding the sheet count of the source document are ignored.

 

Sheet numbers in the range are for visible sheets unless Microsoft.Excel.PrintHiddenWorksheets is true, then hidden sheets are included.

 

Applies to the Microsoft.Excel.PrintOut options PrintOutWorkbookOnly, PrintOutChartsOnly, PrintOutChartsThenWorkbook and PrintOutWorkbookThenCharts. The range applies to both sheets and charts in the workbook.

 

This print filter can be combined with Microsoft.Excel.PrintSheetsRangeByName, Microsoft.Excel.PrintFirstNSheets, Microsoft.Excel.PrintLastNSheets, and Microsoft.Excel.PrintIfSheetNameMatchesRegex.

 

Values:

The string representing the numbered sheet range.

 

Name:

Microsoft.Excel.PrintSheetsRangeByName

 

The names of the sheets and charts to include when printing, separated with a colon symbol (:) to print multiple sheets. Names not in the worksheet collection are ignored.

 

Applies only to visible sheets unless Microsoft.Excel.PrintHiddenWorksheets is true.

 

Applies to the Microsoft.Excel.PrintOut options PrintOutWorkbookOnly, PrintOutChartsOnly, PrintOutChartsThenWorkbook and PrintOutWorkbookThenCharts. The name selection applies to both sheets and charts in the workbook.

 

This print filter can be combined with Microsoft.Excel.PrintSheetsRangeByIndex, Microsoft.Excel.PrintFirstNSheets, Microsoft.Exce.PrintLastNSheets and Microsoft.Excel.PrintIfSheetNameMatchesRegex.

 

Values:

The string of sheet or chart names, such as "Sheet1:Sheet3:Chart1".

 

Name:

Microsoft.Excel.PrintFirstNSheets

 

Includes the designated number of sheets or charts, starting at the beginning of the workbook. If the workbook has less sheets (tabs) in total than the requested number, all sheets are printed.

 

Applies only to visible sheets unless Microsoft.Excel.PrintHiddenWorksheets is true.

 

Applies to the Microsoft.Excel.PrintOut options PrintOutWorkbookOnly, PrintOutChartsOnly, PrintOutChartsThenWorkbook and PrintOutWorkbookThenCharts. Applies to both sheets and charts in the workbook.

 

This print filter can be combined with Microsoft.Excel.PrintSheetsRangeByName, Microsoft.Excel.PrintSheetsRangeByIndex, Microsoft.Excel.PrintLastNSheets, and Microsoft.Excel.PrintIfSheetNameMatchesRegex.

 

Values:

The number of sheets to print.

 

Name:

Microsoft.Excel.PrintLastNSheets

 

Includes the last designated number of sheets or charts, starting in the middle and going to the end of the workbook. If the workbook has less sheets (tabs) in total than the requested number, all sheets are printed.

 

Applies only to visible sheets unless Microsoft.Excel.PrintHiddenWorksheets is true.

 

Applies to the Microsoft.Excel.PrintOut options PrintOutWorkbookOnly, PrintOutChartsOnly, PrintOutChartsThenWorkbook and PrintOutWorkbookThenCharts. Applies to both sheets and charts in the workbook.

 

This print filter can be combined with Microsoft.Excel.PrintSheetsRangeByName, Microsoft.Excel.PrintSheetsRangeByIndex, Microsoft.Excel.PrintFirstNSheets and Microsoft.Excel.PrintIfSheetNameMatchesRegex.

 

Values:

The number of sheets to print.

 

Name:

Microsoft.Excel.PrintIfSheetNameMatchesRegex

 

Includes the sheet or chart if its name matches the regular expression.

 

Applies only to visible sheets unless Microsoft.Excel.PrintHiddenWorksheets is true.

 

Applies to the Microsoft.Excel.PrintOut options PrintOutWorkbookOnly, PrintOutChartsOnly, PrintOutChartsThenWorkbook and PrintOutWorkbookThenCharts. Applies to both sheets and charts in the workbook.

 

This print filter can be combined with Microsoft.Excel.PrintSheetsRangeByIndex, Microsoft.Excel.PrintSheetsRangeByName, Microsoft.Excel.PrintFirstNSheets and Microsoft.Excel.PrintLastNSheets.

 

Values:

The regular expression to match the sheet name against.

 

Name:

Microsoft.Excel.AutoFit.KeepEmbeddedChartScaling

Applies only when Microsoft.Excel.AutoFitRows and Microsoft.Excel.AutoFitColumns are set and if one or more embedded charts are on the sheet. When True, the width and height of any rows and columns under embedded charts are not auto-adjusted so that the chart does not change shape. Default is True.

Values:

False - autofit all rows or columns, even under embedded charts. This can cause any charts to be squished or stretched.

True - do not autofit rows and columns under embedded charts; charts will keep their original scaling on the sheet.

 

Name:

Microsoft.Excel.Worksheet.IncludeCellFormulasAsComments

 

For any cell that contains a formula, the formula added to that cell as a comment. If the cell has a comment, the formula is inserted with a carriange return before any current comment text. This must be used with Microsoft.Excel.PageSetup.PrintComments set to PrintSheetEnd to include the cell formulas listed by cell reference at the end of each sheet.

 

To append the formula to the cell contents instead of inserting at the beginning, set Microsoft.Excel.Worksheet.PrependCellFormulaToCommentText to False.

 

Values:

False - do not add/update existing comments with the cell formula.

True - add/update existing comment with the cell formula.

 

Name:

Microsoft.Excel.Worksheet.PrependCellFormulaToCommentText

 

When using Microsoft.Excel.Worksheet.IncludeCellFormulasAsComments, the formula is prepended to the beginning of any existing comment text by default. To append the formula to the end of any existing comment text, set this option to False.

 

Values:

False - append the cell formula to the end of any existing comment text.

True - prepend the cell formula to the beginning of any existing comment text.

 

Name:

Microsoft.Excel.Worksheet.PrintOut.IgnorePrintAreas

 

When set to True, any print areas set on the worksheet will be ignored and the entire worksheet printed. Use with Microsoft.Excel.Worksheet.PrintOut.ResetAllPageBreaks to print the worksheet differently from the printing options in the worksheet.

 

Values:

False - prints using any print area set on the worksheet.

True - prints the entire worksheet.

 

Name:

Microsoft.Excel.Worksheet.ShowAllData

 

Makes all rows of any filtered data visible. This setting only applies to filtered data in the worksheet. To show hidden columns or rows use Microsoft.Excel.AutoFitRows and Microsoft.Excel.AutoFitColumns.

 

Values:

False - Leave data filtered (hidden).

True - Show all the data on the worksheet.

 

Name:

Microsoft.Excel.Worksheet.ResetAllPageBreaks

 

Set as True to resets all page breaks on each worksheet. Use with Microsoft.Excel.Worksheet.PrintOut.IgnorePrintAreas to print the worksheet differently from the printing options in the worksheet.

 

Values:

False - Leave page breaks alone.

True - Reset all page breaks.

 

Name:

Microsoft.Excel.AutoFitRows

 

If set to True then the height of the rows in the spreadsheet will be adjusted automatically to fit the contents of the cells. This setting will allow you to show all hidden rows in the worksheet.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.AutoFitRows.Adjust

 

This setting is only applied when Microsoft.Excel.AutoFitRows is set to "True" and allows you to add the height specified (in points) to all rows after they have been auto-fit. The maximum row height allowed in Excel is 409 points. It is not normally needed to add height to each row and adding height to each row can be a time-consuming operation; only use this option if absolutely needed.

 

Values:

String value of the amount, in points, by which to adjust the row height.

 

Name:

Microsoft.Excel.AutoFitColumns

 

If set to True then the width the columns in the spreadsheet will be adjusted to fit the contents of the cells. This setting will allow you to show all hidden columns in the worksheet.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.AutoFitColumns.Adjust

 

This setting is only applied when Microsoft.Excel.AutoFitColumns is set to "True" and allows you to add the width specified (in points) to all columns after they have been auto-fit. The maximum column width allowed in Excel is 255 points. It is not normally needed to add width to each column and adding width to each column can be a time-consuming operation; only use this option if absolutely needed.

 

Values:

String value of the amount, in points, by which to adjust the column width.

 

Name:

Microsoft.Excel.AutoFit.KeepEmbeddedChartScaling

 

Only applies when auto-fit rows and columns is enabled. When set to its default of "True", autofit is not applied to any rows and/or columns that are under any embedded charts on the sheet. All other rows and columns are auto-fit. This allows the embedded charts to maintain the scale they were originally set at when placed on the spreadsheet. If set to "False", the chart will change size depending on the new height and width of the underlying rows and columns.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.UnfreezePanes

 

If the spreadsheeet has any non-scrolling, "frozen" panes, pass "True" to unfreeze them before printing.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.ClearFormatsOnEmptyRowsOnTop

 

Clears the formatting of any empty rows (cells with no data) at the top of the spreadsheet so that only rows with data in them are printed.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.ClearFormatsOnEmptyRowsOnBottom

 

Clears the formatting of any empty rows (cells with no data) at the bottom of the spreadsheet so that only rows with data in them are printed.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.ClearFormatsOnEmptyColumnsOnLeft

 

Clears the formatting of any empty columns (cells with no data) on the left hand side of the spreadsheet so that only columns with data in them are printed.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.ClearFormatsOnEmptyColumnsOnRight

 

Clears the formatting of any empty columns (cells with no data) on the right hand side of the spreadsheet so that only columns with data in them are printed.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.RemoveBackgroundColors

 

Clears the background colors and fills for all cells. Leaves text color and borders unchanged.

 

Note: This does not apply to cells that have conditional formatting applied.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.SetAllTextAsBlack

 

Sets all text to black.

 

Note: This does not apply to cells that have conditional formatting applied.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.ClearTableStyle

 

Clears the table styling from any columns or rows in the spreadsheet. Leaves the cell data, formatting and formulas in place. This can be a time-consuming operation as the table formatting is copied to each cell; only use this option if absolutely needed. To do the same but also remove the formatting, use Microsoft.Excel.ClearTableStyleAndFormatting.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.ClearTableStyleAndFormatting

 

Clears the table styling and any table formatting from any columns or rows in the spreadsheet. Leaves the cell data and formulas in place.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.ClearAllConditionalFormatting

 

Clears all conditional formatting applied to any cells. This includes removing background colors and text styling, color scales, data bars and icon sets.

 

Note: This does not apply to any spreadsheet that is protected or shared.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.TrackChanges.HighlightChangesOnScreen

 

If Track Changes has been enabled for the workbook, any cell on any spreadsheet that has been changed will be highlighted.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.TrackChanges.ListChangesOnNewSheet

 

If Track Changes has been enabled for the workbook, setting this to True will create a new temporary, protected spreadsheet that lists all of changes made to the workbook. If not using the English version of Excel, Microsoft.Excel.TrackChanges.ExcelTrackChangesWhoParameter will also need to be set.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.TrackChanges.ExcelTrackChangesWhoParameter

 

When using an Office installation in a language other than English, this option  must specify the word "Everyone" in that that language to list the tracked changesfor all users. The default for this setting is "Everyone". The 5 most common languages are listed below, or you can find the needed parameter on the Hightlight Changes dialog in your version of Excel. The English version is shown below.

 

 

Values:

English - Everyone

French - Tous, Tout le monde

Italian - Tutti

German - Jeder

Spanish - Todos

 

Conversion Settings - Excel Page Setup Printing Options

Name:

Microsoft.Excel.PageSetup.AlignMarginsHeaderFooter

 

Have Excel align the header and the footer with the margins set in the page setup options.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.BlackAndWhite

 

Print the Excel document in black and white.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.BottomMargin

 

Set the size of the bottom margin in points.

 

Values:

String value of the desired margin height.

 

Name:

Microsoft.Excel.PageSetup.CenterFooter

 

The text to display in the center footer area of the worksheet.

 

Values:

String value of the text to display.

 

Name:

Microsoft.Excel.PageSetup.CenterHeader

 

The text to display in the center header area of the worksheet.

 

Values:

String value of the text to display.

 

Name:

Microsoft.Excel.PageSetup.CenterHorizontally

 

Center the worksheet horizontally on the page when printed.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.CenterVertically

 

Center the worksheet vertically on the page when printed.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.DifferentFirstPageHeaderFooter

 

If this is True a different header or footer is used for the first page of the worksheet (applies to Office 2007 or higher).

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.Draft

 

Prints the worksheet without graphics when set to True.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.FirstPageNumber

 

Sets the first page number that will be used when this sheet is printed.

 

Values:

String value of the page number to start with.

 

Name:

Microsoft.Excel.PageSetup.FitToPagesTall

 

Set the number of pages tall the worksheet will scale to when printed. Ignored when Microsoft.Excel.PageSetup.Zoom is set to True.

 

Values:

String value of the number of pages tall to use or "False" to use the scaling set in the Microsoft.Excel.PageSetup.FitToPagesWide setting.

 

Name:

Microsoft.Excel.PageSetup.FitToPagesWide

 

Set the number of pages wide the worksheet will scale to when printed. Ignored when Microsoft.Excel.PageSetup.Zoom is set to True.

 

Values:

String value of the number of pages wide to use or "False" to use the scaling set in the Microsoft.Excel.PageSetup.FitToPagesTall setting.

 

Name:

Microsoft.Excel.PageSetup.FooterMargin

 

Sets the distance, in points, from the bottom of the page to the footer.

 

Values:

String value of the desired margin height.

 

Name:

Microsoft.Excel.PageSetup.HeaderMargin

 

Sets the distance, in points, from the top of the page to the header.

 

Values:

String value of the desired margin height.

 

Name:

Microsoft.Excel.PageSetup.LeftFooter

 

The text to display in the left footer area of the worksheet.

 

Values:

String value of the text to display.

 

Name:

Microsoft.Excel.PageSetup.LeftHeader

 

The text to display in the left header area of the worksheet.

 

Values:

String value of the text to display.

 

Name:

Microsoft.Excel.PageSetup.LeftMargin

 

Set the size of the left margin in points.

 

Values:

String value of the desired margin height.

 

Name:

Microsoft.Excel.PageSetup.OddAndEvenPagesHeaderFooter

 

Set to True if different headers and footers have been set for odd-numbered and even-numbered pages.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.Order

 

Choose the page order when printing multiple spreadsheet pages per page.

 

Values:

DownThenOver - print the spreadsheet pages down then across the page.

OverThenDown - print the spreadsheet pages across the page, then down.

 

Name:

Microsoft.Excel.PageSetup.Orientation

 

Choose the orientation of the Excel spreadsheet.

 

Values:

Landscape

Portrait

 

Name:

Microsoft.Excel.PageSetup.PaperSize

 

Sets the size of the paper the worksheet will be printed on.

 

Values:

Paper10x14 - 10 in. x 14 in.

Paper11x17 - 11 in. x 17 in.

PaperA3 - A3 (297 mm x 420 mm)

PaperA4 - A4 (210 mm x 297 mm)

PaperA4Small - A4 Small (210 mm x 297 mm)

PaperA5 - A5 (148 mm x 210 mm)

PaperB4 - B4 (257 mm x 364 mm)

PaperB5 - B5 (182 mm x 257 mm)

PaperCsheet - C size sheet

PaperDsheet - D size sheet

PaperEnvelope10 - Envelope #10 (4-1/8 in. x 9-1/2 in.)

PaperEnvelope11 - Envelope #11 (4-1/2 in. x 10-3/8 in.)

PaperEnvelope12 - Envelope #12 (4-1/2 in. x 11 in.)

PaperEnvelope14 - Envelope #14 (5 in. x 11-1/2 in.)

PaperEnvelope9 - Envelope #9 (3-7/8 in. x 8-7/8 in.)

PaperEnvelopeB4 - Envelope B4 (250 mm x 353 mm)

PaperEnvelopeB5 - Envelope B5 (176 mm x 250 mm)

PaperEnvelopeB6 - Envelope B6 (176 mm x 125 mm)

PaperEnvelopeC3 - Envelope C3 (324 mm x 458 mm)

PaperEnvelopeC4 - Envelope C4 (229 mm x 324 mm)

PaperEnvelopeC5 - Envelope C5 (162 mm x 229 mm)

PaperEnvelopeC6 - Envelope C6 (114 mm x 162 mm)

PaperEnvelopeC65 - Envelope C65 (114 mm x 229 mm)

PaperEnvelopeDL - Envelope DL (110 mm x 220 mm)

PaperEnvelopeItaly - Envelope (110 mm x 230 mm)

PaperEnvelopeMonarch - Envelope Monarch (3-7/8 in. x 7-1/2 in.)

PaperEnvelopePersonal - Envelope (3-5/8 in. x 6-1/2 in.)

PaperEsheet - E size sheet

PaperExecutive - Executive (7-1/2 in. x 10-1/2 in.)

PaperFanfoldLegalGerman - German Legal Fanfold (8-1/2 in. x 12 in.)

PaperFanfoldStdGerman - German Legal Fanfold (8-1/2 in. x 13 in.)

PaperFanfoldUS - U.S. Standard Fanfold (14-7/8 in. x 11 in.)

PaperFolio - Folio (8-1/2 in. x 13 in.)

PaperLedger - Ledger (17 in. x 11 in.)

PaperLegal - Legal (8-1/2 in. x 14 in.)

PaperLetter - Letter (8-1/2 in. x 11 in.)

PaperLetterSmall - Letter Small (8-1/2 in. x 11 in.)

PaperNote - Note (8-1/2 in. x 11 in.)

PaperQuarto - Quarto (215 mm x 275 mm)

PaperStatement - Statement (5-1/2 in. x 8-1/2 in.)

PaperTabloid - Tabloid (11 in. x 17 in.)

 

Name:

Microsoft.Excel.PageSetup.PrintArea

 

Sets the range to be printed, as a string using Excel's A1-style references.

 

Values:

String containing the print area. Pass an empty string to print the entire worksheet.

 

Name:

Microsoft.Excel.PageSetup.PrintComments

 

Determines where any comments in the worksheet are printed.

 

Values:

PrintSheetEnd - print the comments as notes at the end of the worksheet.

PrintInPlace - comments are printed in-place in the worksheet as pop-up notes.

PrintNoComments - comments are not printed.

 

Name:

Microsoft.Excel.PageSetup.PrintErrors

 

Set the type of print error displayed.

 

Values:

PrintErrorsDisplayed - display all print errors.

PrintErrorsBlank - print errors are blank.

PrintErrorsDash - display print errors as dashes.

PrintErrorsNA - display print errors as not available.

 

Name:

Microsoft.Excel.PageSetup.PrintGridlines

 

If set to True then grid lines will be printed on each spreadsheet.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.PrintHeadings

 

If set to True then column and row headings will be printed on each spreadsheet.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.PrintNotes

 

Set to True to print cell notes as end notes with the worksheet.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.PrintQuality

 

Sets the print quality, or DPI, of the worksheet. This is different from the DevMode settings;Resolution setting in the Devmode settings section.

 

Values:

1200, 720, 600, 400, 360, 300, 240, 200, 150, 120, 100, 75, 60, 50

 

Name:

Microsoft.Excel.PageSetup.PrintTitleColumns

 

Sets the columns that contain the cells to be repeated on the left side of each page as a string using Excel's A1-style references.

 

Values:

String containing the columns to use as title columns. Pass an empty string to turn off title columns.

 

Name:

Microsoft.Excel.PageSetup.PrintTitleRows

 

Sets the rows that contain the cells to be repeated on the top of each page as a string using Excel's A1-style references.

 

Values:

String containing the rows use as title rows. Pass an empty string to turn off title rows.

 

Name:

Microsoft.Excel.PageSetup.RightFooter

 

The text to display in the right footer area of the worksheet.

 

Values:

String value of the text to display.

 

Name:

Microsoft.Excel.PageSetup.RightHeader

 

The text to display in the right header area of the worksheet.

 

Values:

String value of the text to display.

 

Name:

Microsoft.Excel.PageSetup.RightMargin

 

Set the size of the left margin in points.

 

Values:

String value of the desired margin width.

 

Name:

Microsoft.Excel.PageSetup.ScaleWithDocHeaderFooter

 

If set to True then the header and footer will be scaled with the document when the size of the document changes.

 

Values:

String value "True" or "False".

 

Name:

Microsoft.Excel.PageSetup.TopMargin

 

Set the size of the top margin in points.

 

Values:

String value of the desired margin height.

 

Name:

Microsoft.Excel.PageSetup.Zoom

 

Sets a percentage (between 10 and 400 percent) by which the worksheet will be scaled when printed.

 

Values:

String value representing the zoom percentage, or "False" to use the Microsoft.Excel.PageSetup.FitToPagesTall and Microsoft.Excel.PageSetup.FitToPagesWide properties instead.

 

 

Conversion Settings - Excel Field Replacement

Name:

Microsoft.Excel.ReplaceFieldDateWith

 

Replaces any DATE fields in the header and footer in the Excel document with the provided string.

 

Values:

The string value to place in the field.

 

Name:

Microsoft.Excel.ReplaceFieldTimeWith

 

Replaces any TIME fields in the header and footer in the Excel document with the provided string.

 

Values:

The string value to place in the field.

 

Name:

Microsoft.Excel.ReplaceFieldFileNameWith

 

Replaces any FILENAME fields in the header and footer in the Excel document with the provided string.

 

Values:

A string value to replace the auto file name field.

 

Name:

Microsoft.Excel.ReplaceFormulasWithAutoDateAndTimeAsString

 

Replaces any cells containing a formula with the functions TODAY() and NOW() with the provided string. This will replace the entire cell formula.

 

Values:

A string value to display as the cell contents.

 

 

Conversion Settings - Document Protection

Name:

Microsoft.Excel.UnprotectPassword

 

The password is used to unprotect the Excel document and allow changes. This password is passed as clear text and is visible to anyone.

 

Values:

A string value containing the password.

 

Name:

Microsoft.Excel.OpenPassword

 

The password is used to open a password-protected Excel document. This password is passed as clear text and is visible to anyone.

 

Values:

A string value containing the password.

 

Name:

Microsoft.Excel.WritePassword

 

The password is used to allow saving changes to the Excel document. This password is passed as clear text and is visible to anyone.

 

Values:

A string value containing the password.

 

Name:

Microsoft.Excel.RemoveDocumentProtection

 

Does not apply to Excel 2013 and later versions.

 

Temporarily remove any workbook or spreadsheet protection that may be set on the document. This allows Excel printing and formatting options to be applied.

 

Values:

String value "True" or "False". Default is True for Excel 2010 and previous versions. Ignored for Office 2013 and later.

 

Name:

Microsoft.Excel.SkipFileValidation

 

Office File Validation is a security feature added starting with Microsoft Office 2010.  This feature checks Office files created with older versions to ensure they were safe to open before actually opening them.

Files can be marked as invalid if they are corrupt or contain malicious code. Unfortunately, this can also mean that files created previous versions of Office can mistakenly be tagged as invalid when they are not.

You can use this setting to disable this feature.

 

We do not recommend enabling this feature; you do so at your own risk. Use with caution and only disable if you know and trust the source of the Excel files.

 

Values:

False - Files are always validated upon opening.

True - Skip file validation upon opening. This setting is not recommended.

 

Header and Footer Formatting Codes

The following formatting codes are used to customize the header and footer contents of the spreadsheet with page numbers, the date, the name of the sheet, or the name and path of the file taken from the Excel file being converted.

Applies to these settings:

Microsoft.Excel.PageSetup.LeftHeader

Microsoft.Excel.PageSetup.CenterHeader

Microsoft.Excel.PageSetup.RightHeader

Microsoft.Excel.PageSetup.LeftFooter

Microsoft.Excel.PageSetup.CenterFooter

Microsoft.Excel.PageSetup.RightFooter

 

These formatting codes are applied to the header and footer contents after any auto date, time or filename replacement is applied from the settings Microsoft.Excel.ReplaceFieldDateWith, Microsoft.Excel.ReplaceFieldTimeWith, and Microsoft.Excel.ReplaceFieldFileNameWith.

This means that if you use an autodate, autotime or file name formatting code in a custom header, you will get the autodate, autotime or file name in the header or footer, and not the replacement string.

Header and Footer Formatting Codes

&P

Current page number

&N

Number of pages

&D

Auto date

&T

Auto time

&Z&F

Path to file

&F

File name

&A

Sheet name