ajax提交json數據返迴文件流下載excell

var input1 = $("");
input1.attr("type", "hidden");
input1.attr("name", "item");
input1.attr("value", "<%= CGI.escape(@result[:data].to_json) %>");

$("body").append(form);
form.append(input1);

form.submit;
form.remove;
});

Action:

# 下載sku 反饋信息
def download_feedback
result = CGI.unescape(params[:item])
data = JSON.parse(result)
file = Spreadsheet::Workbook.new
list = file.create_worksheet :name => "test"
list.row(0).concat ["CAS No.", "Product Name", "Assay/Purity", "In Stock (yes/no)", "Note","Result"]
data.each_with_index { |report, i|
list.row(i+1).concat report.values
}
xls_report = StringIO.new
file.write xls_report
send_data xls_report.string, :type => "text/xls", :filename => "wait_shipments.xls"
end

喜歡這篇文章嗎？立刻分享出去讓更多人知道吧！