カンマやタブで区切ったエクセルのデータをウェブ用に変換するオンラインサービス -Mr. Data Converter

Post on:2010年9月29日

ActionScript

[{name:"Alan",value:"12",color:"blue"},
{name:"Shan",value:"13",color:"green"},
{name:"Joe",value:"45",color:"orange"}];

[{name:"Alan",value:"12",color:"blue"},

{name:"Shan",value:"13",color:"green"},

{name:"Joe",value:"45",color:"orange"}];

ASP/VBScript

Dim myArray(2,2)
myArray(0,0) = "Alan"
myArray(1,0) = "12"
myArray(2,0) = "blue"
myArray(0,1) = "Shan"
myArray(1,1) = "13"
myArray(2,1) = "green"
myArray(0,2) = "Joe"
myArray(1,2) = "45"
myArray(2,2) = "orange"

Dim myArray(2,2)

myArray(0,0) = "Alan"

myArray(1,0) = "12"

myArray(2,0) = "blue"

myArray(0,1) = "Shan"

myArray(1,1) = "13"

myArray(2,1) = "green"

myArray(0,2) = "Joe"

myArray(1,2) = "45"

myArray(2,2) = "orange"

JSON

[{"name":"Alan","value":"12","color":"blue"},
{"name":"Shan","value":"13","color":"green"},
{"name":"Joe","value":"45","color":"orange"}];

[{"name":"Alan","value":"12","color":"blue"},

{"name":"Shan","value":"13","color":"green"},

{"name":"Joe","value":"45","color":"orange"}];

PHP

array(
  array("name"=>"Alan","value"=>"12","color"=>"blue"),
  array("name"=>"Shan","value"=>"13","color"=>"green"),
  array("name"=>"Joe","value"=>"45","color"=>"orange")
);

array(

array("name"=>"Alan","value"=>"12","color"=>"blue"),

array("name"=>"Shan","value"=>"13","color"=>"green"),

array("name"=>"Joe","value"=>"45","color"=>"orange")

);

Ruby

[{"name"=>"Alan","value"=>"12","color"=>"blue"},
{"name"=>"Shan","value"=>"13","color"=>"green"},
{"name"=>"Joe","value"=>"45","color"=>"orange"}];

[{"name"=>"Alan","value"=>"12","color"=>"blue"},

{"name"=>"Shan","value"=>"13","color"=>"green"},

{"name"=>"Joe","value"=>"45","color"=>"orange"}];

XML

&lt;?xml&nbsp;version=&quot;1.0&quot;&nbsp;encoding=&quot;UTF-8&quot;?&gt;
&lt;rows&gt;
&nbsp;&nbsp;&lt;row&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;name&gt;Alan&lt;/name&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;12&lt;/value&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;color&gt;blue&lt;/color&gt;
&nbsp;&nbsp;&lt;/row&gt;
&nbsp;&nbsp;&lt;row&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;name&gt;Shan&lt;/name&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;13&lt;/value&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;color&gt;green&lt;/color&gt;
&nbsp;&nbsp;&lt;/row&gt;
&nbsp;&nbsp;&lt;row&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;name&gt;Joe&lt;/name&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;45&lt;/value&gt;
&nbsp;&nbsp;&nbsp;&nbsp;&lt;color&gt;orange&lt;/color&gt;
&nbsp;&nbsp;&lt;/row&gt;
&lt;/rows&gt;