{"id":52,"date":"2003-12-24T00:11:15","date_gmt":"2003-12-24T00:11:15","guid":{"rendered":"https:\/\/www.step3.net\/?p=52"},"modified":"2026-07-25T07:13:03","modified_gmt":"2026-07-25T07:13:03","slug":"xmlsaxdriverexcel","status":"publish","type":"post","link":"https:\/\/www.step3.net\/?p=52","title":{"rendered":"XML::SAXDriver::Excel"},"content":{"rendered":"

CPAN\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3060\u3051\u3067\u306f\u65e5\u672c\u4eba,\u3064\u304b\u3048\u307e\u3057\u3047\u3093\u3002
\n\u65e5\u672c\u8a9e(Sjis)EXCEL\u3092\u98df\u308f\u305b\u308b\u3068\u51fa\u529b\u30c7\u30fc\u30bf\u304c\u5316\u3051\u5316\u3051\u3002
\n\u7d50\u5c40\u4ee5\u4e0b\u306e\u5bfe\u51e6\u3092\u5b9f\u65bd.\u3000
\n\u30d5\u30fc\u30fc\u30fc\u30fc\u3002
\n\u3010\u5bfe\u51e6\u3011
\n\uff11\uff09XML::SAXDriver::Excel\u306e\u30bd\u30fc\u30b9\u3092\u4fee\u6b63
\n\u8ffd\u52a0\uff1euse Jcode;
\n\u8ffd\u52a0\uff1euse Spreadsheet::ParseExcel::FmtJapan2;
\n\u8ffd\u52a0\uff1emy $oFmtJ = Spreadsheet::ParseExcel::FmtJapan2->new(Code => ‘sjis’);
\n\u5909\u66f4\uff1e$self->{ParseOptions}->{Parser}->Parse($path,$oFmtJ);
\n\u53c2\u8003\uff1ahttp:\/\/www.hippo2000.info\/perl\/tkExcel.htm
\n2)Jcode.pm,Unicode::Map,XML::Handler::YAWriter\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb
\n3\uff09Spreadsheet::ParseExcel\u306e\u30bd\u30fc\u30b9\u3092\u4fee\u6b63
\n\uff08\u53c2\u8003\uff1a\u304e\u3087\u30fc\u3080\u65e5\u8a8c 2002.12 (11-20)<\/a>\uff09
\nSpreadsheet::ParseExcel::FmtJapan2
\nmy $oMap = Unicode::Map->new(‘CP932Excel’);
\ndie “NO MAP FILE CP932Excel!!”
\nunless(-r Unicode::Map->mapping(“CP932Excel”));
\n\u3068\u3044\u3046\u30b3\u30fc\u30c9\u304c\u3042\u308b\uff0e \u3053\u308c\u3089 3 \u884c\u304b\u3089 “Excel” \u306a\u308b\u90aa\u6559\u306e\u30b3\u30c8\u30d0\u3092\u524a\u9664\u3059\u308b\u3068
\n\u6b63\u5e38\u306b\u52d5\u4f5c\u3059\u308b \u2026\u2026
\n\u7406\u7531\u306f\u3084\u306f\u308a CPAN \u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u3072\u3068\u3064\u3067\u3042\u308b Unicode::Map \u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u308b
\n\u89e3\u6bd2 map \u306e\u540d\u524d\u304c CP932Excel.map \u304b\u3089 CP932.map \u306b\u5909\u66f4\u3055\u308c\u305f\u305f\u3081
\n\u305d\u308c\u3067\u3082\u3001warning\u304c\u3067\u3066\u308b\u3051\u3069,\u307e\u3044\u3044\u304b\u3002\u3002\u3002
\nArgument “M-^WXM-^UM-VM-^TM-TM-\\rM-^F” isn’t numeric in numeric le (<=) at (eval 15) line 2.\nUse of uninitialized value in string at ex06_excel.pl line 46.\n\u6700\u5f8c\u3001\u3084\u3063\u3071\u308a\u6cb3\u99ac\u5c4b\u4e8c\u5343\u5e74\u5802<\/a>
\n\u306b\u611f\u8b1d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

CPAN\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3060\u3051\u3067\u306f\u65e5\u672c\u4eba,\u3064\u304b\u3048\u307e\u3057\u3047\u3093\u3002 \u65e5\u672c\u8a9e(Sjis)EXCEL\u3092\u98df\u308f\u305b\u308b\u3068\u51fa\u529b\u30c7\u30fc\u30bf\u304c\u5316\u3051\u5316\u3051\u3002 \u7d50\u5c40\u4ee5\u4e0b\u306e\u5bfe\u51e6\u3092\u5b9f\u65bd.\u3000 \u30d5\u30fc\u30fc\u30fc\u30fc\u3002 \u3010\u5bfe\u51e6\u3011 \uff11\uff09XML::SAXDriver::Exce […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-52","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.step3.net\/index.php?rest_route=\/wp\/v2\/posts\/52","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.step3.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.step3.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.step3.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.step3.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=52"}],"version-history":[{"count":1,"href":"https:\/\/www.step3.net\/index.php?rest_route=\/wp\/v2\/posts\/52\/revisions"}],"predecessor-version":[{"id":1085,"href":"https:\/\/www.step3.net\/index.php?rest_route=\/wp\/v2\/posts\/52\/revisions\/1085"}],"wp:attachment":[{"href":"https:\/\/www.step3.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.step3.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.step3.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}