file.go 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. package excelize
  2. import (
  3. "archive/zip"
  4. "bytes"
  5. "fmt"
  6. "io"
  7. "os"
  8. )
  9. // CreateFile provides function to create new file by default template. For
  10. // example:
  11. //
  12. // xlsx := CreateFile()
  13. //
  14. func CreateFile() *File {
  15. file := make(map[string]string)
  16. file["_rels/.rels"] = templateRels
  17. file["docProps/app.xml"] = templateDocpropsApp
  18. file["docProps/core.xml"] = templateDocpropsCore
  19. file["xl/_rels/workbook.xml.rels"] = templateWorkbookRels
  20. file["xl/theme/theme1.xml"] = templateTheme
  21. file["xl/worksheets/sheet1.xml"] = templateSheet
  22. file["xl/styles.xml"] = templateStyles
  23. file["xl/workbook.xml"] = templateWorkbook
  24. file["[Content_Types].xml"] = templateContentTypes
  25. return &File{
  26. Sheet: make(map[string]*xlsxWorksheet),
  27. XLSX: file,
  28. }
  29. }
  30. // Save provides function to override the xlsx file with origin path.
  31. func (f *File) Save() error {
  32. if f.Path == "" {
  33. return fmt.Errorf("No path defined for file, consider File.WriteTo or File.Write")
  34. }
  35. return f.WriteTo(f.Path)
  36. }
  37. // WriteTo provides function to create or update to an xlsx file at the provided
  38. // path.
  39. func (f *File) WriteTo(name string) error {
  40. file, err := os.OpenFile(name, os.O_WRONLY|os.O_TRUNC|os.O_CREATE, 0666)
  41. if err != nil {
  42. return err
  43. }
  44. defer file.Close()
  45. return f.Write(file)
  46. }
  47. // Write provides function to write to an io.Writer.
  48. func (f *File) Write(w io.Writer) error {
  49. buf := new(bytes.Buffer)
  50. zw := zip.NewWriter(buf)
  51. f.contentTypesWriter()
  52. f.workbookWriter()
  53. f.workbookRelsWriter()
  54. f.worksheetWriter()
  55. for path, content := range f.XLSX {
  56. fi, err := zw.Create(path)
  57. if err != nil {
  58. return err
  59. }
  60. _, err = fi.Write([]byte(content))
  61. if err != nil {
  62. return err
  63. }
  64. }
  65. err := zw.Close()
  66. if err != nil {
  67. return err
  68. }
  69. if _, err := buf.WriteTo(w); err != nil {
  70. return err
  71. }
  72. return nil
  73. }