Examples UniOffice
Starting from an example can speed up code development significantly.
Examples
Document
1. Doc-custom-properties
2. Doc-properties
3. Edit-document
4. Endnotes-footnotes
5. Fill-out-form
6. Header-footer-multiple
7. Header-footer
8. Hyperlink
9. Image
10. Line-spacing
11. Mail-merge
12. Number-of-pages
13. Page-numbers
14. Paragraph-spacing-and-indentation
15. Paragraphs in table
16. Pdf-export-ole
17. Set-strict
18. Simple
19. Tables
20. Toc-generation-ole
21. Toc
22. Use-template
2. Doc-properties
3. Edit-document
4. Endnotes-footnotes
5. Fill-out-form
6. Header-footer-multiple
7. Header-footer
8. Hyperlink
9. Image
10. Line-spacing
11. Mail-merge
12. Number-of-pages
13. Page-numbers
14. Paragraph-spacing-and-indentation
15. Paragraphs in table
16. Pdf-export-ole
17. Set-strict
18. Simple
19. Tables
20. Toc-generation-ole
21. Toc
22. Use-template
Spreadsheet
1. Bar-chart
2. Borders
3. Bubble-chart
4. Cells-with-empty
5. Comments
6. Complex
7. Conditional-formatting
8. Flatten
9. Formula-evaluation
10. Formula
11. Freeze-rows-cols
12. Image
13. Insert-rows
14. Line-chart-3d
15. Line-chart-no-data
16. Line-chart
17. Lots-of-rows
18. Merged
19. Multiple-charts
20. Named-cells
21. Named-ranges
22. Number-date-time-formats
23. Pie-chart
24. Radar-chart
25. Remove-column
26. Rich-text
27. Rotated-cells
28. Shared-formula
29. Simple
30. Sort-filter
31. Surface-chart
32. Validation
33. Wrapped-text
2. Borders
3. Bubble-chart
4. Cells-with-empty
5. Comments
6. Complex
7. Conditional-formatting
8. Flatten
9. Formula-evaluation
10. Formula
11. Freeze-rows-cols
12. Image
13. Insert-rows
14. Line-chart-3d
15. Line-chart-no-data
16. Line-chart
17. Lots-of-rows
18. Merged
19. Multiple-charts
20. Named-cells
21. Named-ranges
22. Number-date-time-formats
23. Pie-chart
24. Radar-chart
25. Remove-column
26. Rich-text
27. Rotated-cells
28. Shared-formula
29. Simple
30. Sort-filter
31. Surface-chart
32. Validation
33. Wrapped-text
Remove-column
Copy
// Copyright 2017 FoxyUtils ehf. All rights reserved. package main // This example demonstrates flattening all formulas from an input Excel file and outputs the flattened values to a new xlsx. import ( "log" "os" "github.com/unidoc/unioffice/common/license" "github.com/unidoc/unioffice/spreadsheet" ) func init() { // Make sure to load your metered License API key prior to using the library. // If you need a key, you can sign up and create a free one at https://cloud.unidoc.io err := license.SetMeteredKey(os.Getenv(`UNIDOC_LICENSE_API_KEY`)) if err != nil { panic(err) } } func main() { ss, err := spreadsheet.Open("original.xlsx") if err != nil { log.Fatalf("error opening document: %s", err) } defer ss.Close() sheet0, err := ss.GetSheet("Cells") if err != nil { log.Fatalf("error opening sheet: %s", err) } err = sheet0.RemoveColumn("C") if err != nil { log.Fatalf("error removing column: %s", err) } sheet1, err := ss.GetSheet("MergedCells") if err != nil { log.Fatalf("error opening sheet: %s", err) } err = sheet1.RemoveColumn("C") if err != nil { log.Fatalf("error removing column: %s", err) } ss.SaveToFile("removed.xlsx") }