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 21.12

Improvement for conversion API.
Improvement for batch data import to support to set cell formula.
Improvement for setting row height and column wight to support to set multi-rows and multi-columns.
Support to set cell formula in batch data import.
Add a new API for updating the list column.
Add a new API for reversing columns and rows.
Add new APIs for grouping and ungrouping shapes.

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) {
    cellsAPI := NewCellsApiService("AppSid", "AppKey", "https://api.aspose.cloud","v3.0")
	name := "Book1.xlsx"	

	args := new(UploadFileOpts)
	args.Path = "GoTest/Booka1.xlsx"
	file, err := os.Open( "test_data/" + name)
	if err != nil {
		return err
	}

	_, _, err =cellsAPI.UploadFile(file, args)
	return err
}

Add Worksheet to Excel File via Go

   name := GetBook1()
	if err := GetBaseTest().UploadFile(name); err != nil {
		t.Error(err)
	}

	args := new(CellsWorksheetsPutAddNewWorksheetOpts)
	args.Name = GetBook1()
	args.SheetName = GetSheet1()
	args.Position = 1
	args.Sheettype = "VB"
	args.Folder = GetBaseTest().remoteFolder

	response, httpResponse, err := GetBaseTest().CellsAPI.CellsWorksheetsPutAddNewWorksheet(args)
	if err != nil {
		t.Error(err)
	} else if httpResponse.StatusCode < 200 || httpResponse.StatusCode > 299 {
		t.Fail()
	} else {
		fmt.Printf("%d\tTestCellsWorksheetsPutAddNewWorksheet - %d\n", GetBaseTest().GetTestNumber(), response.Code)
	}

Using Go to Convert an Excel File in the Cloud

// Upload source file to aspose cloud storage
name := GetBook1()
	if err := GetBaseTest().UploadFile(name); err != nil {
		t.Error(err)
	}

	args := new(CellsSaveAsPostDocumentSaveAsOpts)
	args.Name = GetBook1()
	args.Newfilename = "GoTest/newfilego.pdf"
	args.Folder = GetBaseTest().remoteFolder

	response, httpResponse, err := GetBaseTest().CellsAPI.CellsSaveAsPostDocumentSaveAs(args)
	if err != nil {
		t.Error(err)
	} else if httpResponse.StatusCode < 200 || httpResponse.StatusCode > 299 {
		t.Fail()
	} else {
		fmt.Printf("%d\tTestCellsSaveAsPostDocumentSaveAs - %d\n", GetBaseTest().GetTestNumber(), response.Code)
	}

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