Excel.ConnectErrorCellValue interface
Represents the value of a cell containing a #CONNECT! error.
Remarks
Properties
basic |
Represents the value that would be returned by |
basic |
Represents the value that would be returned by |
error |
Represents the type of |
error |
Represents the type of |
type | Represents the type of this cell value. |
Property Details
basicType
Represents the value that would be returned by Range.valueTypes
for a cell with this value.
basicType?: RangeValueType.error | "Error";
Property Value
error | "Error"
Remarks
basicValue
Represents the value that would be returned by Range.values
for a cell with this value. When accessed through a valuesAsJson
property, this string value aligns with the en-US locale. When accessed through a valuesAsJsonLocal
property, this string value aligns with the user's display locale.
basicValue?: "#CONNECT!" | string;
Property Value
"#CONNECT!" | string
Remarks
errorSubType
Represents the type of ConnectErrorCellValue
.
errorSubType?: ConnectErrorCellValueSubType | "Unknown" | "ServiceError" | "ExternalLinks" | "ExternalLinksNonCloudLocation" | "DataTypeNoConnection" | "DataTypeServiceError" | "MissingContent" | "RequestThrottle" | "ExternalLinksFailedToRefresh" | "ExternalLinksAccessFailed" | "ExternalLinksServerError" | "ExternalLinksInvalidRequest" | "ExternalLinksUnAuthenticated" | "ExternalLinksThrottledByHost" | "ExternalLinksFileTooLarge" | "OutdatedLinkedEntity" | "GenericServerError" | "ImageUnableToRetrieve" | "ExternalCodeServiceEnvironmentNotFound" | "ExternalCodeServiceRuntimeNotFound" | "ExternalCodeServiceEnvironmentBadState" | "ExternalCodeServiceRuntimeBadState" | "ExternalCodeServiceComputeResourceNotAvailable" | "PythonPowerQueryDataUploadHasNotStarted" | "ExcelClientMisconfigurationError";
Property Value
Excel.ConnectErrorCellValueSubType | "Unknown" | "ServiceError" | "ExternalLinks" | "ExternalLinksNonCloudLocation" | "DataTypeNoConnection" | "DataTypeServiceError" | "MissingContent" | "RequestThrottle" | "ExternalLinksFailedToRefresh" | "ExternalLinksAccessFailed" | "ExternalLinksServerError" | "ExternalLinksInvalidRequest" | "ExternalLinksUnAuthenticated" | "ExternalLinksThrottledByHost" | "ExternalLinksFileTooLarge" | "OutdatedLinkedEntity" | "GenericServerError" | "ImageUnableToRetrieve" | "ExternalCodeServiceEnvironmentNotFound" | "ExternalCodeServiceRuntimeNotFound" | "ExternalCodeServiceEnvironmentBadState" | "ExternalCodeServiceRuntimeBadState" | "ExternalCodeServiceComputeResourceNotAvailable" | "PythonPowerQueryDataUploadHasNotStarted" | "ExcelClientMisconfigurationError"
Remarks
errorType
Represents the type of ErrorCellValue
.
errorType?: ErrorCellValueType.connect | "Connect";
Property Value
connect | "Connect"
Remarks
type
Represents the type of this cell value.
type: CellValueType.error | "Error";
Property Value
error | "Error"
Remarks
Office Add-ins