| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 |
- package excelize
- import (
- "archive/zip"
- "bytes"
- "fmt"
- "io"
- "os"
- )
- // CreateFile provides function to create new file by default template. For
- // example:
- //
- // xlsx := CreateFile()
- //
- func CreateFile() *File {
- file := make(map[string]string)
- file["_rels/.rels"] = templateRels
- file["docProps/app.xml"] = templateDocpropsApp
- file["docProps/core.xml"] = templateDocpropsCore
- file["xl/_rels/workbook.xml.rels"] = templateWorkbookRels
- file["xl/theme/theme1.xml"] = templateTheme
- file["xl/worksheets/sheet1.xml"] = templateSheet
- file["xl/styles.xml"] = templateStyles
- file["xl/workbook.xml"] = templateWorkbook
- file["[Content_Types].xml"] = templateContentTypes
- return &File{
- Sheet: make(map[string]*xlsxWorksheet),
- XLSX: file,
- }
- }
- // Save provides function to override the xlsx file with origin path.
- func (f *File) Save() error {
- if f.Path == "" {
- return fmt.Errorf("No path defined for file, consider File.WriteTo or File.Write")
- }
- return f.WriteTo(f.Path)
- }
- // WriteTo provides function to create or update to an xlsx file at the provided
- // path.
- func (f *File) WriteTo(name string) error {
- file, err := os.OpenFile(name, os.O_WRONLY|os.O_TRUNC|os.O_CREATE, 0666)
- if err != nil {
- return err
- }
- defer file.Close()
- return f.Write(file)
- }
- // Write provides function to write to an io.Writer.
- func (f *File) Write(w io.Writer) error {
- buf := new(bytes.Buffer)
- zw := zip.NewWriter(buf)
- f.contentTypesWriter()
- f.workbookWriter()
- f.workbookRelsWriter()
- f.worksheetWriter()
- for path, content := range f.XLSX {
- fi, err := zw.Create(path)
- if err != nil {
- return err
- }
- _, err = fi.Write([]byte(content))
- if err != nil {
- return err
- }
- }
- err := zw.Close()
- if err != nil {
- return err
- }
- if _, err := buf.WriteTo(w); err != nil {
- return err
- }
- return nil
- }
|