Bug att xlsx.read #938

New Issue

2018-01-03T09:38:58Z

ghost commented

2018-01-03 09:38:58 +00:00

(Migrated from github.com)

ERROR TypeError: Cannot read property 't' of undefined
at parse_workbook (xlsx.js:15493)
at parse_xlscfb (xlsx.js:15924)
at read_cfb (xlsx.js:18822)
at Object.readSync [as read] (xlsx.js:18889)

Fixed it by checking t first.

// if (sst[val.isst] && sst[val.isst].t) {	
	temp_val=make_cell(sst[val.isst].t, val.ixfe, 's');
	temp_val.XF = XFs[temp_val.ixfe];
	if(BIFF2Fmt > 0) temp_val.z = BIFF2FmtTable[(temp_val.ixfe>>8) & 0x1F];
	safe_format_xf(temp_val, options, wb.opts.Date1904);
	addcell({c:val.c, r:val.r}, temp_val, options);
// }

ERROR TypeError: Cannot read property 't' of undefined at parse_workbook (xlsx.js:15493) at parse_xlscfb (xlsx.js:15924) at read_cfb (xlsx.js:18822) at Object.readSync [as read] (xlsx.js:18889) Fixed it by checking t first. ``` // if (sst[val.isst] && sst[val.isst].t) { temp_val=make_cell(sst[val.isst].t, val.ixfe, 's'); temp_val.XF = XFs[temp_val.ixfe]; if(BIFF2Fmt > 0) temp_val.z = BIFF2FmtTable[(temp_val.ixfe>>8) & 0x1F]; safe_format_xf(temp_val, options, wb.opts.Date1904); addcell({c:val.c, r:val.r}, temp_val, options); // } ```

SheetJSDev commented

2018-01-03 14:37:04 +00:00

(Migrated from github.com)

Can you share a file that triggers this error?

ghost commented

2018-01-03 14:48:13 +00:00

(Migrated from github.com)

Where can i send them? xls is unsupported.

SheetJSDev commented

2018-01-03 14:49:29 +00:00

(Migrated from github.com)

Attach in an email to hello@sheetjs.com