Open Source Go Library for Spreadsheets
Read, Create, Merge & Filter Data in Excel XLSX / XLSM / XLTM Spreadsheet Files via Go API.
Excelize is an Open source pure Go library provides functionality for reading and writing of Microsoft Excel XLSX / XLSM / XLTM spreadsheet files. Developers can read and write spreadsheet documents generated by Microsoft Excel™ 2007 and later inside their own applications. The library is very user-friendly and supports reading of large spreadsheet files. It has provided streaming API for generating or reading data from a worksheet with huge amounts of data.
The library fully supports several important features related to Excel spreadsheet files manipulation and processing, such as reading and writing Excel files, working with cell ranges, Excel rows management, adding comments, merge cells, copy rows, conditional formatting, insert texts, manage tables in Excel files, add images, add new sheets and many more.
At A Glance
An overview of Excelize features.
- Create XLSX file
- Modify XLSX file
- Read XLSX
- Add images
- Add charts
- Merge cells
- Copy rows
- Conditional formatting
- Add comments
- Cell ranges
- Add rows
- Manage tables
- Excel encryption
- Formula calculation
Excelize supports Excel spreadsheet format as well as it can export data to common file formats.
Excelize library needs Go version 1.10 or later.
Getting Started with Excelize
The recommended way to install Excelize is from GitHub, please use the following command for fasters installation.
Install via GitHub Command
go get github.com/360EntSecGroup-Skylar/excelize
Generate Excel XLSX File via Go Library
Excelize enables programmers to generate an Excel XLSX spreadsheet inside their own Go applications. Once you have created the sheet you can also create a new sheet, set the value of a cell, define the number of rows and columns, Set an active sheet of the workbook, and more. You can also assign a name to a sheet and save the file to the path of your choice, set font type and text size for a created sheet.
Insert Chart to an XLSX File
Excel Charts are visual representations of data from a worksheet that can convey more understanding to the data by summarizing large amounts of data within a small section of your worksheet. Charts allow users to visually display data in different formats such as Bar, Column, Pie, Line, Area or Radar, etc. Excelize library supports chart generation as well as control with just a few lines of code inside your own applications. It allows building charts based on data in a worksheet or generates charts without any data.
Creating PivotTable in Excel File
Excelize provides the capability for creating a pivot table inside an Excel spreadsheet with ease. Pivot tables are one of the most powerful features of Microsoft Excel. It is a powerful tool to calculate, summarize, and analyze your data in an Excel sheet. You can create a simple pivot table by using the AddPivotTable function. Moreover, you can easily assign or edit data source to a pivot table.
Add Images to XLSX Spreadsheets
The Excelize library provides functionality for adding images to an Excel XLSX spreadsheet with just a couple of lines Go commands. You can also modify images according to your needs. You can insert a picture with scaling as well as with printing support.