escaped symbols when parsing XLS

A

Artyom Loenko

Hi all.

how can I escaped special characters when parsing XLS?

i try to parse by this line of code:

grid =
Spreadsheet::parseExcel.parse("C:/Projects/Temp/arch/0043247/1.xls").worksheet(0).map()
{ |r| r }.compact.map() { |r| r.map() { |c| c.to_s('cp1251')}.compact
rescue nil }

but if there are some special characters at rows, such as \ or ' or `, i
have nil at my array.

hot to escape special characters at this line { |c| c.to_s('cp1251')} ?

thanx for answers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,200
Messages
2,571,046
Members
47,646
Latest member
xayaci5906

Latest Threads

Top