Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

excel time format error #1073

Closed
tickscn opened this issue Nov 25, 2021 · 1 comment
Closed

excel time format error #1073

tickscn opened this issue Nov 25, 2021 · 1 comment
Labels
duplicate This issue or pull request already exists

Comments

@tickscn
Copy link

tickscn commented Nov 25, 2021

Description
GetCellValue return time is not equal to the excel file input
image
image

package main

import (
	"fmt"

	"github.com/xuri/excelize/v2"
)

func main() {
	f, err := excelize.OpenFile("test.xlsx")
	if err != nil {
		fmt.Println(err)
		return
	}

	cell, err := f.GetCellValue("Sheet1", "A1")
	if err != nil {
		fmt.Println(err)
		return
	}
	fmt.Println(cell)
}

test.xlsx

Describe the results you received:
2021-01-21 08:30
Describe the results you expected:
2021-01-21 08:31
Output of go version:
go version go1.17.2 darwin/amd64 && go version go1.16.5 linux/amd64

go version go1.17.2 darwin/amd64 
go version go1.16.5 linux/amd64

Excelize version or commit ID:

v2.4.1

Environment details (OS, Microsoft Excel™ version, physical, etc.):

@xuri
Copy link
Member

xuri commented Nov 25, 2021

This issue is duplicated with #764, #1030, and #1070, please give a try the master branch code, this issue has been re-fixed by commit 58fd279, and will be released in the next version.

@xuri xuri added the duplicate This issue or pull request already exists label Nov 25, 2021
@xuri xuri closed this as completed Nov 30, 2021
@xuri xuri mentioned this issue Dec 11, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duplicate This issue or pull request already exists
Projects
None yet
Development

No branches or pull requests

2 participants