<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error179160_01.xml</logFileName><summary>Errors were detected in file 'C:\Projects\Programming\go\src\github.com\valasek\excel\excel.xlsx'</summary><repairedParts><repairedPart>Repaired Part: /xl/workbook.xml part with XML error.  (Workbook) Load error. Line 2, column 0.</repairedPart></repairedParts></recoveryLog>

// Package excel reads and checks internal timesheets
package main

import (
	"fmt"
	"os"
	"strconv"

	"github.com/360EntSecGroup-Skylar/excelize/v2"
)

func main() {

	// open file
	xlsx, err := excelize.OpenFile("./excel.xlsx")
	if err != nil {
		fmt.Println(err)
		os.Exit(1)
	}

	// jump to last row
	lastRow := 1
	for {
		cell, _ := xlsx.GetCellValue("Timesheet", "A"+strconv.Itoa(lastRow))
		if cell != "" {
			lastRow = lastRow + 1
		} else {
			break
		}
	}

	// mock the data
	// data := [][]string{
	// 	[]string{"Stanislav Valasek", "5/17/2019", "Microsoft", "8", "Customer Improving dba name", "Standard"},
	// 	[]string{"Stanislav Valasek1", "5/17/2019", "Microsoft", "10", "Parsing legal name", "Standard"},
	// }

	xlsx.NewSheet("NewSheet1")
	// index := xlsx.GetSheetIndex("Timesheet")
	// xlsx.SetActiveSheet(index)

	// // write the data
	// for i, row := range data {
	// 	for j, value := range row {
	// 		err := xlsx.SetCellStr("Timesheet", string('A'+j)+strconv.Itoa(lastRow+i), value)
	// 		if err != nil {
	// 			fmt.Println("unable to write row to excel during update, error: ", err)
	// 			os.Exit(1)
	// 		}
	// 		fmt.Printf("written [%s, %s] = %s\n", string('A'+j), strconv.Itoa(lastRow+i), value)
	// 	}
	// }

	// save the changes
	err = xlsx.Save()
	if err != nil {
		fmt.Println("unable to save Internal timesheet, error: ", err)
		os.Exit(1)
	}

}