{"id":168,"date":"2008-07-24T03:02:36","date_gmt":"2008-07-23T18:02:36","guid":{"rendered":"http:\/\/clockmaker.jp\/blog\/?p=168"},"modified":"2008-07-24T03:02:36","modified_gmt":"2008-07-23T18:02:36","slug":"flex_excel_import","status":"publish","type":"post","link":"https:\/\/clockmaker.jp\/blog\/2008\/07\/flex_excel_import\/","title":{"rendered":"Flex\u3067Excel\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080"},"content":{"rendered":"<p>\u4e45\u3005\u306bFlex\u306b\u3064\u3044\u3066\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3067\u3059\u3002<\/p>\n<p><a href=\"http:\/\/clockmaker.jp\/labs\/080724_flex_excel\/FlexExcel.swf\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-169\" title=\"01\" src=\"https:\/\/clockmaker.jp\/blog\/wp-content\/uploads\/2008\/07\/01.jpg\" alt=\"\" width=\"460\" height=\"300\" \/><\/a><\/p>\n<p>\u30d3\u30b8\u30cd\u30b9\u30de\u30f3\u5fc5\u9808\u306eExcel\u30d5\u30a1\u30a4\u30eb\u3002\u79c1\u306f\u4ed5\u69d8\u66f8\u3084\u30c7\u30d0\u30c3\u30b0\u30b7\u30fc\u30c8\u7b49\u3005\u3001Flash\u3068Photoshop\u306e\u6b21\u3050\u3089\u3044\u306b\u3088\u304f\u4f7f\u3063\u3066\u307e\u3059\u304c\u3001\u4eca\u56de\u306fExcel\u30d5\u30a1\u30a4\u30eb\u3092Flex\u4e0a\u3067\u8868\u793a\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<p>\u6210\u679c\u7269\u306f<a href=\"http:\/\/clockmaker.jp\/labs\/080724_flex_excel\/FlexExcel.swf\">\u3053\u3061\u3089(\u8981FlashPlayer9)<\/a><br \/>\n\u8aad\u307f\u8fbc\u307e\u305b\u3066\u3044\u308bExcel\u30d5\u30a1\u30a4\u30eb\u306f<a href=\"http:\/\/clockmaker.jp\/labs\/080724_flex_excel\/sample.xls\">\u3053\u3061\u3089<\/a><\/p>\n<p>\uff3b2010\u5e743\u670831\u65e5\u8ffd\u8a18\uff3dPapervision3D\u306e\u30c7\u30e2\u3092\u629c\u304d\u306b\u3057\u3066\u3001\u30b7\u30f3\u30d7\u30eb\u306bAS3XLS\u306e\u307f\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306b\u3057\u305f\u30b5\u30f3\u30d7\u30eb\u306f<a href=\"http:\/\/clockmaker.jp\/labs\/080724_flex_excel\/100331_flex_as3xls.zip\">\u3053\u3061\u3089(Flex 3.5)<\/a><\/p>\n<p><!--more--><\/p>\n<h3>\u307e\u305a\u306f\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u3054\u7d39\u4ecb<\/h3>\n<p><a href=\"http:\/\/code.google.com\/p\/as3xls\/\">as3xls &#8211; Google Code<\/a><br \/>\n\u30a8\u30af\u30bb\u30eb\u3092\u8aad\u307f\u8fbc\u3080\u30e9\u30a4\u30d6\u30e9\u30ea\u3067\u3059\u3002swc\u3067\u63d0\u4f9b\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u4eca\u56de\u306f\u3053\u308c\u3092\u4f7f\u3063\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h3>Excel\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u3080\u51e6\u7406<\/h3>\n<p>Flex\u306a\u306e\u3067\u4e45\u3057\u3076\u308a\u306bMXML\u3092\u4f7f\u3063\u3066\u307f\u307e\u3059\u3002\u5916\u90e8\u30ea\u30bd\u30fc\u30b9\u8aad\u307f\u8fbc\u307f\u7cfb\u306e\u51e6\u7406\u306fMXML\u3060\u3068\u30b7\u30f3\u30d7\u30eb\u306b\u66f8\u3051\u308b\u306e\u3067\u3001\u30b5\u30af\u3063\u3068\u8a18\u8ff0\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\n\/\/xmlns:net=&quot;flash.net.*&quot;\u3068\u5b9a\u7fa9\u3057\u3066\u3044\u308b\u3068\u3057\u3066\n&lt;net:URLLoader\n\t\tid=&quot;loader&quot;\n\t\tdataFormat=&quot;binary&quot;\n\t\tcomplete=&quot;convert()&quot;  \/&gt;\n<\/pre>\n<p>\u4e0a\u306eMXML\u3092\u8aac\u660e\u3059\u308b\u3068AS3.0\u306eURLLoader\u3092MXML\u30b7\u30f3\u30bf\u30c3\u30af\u30b9\u3067\u8a18\u8ff0\u3057\u305f\u3082\u306e\u3067\u3059\u3002complete\u30a4\u30d9\u30f3\u30c8\u306b\u3088\u3063\u3066convert\u30e1\u30bd\u30c3\u30c9\u304c\u547c\u3073\u51fa\u3055\u308c\u3066\u307e\u3059\u3002\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u30d0\u30a4\u30ca\u30ea\u30fc\u3067\u6307\u5b9a\u3057\u3066\u3044\u308b\u306e\u304c\u30dd\u30a4\u30f3\u30c8\u3067\u3059\u3002<\/p>\n<h3>Excel\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u63db<\/h3>\n<p>\u6b21\u306bActionScript3.0\u306e\u51e6\u7406\u3092\u66f8\u304d\u307e\u3059\u3002Excel\u3068\u8a00\u3063\u3066\u3082Flash\u304c\u30cd\u30a4\u30c6\u30a3\u30d6\u306b\u6271\u3048\u308b\u30c6\u30ad\u30b9\u30c8\u30c7\u30fc\u30bf\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u306e\u3067\u3001\u524d\u6e96\u5099\u3068\u3057\u3066ByteArray\u306b\u5909\u63db\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\n\/\/ convert\u30e1\u30bd\u30c3\u30c9\u306e\u4e2d\u306e\u51e6\u7406\nvar data:ByteArray = new ByteArray();\ndata = ByteArray(loader.data);\n<\/pre>\n<p>\u6b21\u306b\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u3092\u30c7\u30fc\u30bf\u30b0\u30ea\u30c3\u30c9\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3067\u6271\u3048\u308b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u3053\u3053\u3067\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u6d3b\u8e8d\u3002\u305f\u3063\u305f\uff13\u884c\u3067\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u89e3\u6790\u304c\u3067\u304d\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\nvar excelFile:ExcelFile = new ExcelFile();\nexcelFile.loadFromByteArray(data);\nsheet = excelFile.sheets[0]; \/\/\u5909\u6570sheet\u306fArrayCollection\u578b\n<\/pre>\n<h3>DataGrid\u306b\u633f\u5165\u3057\u3066\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u304c\u8868\u306b<\/h3>\n<p>\u5909\u63db\u51e6\u7406\u3067\u306fArrayCollection\u578b\u306b\u5909\u63db\u3057\u3066\u304f\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30b0\u30ea\u30c3\u30c9\u76f4\u63a5\u4ee3\u5165\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u3067\u76ee\u7684\u306e\u8868\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\ngrid.dataProvider = sheet.values;\n<\/pre>\n<p><a href=\"https:\/\/clockmaker.jp\/blog\/wp-content\/uploads\/2008\/07\/excel_2.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-170\" title=\"excel_2\" src=\"https:\/\/clockmaker.jp\/blog\/wp-content\/uploads\/2008\/07\/excel_2.jpg\" alt=\"\" width=\"458\" height=\"166\" \/><\/a><\/p>\n<h3>\u305b\u3063\u304b\u304f\u306a\u306e\u3067Papervision3D 2.0\u3092\u4f7f\u3063\u3066\u30b0\u30e9\u30d5\u5316\u3057\u3066\u307f\u308b<\/h3>\n<p>ArrayCollection\u578b\u3067\u3042\u308b\u30c7\u30fc\u30bf\u3092\u4e8c\u6b21\u5143\u914d\u5217\u306b\u5909\u63db\u3057\u3066<a href=\"https:\/\/clockmaker.jp\/blog\/2008\/07\/papervision3d_shading\/\">\u6628\u65e5\u4f5c\u3063\u305fSWF<\/a>\u3092\u3061\u3087\u3063\u3068\u6539\u826f\u3057\u3066\u30c7\u30fc\u30bf\u3092\u7a81\u3063\u8fbc\u3093\u3067\u3042\u3052\u307e\u3059\u3002\u3053\u308c\u3067\uff13\u6b21\u5143\u306e\u30b0\u30e9\u30d5\u3082\u3067\u304d\u307e\u3057\u305f\u3002<br \/>\n<a href=\"https:\/\/clockmaker.jp\/blog\/wp-content\/uploads\/2008\/07\/excel_3.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-171\" title=\"excel_3\" src=\"https:\/\/clockmaker.jp\/blog\/wp-content\/uploads\/2008\/07\/excel_3-460x288.jpg\" alt=\"\" width=\"460\" height=\"288\" \/><\/a><br \/>\n<a href=\"http:\/\/clockmaker.jp\/labs\/080724_flex_excel\/FlexExcel.swf\" target=\"_blank\">\u30c7\u30e2(\u8981FlashPlayer9)<\/a><\/p>\n<h3>\u611f\u60f3<\/h3>\n<p>\u30e9\u30a4\u30d6\u30e9\u30ea\u81ea\u4f53\u306f\u975e\u5e38\u306b\u30b7\u30f3\u30d7\u30eb\u306a\u4f7f\u3044\u52dd\u624b\u3002Web\u4e0a\u3067Excel\u3092\u4f7f\u3046\u6a5f\u4f1a\u306f\u5c11\u306a\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001Adobe AIR\u3067\u306f\u6d3b\u8e8d\u3057\u305d\u3046\u306a\u6a5f\u80fd\u304b\u3068\u3002\u30ac\u30c3\u30c4\u30eaRIA\u306b\u4f7f\u3063\u305f\u308a\u3001\u4eca\u56de\u306e\u30b0\u30e9\u30d5\u306e\u3088\u3046\u306b\u3064\u304b\u3063\u305f\u308a\u8272\u3005\u4f7f\u3044\u9053\u306e\u3042\u308a\u305d\u3046\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u3067\u3059\u3002<\/p>\n<h3>OpenOffice\u88fd\u306eExcel\u30d5\u30a1\u30a4\u30eb\u306f\u958b\u3051\u307e\u305b\u3093\u3067\u3057\u305f<\/h3>\n<p>\u3061\u306a\u307f\u306bOpen Office\u3084Google Docs\u3067\u4f5c\u3063\u305fExcel\u30d5\u30a1\u30a4\u30eb\u306f\u958b\u3051\u307e\u305b\u3093\u3067\u3057\u305f\u306e\u3067\u3001\u7d14\u7c8b\u306aMicrosoft\u88fd\u306aExcel\u306e\u307f\u958b\u3051\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n<h3>\u3053\u306e\u30d6\u30ed\u30b0\u5185\u306e\u95a2\u9023\u8a18\u4e8b<\/h3>\n<p><a href=\"https:\/\/clockmaker.jp\/blog\/2008\/07\/papervision3d_shading\/\">Papervision3D 2.0(GreateWhite)\u3067\u53cd\u5c04\u3092\u6bd4\u8f03\u3059\u308b<\/a><br \/>\n<a href=\"https:\/\/clockmaker.jp\/blog\/2008\/07\/papervision3d_greatewhite\/\">Papervision3D 2.0(GreateWhite)\u306e\u7fd2\u4f5c<\/a><\/p>\n<h3>\u4eca\u56de\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9(MXML)\u306e\u307f<\/h3>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\n&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;\n&lt;mx:Application xmlns:mx=&quot;http:\/\/www.adobe.com\/2006\/mxml&quot; xmlns:net=&quot;flash.net.*&quot;&gt;\n\t&lt;mx:Script&gt;\n\t\t&lt;![CDATA[\n\n\t\timport com.as3xls.xls.ExcelFile;\n\t\timport com.as3xls.xls.Sheet;\n\t\timport flash.display.MovieClip;\n\t\timport mx.controls.Alert;\n\n\t\tprivate var sheet:Sheet;\n\n\t\t\/**\n\t\t* Load Method\n\t\t*\/\n\t\tprivate function load():void\n\t\t{\n\t\t\tloader.load(new URLRequest(xlsUrl.text));\n\t\t}\n\n\t\t\/**\n\t\t* Convert Excel -&gt; AS -&gt; View\n\t\t*\/\n\t\tprivate function convert():void\n\t\t{\n\t\t\t\/\/ load complete\n\t\t\tvar data:ByteArray = new ByteArray();\n\t\t\tdata = ByteArray(loader.data);\n\n\t\t\ttry\n\t\t\t{\n\t\t\t\t\/\/ Load the embedded spreadsheet and get the first sheet\n\t\t\t\tvar excelFile:ExcelFile = new ExcelFile();\n\t\t\t\texcelFile.loadFromByteArray(data);\n\t\t\t\tsheet = excelFile.sheets[0];\n\n\t\t\t\t\/\/ Display the sheet in the grid\n\t\t\t\tgrid.dataProvider = sheet.values;\n\n\t\t\t\t\/\/ convert excel -&gt; json\n\t\t\t\tvar json:Array = [];\n\t\t\t\tfor (var i:int = 0; i &lt; sheet.values.length; i++ )\n\t\t\t\t{\n\t\t\t\t\tjson[i] = [];\n\t\t\t\t\tfor (var j:int = 0; j &lt; sheet.values[i].length; j++ )\n\t\t\t\t\t{\n\t\t\t\t\t\tjson[i][j] = sheet.values[i][j]\n\t\t\t\t\t}\n\t\t\t\t}\n\n\t\t\t\t\/\/ view\n\t\t\t\t(world.content as MovieClip).init(json);\n\n\t\t\t}\n\t\t\tcatch(error:Error)\n\t\t\t{\n\t\t\t\tAlert.show(&quot;Fail to convert excel&quot;)\n\t\t\t}\n\n\t\t}\n\t]]&gt;\n\t&lt;\/mx:Script&gt;\n\n\t&lt;net:URLLoader\n\t\tid=&quot;loader&quot;\n\t\tdataFormat=&quot;binary&quot;\n\t\tcomplete=&quot;convert()&quot;\n\t\tioError=&quot;Alert.show('Fail to open url')&quot; \/&gt;\n\n\t&lt;mx:Label text=&quot;url of excel&quot; \/&gt;\n\t&lt;mx:TextInput id=&quot;xlsUrl&quot; text=&quot;sample.xls&quot; \/&gt;\n\t&lt;mx:Button id=&quot;btn&quot; label=&quot;Load Excel File&quot; click=&quot;load(); btn.enabled=false;&quot; \/&gt;\n\t&lt;mx:DataGrid id=&quot;grid&quot;\n\t\twidth=&quot;450&quot;\n\t\tsortableColumns=&quot;false&quot;\n\t\tdraggableColumns=&quot;false&quot; \/&gt;\n\n\t&lt;mx:Panel&gt;\n\t\t&lt;mx:SWFLoader id=&quot;world&quot; source=&quot;World3D.swf&quot; width=&quot;450&quot; height=&quot;250&quot; \/&gt;\n\t&lt;\/mx:Panel&gt;\n\n&lt;\/mx:Application&gt;\n<\/pre>\n<h3>Flex\u306e\u95a2\u9023\u8a18\u4e8b\u3082\u3069\u3046\u305e\uff01<\/h3>\n<ul>\n<li><a title=\"\u30ed\u30fc\u30ab\u30eb\u30d5\u30a1\u30a4\u30eb\u304c\u7de8\u96c6\u3067\u304d\u308bFlex\u88fd\u306e\u8868\u8a08\u7b97\u30a2\u30d7\u30ea\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f | ClockMaker Blog\" href=\"https:\/\/clockmaker.jp\/blog\/2008\/10\/flex_datagrid\/\">\u30ed\u30fc\u30ab\u30eb\u30d5\u30a1\u30a4\u30eb\u304c\u7de8\u96c6\u3067\u304d\u308bFlex\u88fd\u306e\u8868\u8a08\u7b97\u30a2\u30d7\u30ea\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f<\/a><\/li>\n<li><a title=\"Flex\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067Mac\u306e\u30de\u30a6\u30b9\u30db\u30a4\u30fc\u30eb\u306b\u5bfe\u5fdc\u3055\u305b\u308b | ClockMaker Blog\" href=\"https:\/\/clockmaker.jp\/blog\/2009\/02\/flex_mac_wheel\/\">Flex\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067Mac\u306e\u30de\u30a6\u30b9\u30db\u30a4\u30fc\u30eb\u306b\u5bfe\u5fdc\u3055\u305b\u308b<\/a><\/li>\n<li><a title=\"Labs\u306e\u30c7\u30e2\u4e00\u89a7\u3092\u4f5c\u308a\u307e\u3057\u305f\" href=\"https:\/\/clockmaker.jp\/blog\/2008\/10\/launch_labs\/\">Labs\u306e\u30c7\u30e2\u4e00\u89a7\u3092\u4f5c\u308a\u307e\u3057\u305f<\/a><\/li>\n<li><a title=\"\u306f\u3066\u30d6\u3092CoverFlow\u3059\u308b\u300cHatenaTunes\u300d | ClockMaker Blog\" href=\"https:\/\/clockmaker.jp\/blog\/2008\/07\/hatena_tunes\/\">\u306f\u3066\u30d6\u3092CoverFlow\u3059\u308b\u300cHatenaTunes\u300d<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u4e45\u3005\u306bFlex\u306b\u3064\u3044\u3066\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3067\u3059\u3002 \u30d3\u30b8\u30cd\u30b9\u30de\u30f3\u5fc5\u9808\u306eExcel\u30d5\u30a1\u30a4\u30eb\u3002\u79c1\u306f\u4ed5\u69d8\u66f8\u3084\u30c7\u30d0\u30c3\u30b0\u30b7\u30fc\u30c8\u7b49\u3005\u3001Flash\u3068Photoshop\u306e\u6b21\u3050\u3089\u3044\u306b\u3088\u304f\u4f7f\u3063\u3066\u307e\u3059\u304c\u3001\u4eca\u56de\u306fExcel\u30d5\u30a1\u30a4\u30eb\u3092Flex\u4e0a\u3067\u8868\u793a\u3057\u3066\u307f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,4,7],"tags":[],"_links":{"self":[{"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/posts\/168"}],"collection":[{"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/comments?post=168"}],"version-history":[{"count":0,"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/posts\/168\/revisions"}],"wp:attachment":[{"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/media?parent=168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/categories?post=168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockmaker.jp\/blog\/wp-json\/wp\/v2\/tags?post=168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}