SpaceObServer.Application.Properties.ExportColumnVisible

<< Click to Display Table of Contents >>

Navigation:  OLE Automation > Application > Properties >

SpaceObServer.Application.Properties.ExportColumnVisible

Description

Use this property to set the visibility of any columns for any type of  the 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:
 

Name / ID

Description

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.

XMLExport

Column visibility for the XMLExport 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 Type 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 Type
The default visibility of the columns is the last used configuration in the SpaceObServer user interface.

In order to configure the visible columns for the list exports you can use the ListColumnVisible property.