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

Issues with reading values of column after Z in the excel. #42

Open
MinoEclairs opened this issue Aug 11, 2020 · 1 comment
Open

Issues with reading values of column after Z in the excel. #42

MinoEclairs opened this issue Aug 11, 2020 · 1 comment

Comments

@MinoEclairs
Copy link

Hello!
I am trying to read data after 'Z' column in my code. below is my code
const bSDealDatas = excelToJson({
sourceFile: appDataXLSX,
header: {
rows: 1
},
sheets: [{
name: 'spotDealData',
range: 'A2:AA2'
},
],
columnToKey: {
'*': '{{columnHeader}}'
}
});
appDataXLSX is the path of my excel file.
if I defined range A2: Z2 is it works fine but when I try to give A2: AA2 it gives undefined on all cell values after A2.

Kindly tell me how to read cell values of column AA, AB, etc of the excel.
Any Immediate help would be appreciated as I am stuck.

@MinoEclairs MinoEclairs changed the title Issues with reading value after Z column in the excel. Issues with reading values of column after Z column in the excel. Aug 11, 2020
@MinoEclairs MinoEclairs changed the title Issues with reading values of column after Z column in the excel. Issues with reading values of column after Z in the excel. Aug 11, 2020
@BMarrant
Copy link

BMarrant commented Apr 12, 2021

I also saw this bug when reading Z2:AA5. Workaround for me was inserting a blank column before Z (so then reading AA2:AB5) worked for me as I only needed those two columns.

It seems like going across the boundary of Z->AA is the problem, so might just want to leave all before AA blank if you need to read more than 26 columns at once.

If changing the sheet is not an option, then I'm not sure there is a workaround without a code change.

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