Encoding in spreadsheet-excel (0.3.5.1) gem

Ruby
1

Hi,

  I am using the ruby version 1.8.while i export the excel sheet i

found different symbol (company’s) instead of company’s,i am using the
gem spreadsheet-excel (0.3.5.1).I tried and found one solution

format4 =
workbook.add_format(:color=>“black”,:bold=>1,:underline=>0,:align=>‘left’,:size=>10,:border=>5,:font_charset=>0x01),
but these :font_charset is not removing the symbol(’)
FONT_ENCODINGS =
{
0x00 => :iso_latin1,
0x01 => :default,
0x02 => :symbol,
0x4d => :apple_roman,
0x80 => :shift_jis,
0x81 => :korean_hangul,
0x82 => :korean_johab,
0x86 => :chinese_simplified,
0x88 => :chinese_traditional,
0xa1 => :greek,
0xa2 => :turkish,
0xa3 => :vietnamese,
0xb1 => :hebrew,
0xb2 => :arabic,
0xba => :baltic,
0xcc => :cyrillic,
0xde => :thai,
0xee => :iso_latin2,
0xff => :oem_latin1,
}
i tried all these but not working ,please reply me

Thanks
selvaraj

2

If you are authoring excel files, I’d like to shamelessly recommend a
different gem that does a much better job.

3

Randy Morgan wrote in post #1046584:

If you are authoring excel files, I’d like to shamelessly recommend a
different gem that does a much better job.

GitHub - randym/axlsx: xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.

Thanks for ur reply