ExportColumnVisible

Description

Use this property to set the visibility of any columns for any type of directory tree export.

Syntax

property ExportColumnVisible(ExportType: <String>, InfoType: <String>): <Boolean>;

Parameters

ExportType Defines the type of export for which the column visibility should be changed.

Available list types are:

  • CSVExport: Column visibility for the CSVExport of directory tree.

  • EmailExport: Column visibility for the EmailExport of directory tree.

  • ExcelExport: Column visibility for the ExcelExport of directory tree.

  • HTMLExport: Column visibility for the HTMLExport of directory tree.

  • PDFExport: Column visibility for the PDFExport of directory tree.

  • Print: Column visibility for the Print of directory tree.

  • TextExport: Column visibility for the TextExport of directory tree.

Note

By default the exports are done with the columns configured in the export options of SpaceObServer.

InfoType Defines the column which should be set to visible or invisible. The table of the Information Types values lists all accessible information.

Example

PowerShell:

$SOS.ROOTDirectory = "C:\"
$SOS.ExportColumnVisible("ExcelExport", "Folders") = $False
$SOS.ExcelExport("C:\Temp\SOS\Excelexport.xlsx", "TestSheet %DATE%", $True, $True, $False, $False, "")

VBS:

SOS.ROOTDirectory = "C:\"
SOS.ExportColumnVisible ("ExcelExport", "Folders") = False
SOS.ExcelExport "C:\Temp\SOS\Excelexport.xlsx", "TestSheet %DATE%", True, true, False, False, ""

This will deactivate the “Folders” column before exporting the directory tree to Excel.

Remarks

The visibility can be set for any type of textual export and for any information to export. Find a list of values identifying the textual export types below. Find a list of values identifying the info types at OLE Information Types. The default visibility of the columns is the last used configuration in the SpaceObServer user interface. To configure the visible columns for the list exports you can use the property ListColumnVisible.