最近的项目中有要求将数据库中的几个字段的内容导出到Excel文件,我就简单的记录一下使用Spreadsheet 这个gem来导出Excel
首安装Spreadsheet,使用命令gem install Spreadsheet:
代码:
def exportExcel
orders=Order.find(:all)
book = Spreadsheet::Workbook.new
sheet =book.create_worksheet :name=>"orders"
sheet.row(0).concat %w{Order_id Quantity Shipping_Cost Total_Amount}
count_row=1
orders.each do |odr|
sheet[count_row,0]=odr.order_id
sheet[count_row,1]=odr.merchandise_quantity
sheet[count_row,2]=odr.shipping_cost
sheet[count_ro