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
|
|