(Excel) OSS Download String (Alibaba Cloud)

See more Alibaba Cloud OSS Examples

Demonstrates how to download a textual object into a string variable.

The Chilkat S3 functions in the HTTP class are compatible with Alibaba Cloud's OSS service.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Insert your AccessKey ID here:
http.AwsAccessKey = "access-key"

' Insert your AccessKey Secret here:
http.AwsSecretKey = "secret-key"

' To download from a bucket located in a different region, use the endpoint for that region, such as "oss-cn-hangzhou.aliyuncs.com 	"
' See Alibaba Object Storage Service Regions and Endpoints
http.AwsEndpoint = "oss-us-east-1.aliyuncs.com"


bucketName = "chilkat"

objectName = "orchard.json"

' This is the byte representation of the text file downloaded from Aliyun.
' It must be specified to allow Chilkat to correctly interpret the bytes as characters.

charset = "utf-8"


fileContents = http.S3_DownloadString(bucketName,objectName,charset)

If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
Else
    Debug.Print fileContents
    Debug.Print "Success."
End If