Row ranges are not supported

SheetJS / sheetjs

📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs

https://sheetjs.com/

Apache License 2.0

35.1k stars 8k forks source link

Row ranges are not supported #933

Open igor-savin-ht opened 6 years ago

igor-savin-ht commented 6 years ago

According to Excel documentation, '1:1' is a valid range that returns entire first row. However, js-xlsx only supports ranges of format 'A1-B1'

reviewher commented 6 years ago

@igor-savin-ht the helper functions currently assume two-cell ranges. Can you share a file with row or column ranges in a place that causes import errors?

igor-savin-ht commented 6 years ago

@reviewher Yes, that's what I mean - helper functions only support two-cell ranges. I don't think this is file-specific (I observe same behavior on all xlsx files, no matter how simple), and there are no import errors, it's just that if you pass '1:1' range, you always get empty result.

thiennhan2310 commented 6 years ago

Libs is not supported this feature yet or this is a bug ?