Display Name: Table To Excel

Description: Geoprocessing tool that converts a table to a Microsoft Excel file.

Category:

Help URL: http://ems.eppingforestdc.gov.uk/arcgis/rest/directories/arcgisoutput/Test/HMOToExcel_GPServer/Test_HMOToExcel/TableToExcel.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: Input_Table

Data Type: GPFeatureRecordSetLayer
Display Name Input Table
Description: The table to be converted to Microsoft Excel format.
Direction: esriGPParameterDirectionInput
Default Value:
Geometry Type: esriGeometryPoint
HasZ: false
HasM: false
Spatial Reference: 27700  (27700)

Fields:
• OBJECTID_1 ( type: esriFieldTypeOID , alias: OBJECTID_1 )
• CORPUPRN ( type: esriFieldTypeString , alias: CORPUPRN , length: 18 )
• PKEY ( type: esriFieldTypeString , alias: PKEY , length: 12 )
• FULLADDR ( type: esriFieldTypeString , alias: FULLADDR , length: 255 )
• CSTDATE ( type: esriFieldTypeDate , alias: CSTDATE , length: 8 )
• CENDATE ( type: esriFieldTypeDate , alias: CENDATE , length: 8 )
• TYPE_ ( type: esriFieldTypeString , alias: TYPE , length: 4 )
• STATSIZE ( type: esriFieldTypeString , alias: STATSIZE , length: 4 )
• STRUCTUREDESC ( type: esriFieldTypeString , alias: STRUCTUREDESC , length: 30 )
• AGEBANDDESC ( type: esriFieldTypeString , alias: AGEBANDDESC , length: 30 )
• MXNOHOUSEHOLDS ( type: esriFieldTypeSmallInteger , alias: MXNOHOUSEHOLDS )
• MXNOPERSONS ( type: esriFieldTypeSmallInteger , alias: MXNOPERSONS )
• NOROOMSSLEEP ( type: esriFieldTypeSmallInteger , alias: NOROOMSSLEEP )
• NOSELFCONTUNITS ( type: esriFieldTypeSmallInteger , alias: NOSELFCONTUNITS )
• NONONSELFCONTUNITS ( type: esriFieldTypeSmallInteger , alias: NONONSELFCONTUNITS )
• NOROOMSLIVING ( type: esriFieldTypeSmallInteger , alias: NOROOMSLIVING )
• NOSHBATHSHOWER ( type: esriFieldTypeSmallInteger , alias: NOSHBATHSHOWER )
• NOSHTOILETWHB ( type: esriFieldTypeSmallInteger , alias: NOSHTOILETWHB )
• NOSHKITCHENS ( type: esriFieldTypeSmallInteger , alias: NOSHKITCHENS )
• NOSHSINKS ( type: esriFieldTypeSmallInteger , alias: NOSHSINKS )
• LICENCEHOLDER ( type: esriFieldTypeString , alias: LICENCEHOLDER , length: 104 )
• LICENCEHOLDER_ADDRESS ( type: esriFieldTypeString , alias: LICENCEHOLDER_ADDRESS , length: 255 )
• HMO_MANAGER ( type: esriFieldTypeString , alias: HMO_MANAGER , length: 104 )
• HMO_MANAGER_ADDRESS ( type: esriFieldTypeString , alias: HMO_MANAGER_ADDRESS , length: 255 )
• REMARK ( type: esriFieldTypeString , alias: REMARK , length: 30 )
• CONDITIONS ( type: esriFieldTypeString , alias: CONDITIONS , length: 7 )
• LICENCEDURATION ( type: esriFieldTypeSmallInteger , alias: LICENCEDURATION )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: Output_Excel_File

Data Type: GPDataFile
Display Name Output Excel File
Description: The output Microsoft Excel file.
Direction: esriGPParameterDirectionOutput
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: Use_field_alias_as_column_header

Data Type: GPBoolean
Display Name Use field alias as column header
Description: How column names in the output are determined. Unchecked—Column headers will be set using the input's field names. This is the default. Checked—Column headers will be set using the input's field aliases.
Direction: esriGPParameterDirectionInput
Default Value: false
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: Use_domain_and_subtype_description

Data Type: GPBoolean
Display Name Use domain and subtype description
Description: Controls how values from subtype fields or fields with a coded value domain are transferred to the output. Unchecked—All field values will be used as they are stored in the table. This is the default. Checked—For subtype fields, the subtype description will be used. For fields with a coded value domain, the coded value descriptions will be used.
Direction: esriGPParameterDirectionInput
Default Value: false
Parameter Type: esriGPParameterTypeOptional
Category:

Supported Operations:   Submit Job