blocks|key|1386300|text|这对我来说非常有效，不需要上传文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1386301|https://github.com/cparker15/csv-to-json?files=1|offset|length|1386302|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1C|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

This worked perfectly for me and does NOT require a file upload:

<a href="https://github.com/cparker15/csv-to-json?files=1" rel="noreferrer">https://github.com/cparker15/csv-to-json?files=1</a>

blocks|key|1601259|text|你可以试试我做的这个工具：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1601260|Mr.+Data+Converter|offset|length|1601261|它可以转换为JSON、XML和其他格式。|1601262|它也是客户端的，所以你的数据永远不会离开你的计算机。|1601263|entityMap|0|LINK|mutability|MUTABLE|url|http://shancarter.github.io/mr-data-converter/^0|0|0|I|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

You can try this tool I made: 

<a href="http://shancarter.github.io/mr-data-converter/" rel="noreferrer">Mr. Data Converter</a>

It converts to JSON, XML and others.

It's all client side, too, so your data never leaves your computer.

blocks|key|1602070|text|从Powershell3.0开始(随Windows8、available+for+Windows+7+and+windows+Server+2008提供，但不随Windows+Vista一起提供)，您可以使用内置的convertto-json命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1602071|PS+E:>+$topicsjson+=+import-csv+.\itinerary-all.csv+%7C+ConvertTo-Json+

PS+E:\>+$topicsjson.Length
11909

PS+E:\>+$topicsjson.getType()

IsPublic+IsSerial+Name+++++++++++++++++++++++++++++++++++++BaseType++++++++++++++++++
--------+--------+----+++++++++++++++++++++++++++++++++++++--------++++++++++++++++++
True+++++True+++++Object[]+++++++++++++++++++++++++++++++++System.Array++++++++++++++|code-block|syntax|javascript|1602072|Online+Help+Page+on+Technet|1602073|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=34595|1|http://technet.microsoft.com/library/hh849922.aspx^0|R|1B|0|0|0|0|R|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

Since Powershell 3.0 (shipped with Windows 8, <a href="http://www.microsoft.com/en-us/download/details.aspx?id=34595">available for Windows 7 and windows Server 2008</a> but not Windows Vista ) you can use the built-in convertto-json commandlet:

<pre><code>PS E:&gt; $topicsjson = import-csv .\itinerary-all.csv | ConvertTo-Json 

PS E:\&gt; $topicsjson.Length
11909

PS E:\&gt; $topicsjson.getType()

IsPublic IsSerial Name BaseType 
-------- -------- ---- -------- 
True True Object[] System.Array 
</code></pre>

<a href="http://technet.microsoft.com/library/hh849922.aspx">Online Help Page on Technet</a>

blocks|key|1601174|text|如果您找不到现有的解决方案，那么用Java构建一个基本的解决方案是相当容易的。我刚刚为一个客户写了一个，只花了几个小时，包括研究工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1601175|Apache+POI将读取Excel二进制文件。http://poi.apache.org/|offset|length|1601176|JSONObject将构建JSON|1601177|之后，只需迭代Excel数据中的行并构建JSON结构即可。下面是一些基本用法的伪代码。|1601178|FileInputStream+inp+=+new+FileInputStream(+file+);
Workbook+workbook+=+WorkbookFactory.create(+inp+);

//+Get+the+first+Sheet.
Sheet+sheet+=+workbook.getSheetAt(+0+);

++++//+Start+constructing+JSON.
++++JSONObject+json+=+new+JSONObject();

++++//+Iterate+through+the+rows.
++++JSONArray+rows+=+new+JSONArray();
++++for+(+Iterator<Row>+rowsIT+=+sheet.rowIterator();+rowsIT.hasNext();+)
++++{
++++++++Row+row+=+rowsIT.next();
++++++++JSONObject+jRow+=+new+JSONObject();

++++++++//+Iterate+through+the+cells.
++++++++JSONArray+cells+=+new+JSONArray();
++++++++for+(+Iterator<Cell>+cellsIT+=+row.cellIterator();+cellsIT.hasNext();+)
++++++++{
++++++++++++Cell+cell+=+cellsIT.next();
++++++++++++cells.put(+cell.getStringCellValue()+);
++++++++}
++++++++jRow.put(+"cell",+cells+);
++++++++rows.put(+jRow+);
++++}

++++//+Create+the+JSON.
++++json.put(+"rows",+rows+);

//+Get+the+JSON+text.
return+json.toString();|code-block|syntax|javascript|1601179|entityMap|0|LINK|mutability|MUTABLE|url|http://poi.apache.org/^0|0|O|M|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

If you can't find an existing solution it's pretty easy to build a basic one in Java. I just wrote one for a client and it took only a couple hours including researching tools.

Apache POI will read the Excel binary.
<a href="http://poi.apache.org/" rel="noreferrer">http://poi.apache.org/</a>

JSONObject will build the JSON

After that it's just a matter of iterating through the rows in the Excel data and building a JSON structure. Here's some pseudo code for the basic usage.

<pre><code>FileInputStream inp = new FileInputStream( file );
Workbook workbook = WorkbookFactory.create( inp );

// Get the first Sheet.
Sheet sheet = workbook.getSheetAt( 0 );

 // Start constructing JSON.
 JSONObject json = new JSONObject();

 // Iterate through the rows.
 JSONArray rows = new JSONArray();
 for ( Iterator&lt;Row&gt; rowsIT = sheet.rowIterator(); rowsIT.hasNext(); )
 {
 Row row = rowsIT.next();
 JSONObject jRow = new JSONObject();

 // Iterate through the cells.
 JSONArray cells = new JSONArray();
 for ( Iterator&lt;Cell&gt; cellsIT = row.cellIterator(); cellsIT.hasNext(); )
 {
 Cell cell = cellsIT.next();
 cells.put( cell.getStringCellValue() );
 }
 jRow.put( "cell", cells );
 rows.put( jRow );
 }

 // Create the JSON.
 json.put( "rows", rows );

