{"id":3691,"date":"2010-07-25T00:12:46","date_gmt":"2010-07-24T15:12:46","guid":{"rendered":"http:\/\/www.gesource.jp\/weblog\/?p=3691"},"modified":"2017-07-16T15:15:29","modified_gmt":"2017-07-16T06:15:29","slug":"google-app-enginepython%e3%81%a7%e5%8b%95%e7%9a%84%e3%81%abcsv%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%82%92%e4%bd%9c%e6%88%90%e3%81%97%e3%81%a6%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89","status":"publish","type":"post","link":"https:\/\/www.gesource.jp\/weblog\/?p=3691","title":{"rendered":"Google App Engine(Python)\u3067\u52d5\u7684\u306bCSV\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u305b\u308b"},"content":{"rendered":"

Google App Engine(Python)\u3067\u52d5\u7684\u306bCSV\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u305b\u308b\u65b9\u6cd5\u3002<\/p>\n

\u4eca\u56de\u306e\u4f8b\u3067\u306fGoogle App Engine\u7528\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30afKay<\/a>\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

CSV\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3059\u308b\u306b\u306fcsv\u30e2\u30b8\u30e5\u30fc\u30eb\u306eWriter\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n

import csv\n\u2026\nwriter = csv.writer(data)\n<\/code><\/pre>\n
Writer\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30b3\u30f3\u30b9\u30c8\u30e9\u30af\u30bf\u306e\u6700\u521d\u306e\u5f15\u6570\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u30e9\u30a4\u30af\u306a\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u3068\u308a\u307e\u3059\u3002
\n\u3053\u3053\u3067\u306fStringIO\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n
import StringIO\ndata = StringIO.StringIO()\n<\/code><\/pre>\n
csv\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u306f\u3001Writer\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306ewriterow()\u3067\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002
\n\u5f15\u6570\u306b\u306f\u3001\u884c\u30c7\u30fc\u30bf(\u30d0\u30a4\u30c8\u5217)\u306e\u914d\u5217\u3092\u3068\u308a\u307e\u3059\u3002
\n\u30e6\u30cb\u30b3\u30fc\u30c9\u6587\u5b57\u5217\u306fencode()\u3067\u30d0\u30a4\u30c8\u5217\u306b\u30a8\u30f3\u30b3\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n
writer.writerow([u'5560005'.encode('utf-8'), u'\u5927\u962a\u5e9c\u5927\u962a\u5e02\u6d6a\u901f\u533a\u65e5\u672c\u6a4b'.encode('utf-8')])\nwriter.writerow([u'5560006'.encode('utf-8'), u'\u5927\u962a\u5e9c\u5927\u962a\u5e02\u6d6a\u901f\u533a\u65e5\u672c\u6a4b\u6771'.encode('utf-8')])\nwriter.writerow([u'5560004'.encode('utf-8'), u'\u5927\u962a\u5e9c\u5927\u962a\u5e02\u6d6a\u901f\u533a\u65e5\u672c\u6a4b\u897f'.encode('utf-8')])\n<\/code><\/pre>\n
\u30d6\u30e9\u30a6\u30b6\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u305b\u308b\u306b\u306f\u3001\u30d8\u30c3\u30c0\u306e’Content-Type’\u306b’application\/octet-stream’\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n
header = Headers()\nheader.add('Content-Type', 'application\/octet-stream');\n<\/code><\/pre>\n
\u30d8\u30c3\u30c0\u306e’Content-Disposition’\u3067\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u305b\u308bCSV\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n
header.add('Content-Disposition', 'attachment', filename='sample.csv')\n<\/code><\/pre>\n
\u5168\u4f53\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
views.py<\/p>\n
def index(request):\n  import csv\n  import StringIO\n  from werkzeug.datastructures import Headers\n  from werkzeug import Response\n\n  data = StringIO.StringIO()\n  writer = csv.writer(data)\n  writer.writerow([u'5560005'.encode('utf-8'), u'\u5927\u962a\u5e9c\u5927\u962a\u5e02\u6d6a\u901f\u533a\u65e5\u672c\u6a4b'.encode('utf-8')])\n  writer.writerow([u'5560006'.encode('utf-8'), u'\u5927\u962a\u5e9c\u5927\u962a\u5e02\u6d6a\u901f\u533a\u65e5\u672c\u6a4b\u6771'.encode('utf-8')])\n  writer.writerow([u'5560004'.encode('utf-8'), u'\u5927\u962a\u5e9c\u5927\u962a\u5e02\u6d6a\u901f\u533a\u65e5\u672c\u6a4b\u897f'.encode('utf-8')])\n\n  header = Headers()\n  header.add('Content-Type', 'application\/octet-stream');\n  header.add('Content-Disposition', 'attachment', filename='sample.csv')\n  return Response(data.getvalue(), headers=header)\n<\/code><\/pre>\n
###\u95a2\u9023\u30da\u30fc\u30b8<\/p>\n