-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
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
Formatting dates format with (*excelize.Rows).Columns #1722
Comments
You can create a style with date format by the |
It wiil override all cells in row with number type. In addition to dates, I also have regular numbers in row. This method doesn't fit |
If the types of cells in a row are not all date, you need to set the style of the specified cells one by one with the |
Okay. To set style only for date types cells, i need to check every cell for it's type with GetCellType and then i can use SetCellStyle. But with this case it's consumes a lot of ram (+2gb for 300k rows file and 15 columns). Probably this relates with new reader for every call of GetCellType and SetCellStyle. |
So, what I can do with it? |
Currently, please set the date type cell style one by one with the SetCellStyle function. I will consider to improve performance for this. |
Hello, i have different date format in sheet. It's possible to format dates to one format when i iterating with rows and get rows values with (*excelize.Rows).Columns or i should check every cell for date type and rewrite style for date type cells?
The text was updated successfully, but these errors were encountered: