Writeexcel gem - bitmap image not writing into the spreadsheet

[sathish thandavan]

workbook   = WriteExcel.new("images.xls")
worksheet4 = workbook.add_worksheet('Image 1')
worksheet4.write('A10', "Image inserted over scaled rows and columns.")
worksheet4.insert_image('A1',
  File.join(File.dirname(File.expand_path(__FILE__)), '24bit.bmp')
)
workbook.close

I am not able to write bitmap image whereas I can import .jpg images well.

Error i am getting
"isn't a 24bit true color bitmap."

Also used this step to convert into true color bitmap
"convert alarm.bmp -type truecolor 24bit.bmp"

Help..

[Manivannan Sivaprakasam]

Sathish,

           It seems it is reading and verifying bitmap planes and bpp data by the following method

data.unpack("x26 v2")

The value return by this method should be 24. This is nothing but bitcount(they were calling like this).

So please check the above method is returning 24. If the value of bitcount is 24 then the error will never come.

Regards,

Manivannan

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/89ef2a1c-3625-4c3c-ae31-b245b1a17788%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[sathish thandavan]

Thanks for the reply.

I am getting planes =1
and bitcount = 24

but the image is not writing in the spreadsheet,instead it is showing as empty in the sheet. Opening the attachment it shows file corrupted and same is working for other file formats(jpg)



Sathish.T