search

sestegra / spreadsheet_decoder

Spreadsheet Decoder is a library for decoding spreadsheets for ODS and XLSX files.
MIT License
55 stars 21 forks source link

Request: Read a specific cell #12

Open f4ww4z opened 5 years ago

f4ww4z commented 5 years ago

I'd like to read a specific cell like for example B2 or C11. Was wondering if there's this functionality already?

sestegra commented 5 years ago

SpreadsheetTable doesn't have such dedicated method. rows method returns list of rows with integer indexes ( col and row in following example).

var decoder = new SpreadsheetDecoder.decodeBytes(bytes);
var table = decoder.tables['Sheet1'];
var value = table.rows[row][col];