{"id":18102,"date":"2016-02-17T08:00:40","date_gmt":"2016-02-16T23:00:40","guid":{"rendered":"http:\/\/www.sssg.org\/blogs\/hiro345\/?p=18102"},"modified":"2016-02-16T22:47:38","modified_gmt":"2016-02-16T13:47:38","slug":"openpyxl%e3%82%92%e4%bd%bf%e3%81%86%e3%81%a8python%e3%81%a7excel%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%82%92%e6%93%8d%e4%bd%9c%e3%81%a7%e3%81%8d%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.hiro345.net\/blogs\/hiro345\/archives\/18102.html","title":{"rendered":"openpyxl\u3092\u4f7f\u3046\u3068Python\u3067Excel\u30d5\u30a1\u30a4\u30eb\u3092\u64cd\u4f5c\u3067\u304d\u308b"},"content":{"rendered":"

\u300copenpyxl \/ openpyxl \u2014 Bitbucket<\/a>\u300d\u3067\u516c\u958b\u3055\u308c\u3066\u3044\u308bOSS\u3001openpyxl\u306f\u3001Python\u3067Excel\u30d5\u30a1\u30a4\u30eb\u3092\u64cd\u4f5c\u3059\u308b\u305f\u3081\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u3067\u3059\u3002
\n
\npip\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\u753b\u50cf\u3082\u3069\u3046\u305b\u4f7f\u3046\u3067\u3057\u3087\u3046\u304b\u3089\u3001\u4e00\u7dd2\u306bpillow\u3082\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304f\u3068\u826f\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n

\r\n$ pip install openpyxl pillow\r\n<\/pre>\n
\u3061\u306a\u307f\u306b\u3001Ubuntu\u306a\u3069Python3\u74b0\u5883\u3068Python2\u74b0\u5883\u304c\u5171\u5b58\u3057\u3066\u3044\u308b\u74b0\u5883\u3067\u306f\u3001pip3\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n
\r\n$ pip3 install openpyxl pillow\r\n<\/pre>\n
\u591a\u5206\u3001virtualenv\u3082\u3057\u304f\u306fpyvenv\u3092\u4f7f\u3063\u3066\u4eee\u60f3\u74b0\u5883\u3092\u7528\u610f\u3057\u305f\u65b9\u304c\u4f55\u304b\u3068\u697d\u3067\u3057\u3087\u3046\u3002\u305d\u306e\u3042\u305f\u308a\u306e\u89e3\u8aac\u306f\u7701\u7565\u3057\u307e\u3059\u3002<\/p>\n
\u300cManipulating a workbook in memory \u2014 openpyxl 2.5.0 documentation<\/a>\u300d\u306b\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u304c\u3042\u308b\u306e\u3067\u3001\u4e00\u901a\u308a\u8aad\u3080\u3068\u826f\u3055\u305d\u3046\u3067\u3059\u3002<\/p>\n
\u666e\u6bb5\u3001Excel\u30d5\u30a1\u30a4\u30eb\u306f\u4f7f\u308f\u306a\u3044\u306e\u3067\u3059\u304c\u3001\u3084\u3063\u3071\u308a\u30d7\u30ed\u30b0\u30e9\u30e0\u304b\u3089\u64cd\u4f5c\u304c\u5fc5\u8981\u306a\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002VBA\u3067\u30b3\u30fc\u30c9\u3092\u7d44\u3080\u3068\u3044\u3046\u624b\u3082\u3042\u308a\u307e\u3059\u304c\u3001Python\u304b\u3089\u4f7f\u3048\u308b\u306a\u3089\u3001\u305d\u3063\u3061\u306e\u65b9\u304c\u697d\u3067\u3059\u3088\u306d\u3002\u3061\u306a\u307f\u306bOpenOffice\u3067\u958b\u3044\u3066Python\u3067\u64cd\u4f5c\u3068\u3044\u3046\u65b9\u6cd5\u3082\u3042\u3063\u305f\u3088\u3046\u306a\u6c17\u304c\u3057\u307e\u3059\u3002<\/p>\n
\u3044\u305a\u308c\u306b\u305b\u3088\u3001\u5fc5\u8981\u306a\u6642\u306b\u8abf\u3079\u3066\u4f7f\u3048\u3070\u3044\u3044\u3060\u3051\u3067\u3059\u306d\u3002\u4fbf\u5229\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u304c\u591a\u3044\u3068\u3001\u3044\u308d\u3044\u308d\u3067\u304d\u3066\u697d\u3057\u3044\u3067\u3059\u3002<\/p>\n
Python\u95a2\u9023\u306e\u66f8\u7c4d\u306b\u306f\u4e0b\u8a18\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
\n