ruby读取SQLite的图片数据并插入word中
表的结构请参看http://xineohpanihc.iyunv.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
页:
[1]