Setting border for selected cells is a practical requirement.

I searched the docs and the code but didn't find anything to set the font style to bold, italic etc.

Hello. First of all I really grateful for your work.

Don't know bug or not, but I found some strange behavior of func SetCellStyle.
If I already have some formating, for example borders, and I try to add for example red color to cell, I loosing borders.
May be it is normal, but in this way it would be useful to have func like AddCellStyle or something similar.

Hi Luxurioust,

first of all, AWESOME library. Got it up and running in no time thanks through the great documentation.

You know what would make excelize even better? Having a way to enable auto filter. I've searched around and it should be possible. See http://xlsxwriter.readthedocs.io/working_with_autofilters.html

I dug around a bit in the python source code and most of the logic is defined here https://github.com/jmcnamara/XlsxWriter/blob/master/xlsxwriter/worksheet.py#L1472 (however I don't understand a whole lot of it... ) Hopefully you do

I'm not an advanced enough go developer to create a good PR, but would be very grateful if you could add this feature to excelize.

When printing file, inserted pictures are hidden.
I found a property setting.

Great library!
One feature that would be nice, is the ability to extract the named ranges, or definedNames from an xlsx workbook or - xl\workbook.xml from the zip archive.

They are defined like this:

<definedNames>
 <definedName name="named_range_test1">Sheet1!$A$2:$C$40</definedName>
 <definedName name="named_range_test2">Sheet2!$G$2:$G$5</definedName>
</definedNames>

Suggest to add function "AddTextBox()" like "AddPicture()"

When I open an existing xlsx file and try to add a picture to a sheet which already has some pictures in it, existing pictures will be corrupted or removed and the picture I'm trying to add is not added to the sheet.

My code:

func main() {
	xlsx, err := excelize.OpenFile("./tmp.xlsx")
	if err != nil {
		log.Println(err)
	 }

	if err = xlsx.AddPicture("Sheet1", "E5", "./test.jpg", `{"x_scale": 1, "y_scale": 1}`); err != nil {
		log.Println(err)
	}

	err = xlsx.WriteTo("./Workbook.xlsx")
	if err != nil {
		log.Println(err)
		os.Exit(1)
	}
}

When setting value repeatedly with many cols, it runs very slow!

col := "A"
for i := 0; ; i++ {
	col += "A"
	xlsx.SetCellStr("Sheet1", col+"1", "a")
	fmt.Println("set value")
}

As well as in tealeg/xlsx#186, this library suffers from memory eating while trying to parse large files.

For example I have 7mb file (~60k rows with ~40 columns for each row) which parsed with tealeg/xlsx into 700mb of RAM, while this library eats almost whole gigabyte.

Any plans to provide an iterator which will be memory-friendly?

Feature request
Please add support for Sheet move/copy between different xlsx files

Thanks in advance

panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0x4d96f7]

goroutine 1 [running]:
github.com/Luxurioust/excelize.(*File).formattedValue(0xc4200504b0, 0x1, 0xc4200f9982, 0x6, 0x0, 0x0)
/home/dlin/go/src/github.com/Luxurioust/excelize/cell.go:69 +0x177
github.com/Luxurioust/excelize.(*xlsxC).getValueFrom(0xc4200edd70, 0xc4200504b0, 0xc420050820, 0xc4201148d0, 0x1, 0x0, 0x2)
/home/dlin/go/src/github.com/Luxurioust/excelize/rows.go:144 +0x15b
github.com/Luxurioust/excelize.(*File).GetRows(0xc4200504b0, 0xc4200edea0, 0x6, 0xc42001159c, 0x1, 0xc4200edea0)
/home/dlin/go/src/github.com/Luxurioust/excelize/rows.go:60 +0x9e8
main.updateSheet(0xc4200504b0, 0x531640, 0x3)
/home/dlin/tmp/bug/bug.go:28 +0xd2
main.main()
/home/dlin/tmp/bug/bug.go:15 +0x6f

t.xlsx

package main

import (
"fmt"
"log"
"strconv"

"github.com/Luxurioust/excelize" // bug: Date format, can't insert value

)

