ruby读取SQLite的图片数据并插入word中

表的结构请参看

 http://xineohpanihc.iteye.com/blog/1013973

 

# coding: utf-8

require 'win32ole'

require 'sqlite3'

require 'base64'

require 'pathname'

 

db = SQLite3::Database.new 'abc.db'

 

word=WIN32OLE.new 'word.Application'

word.visible=true

doc=word.Documents

d=doc.add

sel=word.Selection

ad=word.ActiveDocument

 

ad.Styles.Add('Name'=>'Toc1')

font=ad.Styles("Toc1").Font

font.Size=14

font.Bold=true

font.Name="宋体"

 

sel.Style=ad.Styles("Toc1") 

 

 

db.results_as_hash = true

db.execute("select * from test;") do |row|

    sel.TypeText('Text'=>row['name'])

end

 

s=ad.Shapes.AddShape(1,150,150,100,100)

db.execute("select * from test;") do |row|

    image=Base64.decode64(row['image'])

    id = row['id']

    picture="c:\\tmp\\aa#{id}.jpg"

    File.open(picture,'wb') do|pic|

      pic<< image

    end

 

     p picture.to_s.gsub!(/\\/,'/')

     s.Fill.UserPicture picture.to_s

end

 

#s.Delete