Hi, I am a Ruby newbie, and I am trying to use parseexcel library to retrieve some information from a spreadsheet, but when I try this, I receive the chars contained on the cell alternated square chars. Does anybody knows how to solve this? Thanks, Luiz
on 2006-12-27 16:50
on 2006-12-27 21:51
I print the square code char and it is zero (nil). Please, somebody help me. workbook = Spreadsheet::ParseExcel.parse('myspreadsheet.xls') # usually, you want the first worksheet: worksheet = workbook.worksheet(0) # now you can either iterate over all rows, skipping the first number of # rows (in case you know they just contain column headers) myVal = worksheet.cell(0,4).value puts myVal
on 2006-12-27 22:05
Luiz wrote: > # rows (in case you know they just contain column headers) > myVal = worksheet.cell(0,4).value > puts myVal > If you're sure they're all null characters, you can always use gsub to get rid of them: myVal.gsub!(/\000/,'') Chris S.