func main() {
log.SetFlags(log.Lshortfile)
xl, err := excelize.OpenFile("t.xlsx")

updateSheet(xl, "Fut")

err = xl.Save()
if err != nil {
	log.Fatalln(err)
}

idxSheet := xl.GetSheetIndex(sheetName)
if idxSheet == 0 {
	log.Fatalln("Can't found correct sheetName:", sheetName)
}
rows := xl.GetRows("sheet" + strconv.Itoa(idxSheet))
fmt.Println(rows)

Hi hope all is well. Great work that i'm benefiting from so thanks very much.

With .SetCellValue(), .SetCellStr(), and .SetCellInt(), they make decisions about the alignment of the result, which is not bad per se. I know i can use .SetCellStyle() afterwards. But it would be very handy to have a function that respects the existing style. I wish to be able to set all the styles i need within an Excel file as a kind of report template, outside of Go, then use Go to populate it, and not even need to know what the styles are within my Go code. For example a column that is already center-aligned, would be great if a function that can keep it center-aligned, or whatever the style might be, including font, color, date formatting, currency etc.

Something like a .SetCellValueWithStyleRetention(). Or is there already a way to achieve this with the existing functions?

How can I "create" and "update" graphs in an xlsx files?

As I understand it, the order of FileList elements in the slice is not of importance. Therefore, instead of a slice of the struct FileList (containing Key and Value), you could use a map[string] string.

https://gobyexample.com/maps
https://blog.golang.org/go-maps-in-action

Hello. First of all I really grateful for your work.

Found some strange behaviour of func UpdateLinkedValue.
I have two sheets - first with real data and second with linked data from first one.
On the second sheet with linked data I use auto formatting rules. In my situation it is adding background color to cell depends on percentage, for example red background if 90% and more.

If I don't using UpdateLinkedValues I don't loose auto formatting, but linked data doesn't update.
If I using UpdateLinkedValues I loose auto formatting, but linked data updates.

Hi,

Is it possible to implement new function which can delete/remove particular sheet?

I need import some data to mongodb and the row data have a picture need to save another path ! I don't want to upload excel and pictures two times, so how do I get a picture from the cell ? Here are my previous snippets and related links(https://github.com/tealeg/xlsx/issues/49), but there's no real solution,that made me a little anxious ! Thanks a lot !

只有整形和字符串的插入没有图片的插入功能

Can you please add feature:
support for pivot data source edit/change
Right now I make copy of pivot, but copy make reference to the data source, so I still required to make changes in pivot data source manually

Also it will be great to create pivot from the code, without excel application :)

Thanks in advance

As the title says, how to get all rows and their cells? I don't know beforehand how many rows or cells there'll be.

Feel free to delete if off-topic.

I see two reasonably popular XLSX go packages, this and tealeg/xlsx. Is it worth trying to merge to one unified effort?

Hi! I want to use custom names for my sheets. But I can't because it need to name "Sheet" + index.
It's critical bug, I think.

https://github.com/Luxurioust/excelize/blob/master/cell.go#L14
https://github.com/Luxurioust/excelize/blob/master/sheet.go#L22
https://github.com/Luxurioust/excelize/blob/master/sheet.go#L35

Thank you for your library! Great work! 👍

Do you have a roadmap for future development?

Added data validation types in attached xlsxWorksheet.go.

xmlWorkbook.zip

With this change cell data validations are preserved when calling OpenFile("excel.xlsx") and then WriteTo("excel.xlsx").

Thanks!

cell := xlsx.GetCellValue("Sheet1", "B2")
fmt.Println(cell)
// Get all the rows in a sheet.
rows := xlsx.GetRows("sheet1")
fmt.Println(rows)

in windows it works normal,but in macOS rows is empty,cell can get value

Hi,

When I create workbook and do some entries to the cells I noticed that if there are some leading spaces in front of the text, they are missing.
In case if I open the workbook with excel and enter some text with leading spaces they are corretly entered to the cell.

Is there a simple way when setting complex border like this.

Go won't handle those like shell expansion would, it would be cleaner just use to "Workbook.xlsx" instead of "~/Workbook.xlsx"

Is there any way to read excel by rows, like in tealeg's case:

for _, row = range sheet.Rows

in case I don't know how many rows are there?

