excelize | Golang library for reading and writing Microsoft Excel | Data Visualization library

 by   360EntSecGroup-Skylar Go Version: v2.4.0 License: BSD-3-Clause

kandi X-RAY | excelize Summary

kandi X-RAY | excelize Summary

excelize is a Go library typically used in Analytics, Data Visualization applications. excelize has no bugs, it has no vulnerabilities, it has a Permissive License and it has medium support. You can download it from GitHub.

Excelize is a library written in pure Go providing a set of functions that allow you to write to and read from XLSX / XLSM / XLTM / XLTX files. Supports reading and writing spreadsheet documents generated by Microsoft Excel 2007 and later. Supports complex components by high compatibility, and provided streaming API for generating or reading data from a worksheet with huge amounts of data. This library needs Go version 1.15 or later. The full API docs can be seen using go's built-in documentation tool, or online at go.dev and docs reference.

            kandi-support Support

              excelize has a medium active ecosystem.
              It has 9013 star(s) with 941 fork(s). There are 200 watchers for this library.
              It had no major release in the last 12 months.
              There are 75 open issues and 611 have been closed. On average issues are closed in 149 days. There are 2 open pull requests and 0 closed requests.
              It has a neutral sentiment in the developer community.
              The latest version of excelize is v2.4.0

            kandi-Quality Quality

              excelize has 0 bugs and 0 code smells.

            kandi-Security Security

              excelize has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
              excelize code analysis shows 0 unresolved vulnerabilities.
              There are 0 security hotspots that need review.

            kandi-License License

              excelize is licensed under the BSD-3-Clause License. This license is Permissive.
              Permissive licenses have the least restrictions, and you can use them in most projects.

            kandi-Reuse Reuse

              excelize releases are available to install and integrate.
              Installation instructions, examples and code snippets are available.

            Top functions reviewed by kandi - BETA

            kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
            Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of excelize
            Get all kandi verified functions for this library.

            excelize Key Features

            No Key Features are available at this moment for excelize.

            excelize Examples and Code Snippets

            No Code Snippets are available at this moment for excelize.

            Community Discussions


            golang excelize how to copy the cell and it's format
            Asked 2022-Mar-16 at 02:36

            I use github.com/xuri/excelize/v2 to process the excel file.

            I append many sheets in many excel files into one sheet in one excel.

            Below is the sample code.



            Answered 2022-Mar-16 at 02:36


            How do I add columns to an existing excel worksheet using golang and excelize?
            Asked 2022-Feb-26 at 13:42

            I have some go code that opens a spreadsheet and for each row, uses a lanid in the row to lookup some data. I would like to add this derived data as two new columns in the sheet.

            Opening the sheet and looping over all the rows works fine. I just can't figure out how to add the new columns. Any suggestions welcome.

            The code below throws an error of

            panic: runtime error: index out of range [7] with length 7

            like the columns haven't been added.



            Answered 2022-Feb-26 at 13:42

            You can set it by SetCellValue function.

            This is the example.

            Source https://stackoverflow.com/questions/71276493


            Bad formula when using excelize Golang
            Asked 2022-Feb-14 at 15:26

            I get an error when using a formula like this [file.SetCellFormula(sheetName, "A6", "=IF(C6<>\"\";IF(OR((F6-E6)>0;G6<>\"\";J6>0);\"O\";\"X\");\"\")")], I'm sure the formula is correct, I have copied this formula from a working excel file



            Answered 2022-Feb-14 at 15:26

            Try replacing those semicolons (;) by commas (,).
            (As a general idea, always use the US standards, not your local one)

            Source https://stackoverflow.com/questions/70986640


            How to check if a variable in a string is blank
            Asked 2022-Jan-14 at 07:07
            Want to achieve

            I am building an app with Go. It is to create a ruby file from an excel file.

            If there is a value in the xx, I want to put it in the data, and if it is blank, I want to skip the process. However, if I put nil as shown below, I get an error.



            Answered 2022-Jan-14 at 06:24
            rows, err := excel_file.GetRows("Test")

            Source https://stackoverflow.com/questions/70706682


            How to get the values of a particular column in excel sheet and make as an array and pass that array as input values in golang?
            Asked 2021-Apr-23 at 10:51

            I have a column in excel sheet with random numbers generated from 1 to 1 million.

            I would like to read this particular column and store in an array in golang.

            Later, i would like to pass this array as my request to my load balancer which will read the values in my column and do the load balancing accordingly.

            I am using "github.com/360EntSecGroupSkylar/excelize" for creating an excel file

            Thank you



            Answered 2021-Apr-23 at 10:51

            Now I assume that all the other things such as creating, reading, etc. are out of the scope of this question and you have a struct file that has the current excel file.
            In this case, you can try following:

            Source https://stackoverflow.com/questions/67227403


            Upload .xlsx file to google cloud storage
            Asked 2021-Apr-06 at 10:12

            I have this API written in Go that creates an .xlsx file, using excelize, from fetched data from DB that I want to upload to private GCS bucket. But the problem is after I uploaded the file, it says that the file type is application/zip not application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.



            Answered 2021-Apr-06 at 10:12


            Trying to submit html form data to excel
            Asked 2021-Mar-16 at 19:37

            I got success to write code to submit html form data as single excel row. But in my html form I want to submit multiple data which should be appended in single cell of excel but second part of data should start with new line in the same cell. Just like (ALT + Enter Operation). My html code is as below.




            Answered 2021-Mar-13 at 23:58

            If I am reading your query correctly I believe you are asking how to add a new line of text into an excel cell (you would use ALT+Enter to do this in the Excel application). Where the data comes from does not appear to be relevant to your question.

            In Excel (on Windows) multiple lines in a cell are split by a line feed (char 0xA, or \n in go). However there is a slight complication in that Excel automatically sets the cell to "wrap" when you add a line break (if you don't do this the line break is there but not displayed).

            Here is an example of how this can be implemented in Go; each time you run the application it will add a new line to cell A1. Note that I am not changing the cell height so you will need to do that to make the extra lines visible:

            Source https://stackoverflow.com/questions/66612619


            How to read all the rows from an XLS file when sheet/section name is not provided in Go
            Asked 2020-Jul-16 at 01:00

            I need to read all the rows from .xsl files in Go. Found this amazing Excelize library that would let me read from & write to XLSX/XLSM/XLTM files.

            Unfortunately their GetRows() requires worksheet name.



            Answered 2020-Jul-16 at 01:00

            You can use f.WorkBook.Sheets.Sheet[0].Name to get the name of the first sheet, where f is an excelize.File.

            Source https://stackoverflow.com/questions/62924127

            Community Discussions, Code Snippets contain sources that include Stack Exchange Network


            No vulnerabilities reported

            Install excelize

            If your packages are managed using Go Modules, please install with following command.


            Contributions are welcome! Open a pull request to fix a bug, or open an issue to discuss a new feature or change. XML is compliant with part 1 of the 5th edition of the ECMA-376 Standard for Office Open XML.
            Find more information at:

            Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items

            Find more libraries
          • HTTPS


          • CLI

            gh repo clone 360EntSecGroup-Skylar/excelize

          • sshUrl


          • Stay Updated

            Subscribe to our newsletter for trending solutions and developer bootcamps

            Agree to Sign up and Terms & Conditions

            Share this Page

            share link