Re: Can't read Ruby Spreadsheet generated XLS files

On Mon, 16 Feb 2009, Alexander Skwar wrote:

I have a VERY simple ruby program which uses spreadsheet on Windows
2000 to create an Excel file:

require 'spreadsheet'
Spreadsheet.client_encoding = 'UTF-8'
book =
sheet1 = book.create_worksheet

It should be clear if you dump and examine biff records of that xls
file.  I'm now not having time to actually look into it, but I suspect
the 'UTF-8' caused trouble because biff only support utf16-le. May be
the byte count of unicode string is incorrect.  What if you change
'UTF-8' to latin?

GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver --recv-keys 4434BAB3
唐詩315 王昌齡  出塞
    秦時明月漢時關  萬里長征人未還  但使龍城飛將在  不教胡馬渡陰山

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]