Go API Client for Aspose.Cells Cloud

Aspose.Cells Cloud SDK for Go empowers your Go applications to connect with excel document formats. The APIs let engineers read, convert, build, alter and control the substance of the excel document formats without any office software installed on the machine.

Excel® File Manipulation in the Cloud

Create Excel files from scratch via API or Smart Markers.
Load, process & convert Excel files via Cloud SDK.
Add, update or delete worksheet, charts, pictures, shapes, hyperlinks & validations.
Add or remove cells area for conditional formatting from Excel worksheets.
Insert or delete, horizontal or vertical page breaks.
Add ListObject or convert ListObjects to a range of cells.
Summarize data with Pivot Tables & Excel charts.
Apply custom criteria to list filters of various types.
Get, update, show or hide chart legend & titles.
Manipulate page setup, header & footer.
Create, update, fetch or delete document properties.
Fetch the required shape from worksheet.
Leverage the power of named ranges.

Feature & Enhancements in Version 23.12

Full list of issues covering all changes in this release:

Conversion APIs add region parameter.
Protection APIs add region parameter.
Assemble data API adds region parameter.
Merge files API adds region parameter.
Split files API adds region parameter.
Import data API adds region parameter.
Watermark API adds region parameter.
Clear object API adds region parameter.
Reverse data API adds region parameter.
Rotate data API adds region parameter.

Read & Write Spreadsheet Formats

Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML

Save Spreadsheets As

Microsoft Excel: XLS, XLSX, XLSB OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML Fixed Layout: PDF, XPS Images: PNG, JPG, TIFF, SVG Markdown: MD Other: DIF

Read Other Formats

SXC, FODS

Get Started with Aspose.Cells Cloud SDK for Go

First, create an account at Aspose for Cloud and get your application information. Then, follow these steps.

Download the code and Add/Modify your application and refer to cells_cloud_test.go.
If you want to download Go Module,please use import "github.com/aspose-cells-cloud/aspose-cells-cloud-go/v20" in your code.

func GetDocumentCircleAnnotations() (CircleAnnotationsResponse, *http.Response, error) {
	remoteFolder := "TestData/In"
	localFolder := "testdata/"
	localName := "Book1.xlsx"
	remoteName := "Book1.xlsx"
	instance := asposecellscloud.NewCellsApiService(os.Getenv("ProductClientId"), os.Getenv("ProductClientSecret"), "https://api.aspose.cloud", "v3.0")

	localNameRequest := new(asposecellscloud.UploadFileRequest)
	localNameRequest.UploadFiles = make(map[string]string)
	localNameRequest.UploadFiles[localName] = localFolder + localName
	localNameRequest.Path = remoteFolder + "/" + remoteName
	localNameRequest.StorageName = ""
	instance.UploadFile(localNameRequest)
}

Add Worksheet to Excel File via Go

    remoteFolder := "TestData/In"
  
    localName := "Book1.xlsx"
    remoteName := "Book1.xlsx"

    localNameRequest := new(UploadFileRequest)
    localNameRequest.UploadFiles = make(map[string]string) 
    localNameRequest.UploadFiles[localName] =  GetBaseTest().localTestDataFolder  + localName
    localNameRequest.Path = remoteFolder + "/" + remoteName 
    localNameRequest.StorageName =""
    GetBaseTest().CellsApi.UploadFile(localNameRequest )
 

    request := new (PutAddNewWorksheetRequest)
    request.Name =         remoteName    
    request.SheetName =         "Sheet1"    
    request.Position =  int64(0)        
    request.Sheettype =         "VB"    
    request.Folder =         remoteFolder    
    request.StorageName =         ""    
    _, httpResponse, err := GetBaseTest().CellsApi.PutAddNewWorksheet(request)
	if err != nil {
		t.Error(err)
	} else if httpResponse.StatusCode < 200 || httpResponse.StatusCode > 299 {
		t.Fail()
	} else {
		fmt.Printf("%d\tTestWorksheetController_PutAddNewWorksheet \n", GetBaseTest().GetTestNumber())
	}

Using Go to Convert an Excel File in the Cloud

// Upload source file to aspose cloud storage
	remoteFolder := "TestData/In"
	localFolder := "testdata/"
	localName := "Book1.xlsx"
	remoteName := "Book1.xlsx"
	instance := asposecellscloud.NewCellsApiService(os.Getenv("ProductClientId"), os.Getenv("ProductClientSecret"), "https://api.aspose.cloud", "v3.0")

	localNameRequest := new(asposecellscloud.UploadFileRequest)
	localNameRequest.UploadFiles = make(map[string]string)
	localNameRequest.UploadFiles[localName] = localFolder + localName
	localNameRequest.Path = remoteFolder + "/" + remoteName
	localNameRequest.StorageName = ""
	instance.UploadFile(localNameRequest)

	newfilename := "TestData/OutResult/PostExcelSaveAs.pdf"

	var saveOptions = new(asposecellscloud.PdfSaveOptions)
	saveOptions.SaveFormat = "pdf"

	request := new(asposecellscloud.PostWorkbookSaveAsRequest)
	request.Name = remoteName
	request.Newfilename = newfilename
	request.SaveOptions = saveOptions
	request.Folder = remoteFolder
	_, httpResponse, err := instance.PostWorkbookSaveAs(request)
	if err != nil {
		println(err)
	}
	println(httpResponse.StatusCode)

Aspose.Cells Cloud SDKs in Popular Languages

.NET	Java	PHP	Python	Ruby	Node.js	Android	Swift	Perl
GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub	GitHub
NuGet	Maven	Composer	PIP	GEM	NPM	Maven	POD	CPAN

# README