From 0faa29f2c11a6d906f340397eca5c4bc6d0f1dc6 Mon Sep 17 00:00:00 2001
From: George Abbott <george@gabbott.dev>
Date: Fri, 3 Nov 2023 21:06:29 +0000
Subject: Commit all

---
 copy.go | 37 +++++++++++++++++++++++++++++++++++++
 1 file changed, 37 insertions(+)
 create mode 100644 copy.go

(limited to 'copy.go')

diff --git a/copy.go b/copy.go
new file mode 100644
index 0000000..a91d30e
--- /dev/null
+++ b/copy.go
@@ -0,0 +1,37 @@
+package badtudexo 
+
+import (
+	xl "anyxcelize"
+	"fmt"
+	st "saggytrousers"
+	"errors"
+)
+
+func Copy(file *xl.File, sheet, target string, failOnEmpty bool) (error, bool) {
+	/* Grab all rows from the sheet. */
+	st.Log(true, "Grabbing rows...")
+	rows, err := file.GetRowsGeneric(sheet)
+	if err != nil {
+		return errors.New(fmt.Sprintf("bt.Copy: failed to get rows  with error %v", err)), false
+	}
+	st.Log(true, " done!\n")
+
+	if len(rows) == 0 {
+		return errors.New(fmt.Sprintf("bt.Copy: rows empty")), true
+	}
+
+	/* Copy into new file. */
+	saved := xl.NewFile()
+	saved.SetSheetName("Sheet1", sheet)
+	count := 1
+	st.Log(false, fmt.Sprintf("len(rows) = %v\n", len(rows)))
+	for _, row := range rows {
+		loc := fmt.Sprintf("A%v", count)
+		st.Log(false, fmt.Sprintf("%v:%v: %v\n", sheet, loc, row))
+		saved.SetSheetRow(sheet, loc, &row)
+		count++
+	}
+
+	/* Save file. */
+	return saved.SaveAs(target), false
+}
-- 
cgit v1.2.1