// Get the JSON text.
return json.toString();
</code></pre>

blocks|key|1602123|text|这对我很有效，并运行客户端：http://www.convertcsv.com/csv-to-json.htm|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1602124|entityMap|0|LINK|mutability|MUTABLE|url|http://www.convertcsv.com/csv-to-json.htm^0|E|15|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

This works for me and runs client-side:
<a href="http://www.convertcsv.com/csv-to-json.htm">http://www.convertcsv.com/csv-to-json.htm</a>

blocks|key|1386232|text|我发现了这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1386233|http://tamlyn.org/tools/csv2json/|offset|length|1386234|(注意:您必须通过web地址提供csv文件)|1386235|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|X|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

I just found this:

<a href="http://tamlyn.org/tools/csv2json/" rel="noreferrer">http://tamlyn.org/tools/csv2json/</a>

( Note: you have to have your csv file available via a web address )

blocks|key|1601973|text|试试这个小的免费工具：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1601974|http://keyangxiang.com/csvtojson/|offset|length|1601975|它利用node.js+csvtojson+module|1601976|entityMap|0|LINK|mutability|MUTABLE|url|1|https://github.com/Keyang/node-csvtojson^0|0|0|X|0|0|B|G|1|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@$D|S|E|T|1|U]]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|H|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]|O|$5|K|L|M|A|$N|P]]]]

Take a try on the tiny free tool:

<a href="http://keyangxiang.com/csvtojson/" rel="nofollow">http://keyangxiang.com/csvtojson/</a>

It utilises node.js <a href="https://github.com/Keyang/node-csvtojson" rel="nofollow">csvtojson module</a>

blocks|key|1386355|text|现有的解决方案都不起作用，所以我很快就拼凑了一个脚本来完成这项工作。还将空字符串转换为空值，并分隔JSON的标题行。可能需要根据您使用的CSV方言和字符集进行调整。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1386356|#!/usr/bin/python
import+csv,+json
csvreader+=+csv.reader(open('data.csv',+'rb'),+delimiter='\t',+quotechar='"')
data+=+[]
for+row+in+csvreader:
++++r+=+[]
++++for+field+in+row:
++++++++if+field+==+'':+field+=+None
++++++++else:+field+=+unicode(field,+'ISO-8859-1')
++++++++r.append(field)
++++data.append(r)
jsonStruct+=+{
++++'header':+data[0],
++++'data':+data[1:]
}
open('data.json',+'wb').write(json.dumps(jsonStruct))|code-block|syntax|javascript|1386357|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

None of the existing solutions worked, so I quickly hacked together a script that would do the job. Also converts empty strings into nulls and and separates the header row for JSON. May need to be tuned depending on the CSV dialect and charset you have.

<pre><code>#!/usr/bin/python
import csv, json
csvreader = csv.reader(open('data.csv', 'rb'), delimiter='\t', quotechar='"')
data = []
for row in csvreader:
 r = []
 for field in row:
 if field == '': field = None
 else: field = unicode(field, 'ISO-8859-1')
 r.append(field)
 data.append(r)
jsonStruct = {
 'header': data[0],
 'data': data[1:]
}
open('data.json', 'wb').write(json.dumps(jsonStruct))
</code></pre>

blocks|key|1387192|text|对于JSON+(JSON处理器)的CSV支持：https://github.com/FasterXML/jackson-dataformat-csv，而不是硬编码的转换器。所以core+Jackson可以把JSON读成POJO，Maps，JsonNode，几乎任何东西。CSV支持可以对CSV执行相同的操作。将两者结合起来，它是一个非常强大但简单的多种格式之间的转换器(已经有了XML、YAML的后端，还有更多的后端正在添加)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1387193|可以在here上找到一篇介绍如何做到这一点的文章。|1387194|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/FasterXML/jackson-dataformat-csv|1|http://www.cowtowncoder.com/blog/archives/2012/03/entry_468.html^0|3B|8|N|1F|0|0|3|4|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@$9|U|A|V|1|W]]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|H|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]|P|$5|K|L|M|E|$N|Q]]]]

Instead of hard-coded converters, how about CSV support for Jackson (JSON processor): <a href="https://github.com/FasterXML/jackson-dataformat-csv" rel="nofollow">https://github.com/FasterXML/jackson-dataformat-csv</a>. So core Jackson can read JSON in as POJOs, Maps, <code>JsonNode</code>, almost anything. And CSV support can do the same with CSV. Combine the two and it's very powerful but simple converter between multiple formats (there are backends for XML, YAML already, and more being added).

An article that shows how to do this can be found <a href="http://www.cowtowncoder.com/blog/archives/2012/03/entry_468.html" rel="nofollow">here</a>.

Does anyone know if there is application that will let me convert preferably XLS to JSON?

I'll also settle for a converter from CSV since that's what I'll probably end up having to write myself if there is nothing around.

converting CSV/XLS to JSON?

Windows

JSON

Java

有没有人知道有没有能让我把XLS转换成JSON的应用程序？我也会满足于CSV的转换器，因为如果周围没有任何东西，我可能最终不得不自己编写。

问将CSV/XLS转换为JSON？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将CSV/XLS转换为JSON？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将CSV/XLS转换为JSON？
EN