The xlsx's discuss from gofika

View Code? Open in Web Editor NEW

Microsoft .xlsx read/write for golang

License: MIT License

Go 100.00%

xlsx's Issues

Streaming API

Is it possible to write in a streaming mode? It would be ideal to be able to write rows in a streaming mode. Then you could also be able to configure the in memory buffer threshold.

doc := xlsx.NewFile(xlsx.StreamMode, xlsx.RowBufferSize(100))

defer doc.Close()

pageSize := 100
total := db.GetItemCount()
pages := total / pageSize

if  total % pageSize > 0 {
    pages++
}

sheet := doc.AddSheet("items")
defer sheet.Close()

sheet.AddRow()
    .SetCellValue(xlsx.ColumnNumber("A"),  1, "Name")
    .SetCellValue(xlsx.ColumnNumber("B"),  1, "Quantity")
    .SetCellValue(xlsx.ColumnNumber("C"),  1, "Price")

for page = 0; page < pages; i++ {
    items := db.GetItems(page * pageSize, pageSize)
    for item, _ := range items {
        sheet.AddRow()
            .SetCellValue(xlsx.ColumnNumber("A"),  1, item.Name)
            .SetCellValue(xlsx.ColumnNumber("B"),  1, item.Quantity)
            .SetCellValue(xlsx.ColumnNumber("C"),  1, item.Price)
    }
}

doc.SaveAs("items.xlsx")

Recommend Projects