XlsxReaderWriter icon indicating copy to clipboard operation
XlsxReaderWriter copied to clipboard

get row wise data of each column

Open subinkk08 opened this issue 7 years ago • 1 comments

i want iterate the rows of the sheet and i need to take the each column value of row in order to save to a json string.is it possible to convert directly json data or please give me a way to do that. thanks in advance. i found a post which is iterating all cells.

subinkk08 avatar Aug 14 '17 11:08 subinkk08

Take a characters AtoZ and append values from 1 to your row count, so the cellvalue becomes A1, B1 and so on and get cellValue. Guess this should solve it.

AmbroseSilveira avatar Sep 16 '17 17:09 AmbroseSilveira