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

Read 16384 columns instead of actual columns #1737

Closed
rockingdice opened this issue Dec 1, 2023 · 3 comments
Closed

Read 16384 columns instead of actual columns #1737

rockingdice opened this issue Dec 1, 2023 · 3 comments

Comments

@rockingdice
Copy link

Read the xlsx file, the actual columns are 19, but it reads 16384 columns instead, which make the server hang.

Steps to reproduce the issue:

  1. read the xlsx file provided
  2. debug inside the GetCols function
  3. check the cols:
image

Describe the results you received:
16384 cols

Describe the results you expected:
19 cols or similar results

Output of go version:

1.18.10

Excelize version or commit ID:

2.8.0

Environment details (OS, Microsoft Excel™ version, physical, etc.):
MacOS/Centos 7

@rockingdice
Copy link
Author

ct_new_buff.xlsx

the xlsx file that have the issue.

@xuri
Copy link
Member

xuri commented Dec 4, 2023

Thanks for your issue. There are 16384 columns in the worksheet "ct_new_buff", even though the cells right of column "S" seem blank, these cells have custom styles event it, there's cell was not empty, as the documentation of the Excelize library says, only the continually blank cells in the tail of each row will be skipped, so these cells can not be skipped, you can also confirm this by open the workbook by Excel application, the length of the horizontal scroll bar is different between "ct_new_buff" and "Sheet1" in your workbook. So the conduct is expected. I've closed this issue. If you have any questions, please let me know, and you can reopen this anytime.

@xuri xuri closed this as completed Dec 4, 2023
@rockingdice
Copy link
Author

Thanks for your issue. There are 16384 columns in the worksheet "ct_new_buff", even though the cells right of column "S" seem blank, these cells have custom styles event it, there's cell was not empty, as the documentation of the Excelize library says, only the continually blank cells in the tail of each row will be skipped, so these cells can not be skipped, you can also confirm this by open the workbook by Excel application, the length of the horizontal scroll bar is different between "ct_new_buff" and "Sheet1" in your workbook. So the conduct is expected. I've closed this issue. If you have any questions, please let me know, and you can reopen this anytime.

Thank you for your explanation.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants