65 lines
1.2 KiB
Go
65 lines
1.2 KiB
Go
|
package excel
|
||
|
|
|
||
|
|
import (
|
||
|
|
"go.digitalcircle.com.br/open/replaycli-go/api"
|
||
|
|
)
|
||
|
|
|
||
|
|
const (
|
||
|
|
CELLTYPE_STRING = "s"
|
||
|
|
CELLTYPE_INT = "i"
|
||
|
|
CELLTYPE_BOOL = "b"
|
||
|
|
)
|
||
|
|
|
||
|
|
type Cli struct {
|
||
|
|
cli *api.Cli
|
||
|
|
}
|
||
|
|
|
||
|
|
func (c *Cli) HttpCli() *api.Cli {
|
||
|
|
return c.cli
|
||
|
|
}
|
||
|
|
|
||
|
|
type Req struct {
|
||
|
|
File string `json:"file"`
|
||
|
|
Sheet string `json:"sheet"`
|
||
|
|
Cel string `json:"cel"`
|
||
|
|
Val string `json:"val"`
|
||
|
|
Celtype string `json:"celtype"`
|
||
|
|
}
|
||
|
|
|
||
|
|
func (c *Cli) Read(fname string, sheet string) ([][]string, error) {
|
||
|
|
req := &Req{
|
||
|
|
File: fname,
|
||
|
|
Sheet: sheet,
|
||
|
|
}
|
||
|
|
res := make([][]string, 0)
|
||
|
|
err := c.cli.HttpJsonPost("/ipc/excel/read", req, &res)
|
||
|
|
return res, err
|
||
|
|
}
|
||
|
|
func (c *Cli) Write(fname string, sheet string, cell string, val string, celtype string) error {
|
||
|
|
req := &Req{
|
||
|
|
File: fname,
|
||
|
|
Sheet: sheet,
|
||
|
|
Cel: cell,
|
||
|
|
Val: val,
|
||
|
|
Celtype: celtype,
|
||
|
|
}
|
||
|
|
res := ""
|
||
|
|
err := c.cli.HttpJsonPost("/ipc/excel/write", req, &res)
|
||
|
|
return err
|
||
|
|
}
|
||
|
|
|
||
|
|
func (c *Cli) New(fname string, sheet string) (string, error) {
|
||
|
|
req := &Req{
|
||
|
|
File: fname,
|
||
|
|
Sheet: sheet,
|
||
|
|
}
|
||
|
|
res := ""
|
||
|
|
err := c.cli.HttpJsonPost("/ipc/excel/new", req, &res)
|
||
|
|
return res, err
|
||
|
|
}
|
||
|
|
|
||
|
|
func NewCli() *Cli {
|
||
|
|
ret := &Cli{cli: api.NewCli()}
|
||
|
|
return ret
|
||
|
|
}
|