Developer Guide

Aspose.Cells FOSS for Go is a free, open-source library for programmatic spreadsheet processing. Whether you are building data pipelines, generating automated reports, or processing large .xlsx files, Aspose.Cells FOSS provides a small, idiomatic Go API that covers workbook creation, cell access, styling, validation, and streaming — without requiring Microsoft Office.

Key Features

Workbook and Worksheet Operations

Create a new Workbook with NewWorkbook() and access its worksheets through the Worksheets slice. Read and write individual cells through the Cells() collection with Get(ref), Set(ref, value), Remove(ref), and All().

Cell Styling

Group Font, Fill, Alignment, and Border settings into a reusable Style and apply it to a cell with Cell.SetStyle.

Data Validation

Attach list or whole-number range validation to a cell range with Worksheet.AddDataValidation, including custom error titles, messages, and error styles.

Tables and Pictures

Build structured Table ranges with Worksheet.AddTable, and embed images with Worksheet.AddPicture.

CSV Interop and Streaming

Convert between XLSX and CSV with ExportToCSV/ImportFromCSV and ToCSV/FromCSV. Process large workbooks row by row with StreamingReader.ProcessRows, without loading the whole sheet into memory.


Getting Started

Install

go get github.com/aspose-cells-foss/Aspose.Cells-FOSS-for-Go/v26

Hello World

Create a Workbook, set a cell value, and call Save() to write an XLSX file:

func main() {
	wb := cells_foss.NewWorkbook()
	ws := wb.Worksheets[0]
	ws.Cells().Set("A1", "Hello, Aspose.Cells FOSS!")
	ws.Cells().Set("A2", 42)
	wb.Save("hello.xlsx")
}

Available Guides

See Also