README
¶
# excel for golang
read and write excel files in golang.
go语言读写excel文件.
dependency
install
go get github.com/aswjh/excel
example
package main
import (
"runtime"
"fmt"
"time"
"github.com/aswjh/excel"
)
func main() {
runtime.GOMAXPROCS(1)
option := excel.Option{"Visible": true, "DisplayAlerts": true, "ScreenUpdating": true}
xl, _ := excel.New(option) //xl, _ := excel.Open("test_excel.xls", option)
defer xl.Quit()
sheet, _ := xl.Sheet(1) //xl.Sheet("sheet1")
defer sheet.Release()
sheet.Cells(1, 1, "hello")
sheet.PutCell(1, 2, 2006)
sheet.MustCells(1, 3, 3.14159)
cell := sheet.Cell(5, 6)
defer cell.Release()
cell.Put("go")
cell.Put("font", map[string]interface{}{"name": "Arial", "size": 26, "bold": true})
cell.Put("interior", "colorindex", 6)
sheet.PutRange("a3:c3", []string {"@1", "@2", "@3"})
rg := sheet.Range("d3:f3")
defer rg.Release()
rg.Put([]string {"~4", "~5", "~6"})
urc := sheet.MustGet("UsedRange", "Rows", "Count").(int32)
println("str:"+sheet.MustCells(1, 2), sheet.MustGetCell(1, 2).(float64), cell.MustGet().(string), urc)
cnt := 0
sheet.ReadRow("A", 1, "F", 9, func(row []interface{}) (rc int) { //"A", 1 or 1, 9 or 1 or nothing
cnt ++
fmt.Println(cnt, row)
return //-1: break
})
time.Sleep(2000000000)
//Sort
cells := excel.GetIDispatch(sheet, "Cells")
cells.CallMethod("UnMerge")
sort := excel.GetIDispatch(sheet, "Sort")
sortfields := excel.GetIDispatch(sort, "SortFields")
sortfields.CallMethod("Clear")
sortfields.CallMethod("Add", sheet.Range("f:f").IDispatch, 0, 2)
sort.CallMethod("SetRange", cells)
sort.PutProperty("Header", 1)
sort.CallMethod("Apply")
//Chart
shapes := excel.GetIDispatch(sheet, "Shapes")
_chart, _ := shapes.CallMethod("AddChart", 65)
chart := _chart.ToIDispatch()
chart.CallMethod("SetSourceData", sheet.Range("a1:c3").IDispatch)
//AutoFilter
cells.CallMethod("AutoFilter")
excel.Release(sortfields, sort, cells, chart, shapes)
time.Sleep(3000000000)
xl.SaveAs("test_excel.xls") //xl.SaveAs("test_excel", "html")
}
license
Documentation
¶
Index ¶
- func ColumnAtoi(s string) int
- func ColumnItoa(num int) (col string)
- func DoFuncs(funcs ...interface{})
- func Except(info string, err *error, funcs ...interface{})
- func GetIDispatch(_idisp interface{}, args ...string) (idisp *ole.IDispatch)
- func GetProperty(idisp *ole.IDispatch, args ...string) (ret interface{}, err error)
- func MustGetProperty(idisp *ole.IDispatch, args ...string) interface{}
- func PutProperty(idisp *ole.IDispatch, args ...interface{}) (err error)
- func Release(idisps ...*ole.IDispatch)
- func RftCall(function reflect.Value, args ...reflect.Value) (err error)
- func String(val interface{}) (ret string)
- func ToValueArray(sac *ole.SafeArrayConversion) (values [][]interface{})
- type Cell
- type MSO
- func (mso *MSO) ActivateWorkBook(id interface{}) (wb WorkBook, err error)
- func (mso *MSO) ActiveWorkBook() (WorkBook, error)
- func (mso *MSO) AddSheet(args ...string) (Sheet, error)
- func (mso *MSO) AddWorkBook() (WorkBook, error)
- func (mso *MSO) CountSheets() int
- func (mso *MSO) CountWorkBooks() int
- func (mso *MSO) OpenWorkBook(full string) (WorkBook, error)
- func (mso *MSO) Pick(workx string, id interface{}) (ret *ole.IDispatch, err error)
- func (mso *MSO) Quit() (err error)
- func (mso *MSO) Save() []error
- func (mso *MSO) SaveAs(args ...interface{}) []error
- func (mso *MSO) SelectSheet(id interface{}) (sheet Sheet, err error)
- func (mso *MSO) SetOption(args ...interface{}) (err error)
- func (mso *MSO) Sheet(id interface{}) (Sheet, error)
- func (mso *MSO) Sheets() (sheets []Sheet)
- func (mso *MSO) WorkBooks() (wbs WorkBooks)
- type Option
- type Range
- type Sheet
- func (sheet Sheet) Cell(r int, c int) Cell
- func (sheet Sheet) Cells(r int, c int, vals ...interface{}) (ret string, err error)
- func (sheet Sheet) Delete() (err error)
- func (sheet Sheet) Get(args ...string) (ret interface{}, err error)
- func (sheet Sheet) GetCell(r int, c int, args ...string) (ret interface{}, err error)
- func (sheet Sheet) GetRange(rang string) (ret interface{}, err error)
- func (sheet Sheet) MustCells(r int, c int, vals ...interface{}) (ret string)
- func (sheet Sheet) MustGet(args ...string) interface{}
- func (sheet Sheet) MustGetCell(r int, c int, args ...string) interface{}
- func (sheet Sheet) MustGetRange(rang string) interface{}
- func (sheet Sheet) Name(args ...string) (name string)
- func (sheet Sheet) PutCell(r int, c int, args ...interface{}) (err error)
- func (sheet Sheet) PutRange(rang string, args ...interface{}) (err error)
- func (sheet Sheet) Range(rang string) Range
- func (sheet Sheet) ReadRow(args ...interface{})
- func (sheet Sheet) Select() (err error)
- type VARIANT
- type WorkBook
- type WorkBooks
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func ColumnAtoi ¶
func ColumnItoa ¶
func GetIDispatch ¶
func GetIDispatch(_idisp interface{}, args ...string) (idisp *ole.IDispatch)
func GetProperty ¶
get Property as interface.
func MustGetProperty ¶
func MustGetProperty(idisp *ole.IDispatch, args ...string) interface{}
get Property as interface.
func PutProperty ¶
func PutProperty(idisp *ole.IDispatch, args ...interface{}) (err error)
put Property.
func ToValueArray ¶
func ToValueArray(sac *ole.SafeArrayConversion) (values [][]interface{})
from github.com/go-ole/go-ole/safearrayconversion.go:ToValueArray
Types ¶
type Cell ¶
type Cell struct {
*ole.IDispatch
}
type MSO ¶
type MSO struct {
Option
IuApp *ole.IUnknown
IdExcel *ole.IDispatch
IdWorkBooks *ole.IDispatch
WorkBook WorkBook
Version float64
FILEFORMAT map[string]int
}
func Initialize ¶
func (*MSO) ActivateWorkBook ¶
func (*MSO) ActiveWorkBook ¶
func (*MSO) AddWorkBook ¶
func (*MSO) CountSheets ¶
func (*MSO) CountWorkBooks ¶
func (*MSO) SelectSheet ¶
type Range ¶
type Range struct {
*ole.IDispatch
}
type Sheet ¶
type Sheet struct {
*ole.IDispatch
}
func (Sheet) MustGetCell ¶
Must get cell Property as interface.
func (Sheet) MustGetRange ¶
Source Files
Click to show internal directories.
Click to hide internal directories.