In lastest version the GetRows function can`t work ! To call xlsx.GetRows("sheet1") function get a string array but length with 0. Rules have changed ?

Hi,
would it be possible to have something like stream-writing to a file in case of lots of rows? Like hitting the excel sheet row limit?

I'm not so familiar with GoLang's IO, but maybe there is no problem to achieve this?

For example I have millions of rows to put in excel sheets, and it is obviously memory heavy task. The idea is to read slice of rows from data source, like 100,000 at the time, then write them to the excel file in a loop until all rows was written. In such case there would be produced either excel file with few sheets or few excel files.

The primary idea is to handle memory consumption to reasonable amounts of RAM, like few gigabytes not tens..

What's Your opinion?

When I saw the example code, my direct reaction was that it should be in an object-oriented style:

package main

import (
    "fmt"
    "github.com/Luxurioust/excelize"
)

func main() {
    xlsx := excelize.CreateFile()

    sheet2 := xlsx.NewSheet(2, "Sheet2")
    sheet3 := xlsx.NewSheet(3, "Sheet3")

    sheet2.SetCellInt("A23", 10)
    sheet3.SetCellStr("B20", "Hello")

    err := xlsx.Save("~/Workbook.xlsx")
    if err != nil {
        fmt.Println(err)
    }
}

By passing this test data
data.xlsx

The myread.go

package main
/*
Build: go build -o myread myread.go
run: ./my_read data.xlsx
*/
import (
	"fmt"
	"log"
	"os"

	"github.com/Luxurioust/excelize"
)

func main() {
	inF, err := excelize.OpenFile(os.Args[1])
	if err != nil {
		log.Fatalln(err)
	}

	sheet := inF.GetRows(inF.GetSheetName(1))
	for _, row := range sheet {
		fmt.Println(len(row), row)
	}
} 

For example,
tealeg/xlsx display the same cell as: &{ 42740 0xc420424640 mm-dd-yy false false 0 0 2}
throught it's .String() will convert to '01-05-17'

Luxurioust/excelize: just display as 42740 (already converted to string)

Capability to duplicate a sheet, like PowerShell/excel's $wb.sheets.item(1).copy($wb.sheets.item(2)). Perhaps something like:

// sheet at index 1 already exists...
xlsx.NewSheet(2, "sheet2")
xlsx.CopySheet(1, 2)

Hey,

I just came across your project and noticed there is a lot of copied code from tealeg/xlsx without attribution. Especially xmlSharedStrings.go which is a direct copy paste of tealeg/xlsx xmlSharedStrings.go, comments and all.

It's nice to see more xlsx action in the Golang world, but have you considered just contributing to tealeg/xlsx instead?

when calling .Token() function of type *xml.Decoder, error returned is ignored when it should be handled.
line: token, err := decoder.Token() inside function getTotalRowsCols()

Hi. Example does not work. Library created bad xlsx file (in attach).
xlsx := excelize.CreateFile()
xlsx.NewSheet(2, "Sheet2")
xlsx.SetCellValue("Sheet2", "A2", "Hello world.")
xlsx.SetCellValue("Sheet1", "B2", 100)
xlsx.SetActiveSheet(2)
err = xlsx.WriteTo("Workbook.xlsx")
if err != nil {
fmt.Println(err)
os.Exit(1)
}
Workbook.xlsx

Thanks for this project!

xls, err := excelize.OpenFile("data/test2.xlsx")
log.Println(xls.GetRows("Sheet1"))

Workbook.xlsx
I attached my test file.

I made that file and run homepage's "Reading XLSX file sample" code
I expected :
test text
1 2 ...

But i got :

1 2 ...

But when I input some values to "A?" of "Sheet1" I got the expected result.

I think cell.go's line 26
if rows <= xAxis {
return ""
}
return an empty string.

I have set the cells (approx. 300) as text i.e. "05-29-17" and the .xlsx file, it saves in seconds... When I set the cells to a Go Time type and save the .xlsx file, it takes almost a minute! -- Anyhow, it's a Great package! Thanks for sharing!

There should be three columns in the output, first and third column are Chinese characters.

data.xlsx

package main
import (
	"fmt"
	"log"

	"github.com/Luxurioust/excelize"
)

func main() {
	inF, err := excelize.OpenFile("data.xlsx")
	if err != nil {
		log.Fatalln(err)
	}

	sheet := inF.GetRows(inF.GetSheetName(1))
	for _, row := range sheet {
		fmt.Println(len(row), row)
	}
} 

xl.SetCellValue("Sheet1","A1", time.Now())
The excel file will show empty

Hi,

If I open a xlsx file and want to write to some cells in sheet where sheet name is not in format of "SheetX"
after xlsx file is saved, there is no entry in the cell if you open a file with Excel.
Another thing is if I use xlsx.CreateFile() I'm aware that I get only one sheet with name "Sheet1" and I can write to the cells of "Sheet1".
When I do xlsx.NewSheet(2, "Sheet2") I can write to cells in "Sheet2". But if instead od "Sheet2" I put "Test_1" for example, then if I write to some cells in this sheet, this cannot be seen in Excel.

Only workaround I found is to create new sheets with name "SheetX" then do whatever you need and before saving use xslx.SetSheetName("Sheet2", "Test_1") for example.

When read a xlsx file with complex border , Inserted picture shows error.


Workbook.xlsx

func main() {
	xlsx, _ := excelize.OpenFile("./Workbook.xlsx")

	err := xlsx.AddPicture("Sheet1", "A2", "./1.jpg", `{"x_offset": 15, "y_offset": 10, "print_obj": true, "lock_aspect_ratio": false, "locked": false}`)
	if err != nil {
		fmt.Println(err)
	}
	err = xlsx.WriteTo("./Workbook1.xlsx")
	if err != nil {
		fmt.Println(err)
		os.Exit(1)
	}
}