Re: Can't read Ruby Spreadsheet generated XLS files

[bill lam <cbill lam gmail com>]

On Mon, 16 Feb 2009, Alexander Skwar wrote:
> Hi.
>
> I have a VERY simple ruby program which uses spreadsheet 0.6.3.1 on Windows
> 2000 to create an Excel file:
>
> require 'spreadsheet'
> Spreadsheet.client_encoding = 'UTF-8'
> book = Spreadsheet::Workbook.new
> 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?

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