summaryrefslogtreecommitdiff
path: root/samples/dumpXLSX.go
diff options
context:
space:
mode:
Diffstat (limited to 'samples/dumpXLSX.go')
-rw-r--r--samples/dumpXLSX.go45
1 files changed, 0 insertions, 45 deletions
diff --git a/samples/dumpXLSX.go b/samples/dumpXLSX.go
deleted file mode 100644
index 853a337..0000000
--- a/samples/dumpXLSX.go
+++ /dev/null
@@ -1,45 +0,0 @@
-package main
-
-import (
- "fmt"
- "os"
-
- "github.com/360EntSecGroup-Skylar/excelize"
-)
-
-func main() {
- // Exit on missing filename
- if len(os.Args) < 2 || os.Args[1] == "" {
- fmt.Println("Syntax: dumpXLSX <filename.xlsx>")
- os.Exit(1)
- }
-
- // Open file and panic on error
- fmt.Println("Reading ", os.Args[1])
- xlsx, err := excelize.OpenFile(os.Args[1])
- if err != nil {
- panic(err)
- }
-
- // Read all sheets in map
- for i, sheet := range xlsx.GetSheetMap() {
- //Output sheet header
- fmt.Printf("----- %d. %s -----\n", i, sheet)
-
- // Get rows
- rows := xlsx.GetRows(sheet)
- // Create a row number prefix pattern long enough to fit all row numbers
- prefixPattern := fmt.Sprintf("%% %dd ", len(fmt.Sprintf("%d", len(rows))))
-
- // Walk through rows
- for j, row := range rows {
- // Output row number as prefix
- fmt.Printf(prefixPattern, j)
- // Output row content
- for _, cell := range row {
- fmt.Print(cell, "\t")
- }
- fmt.Println()
- }
- }
-}