LibreOffice Calc是否支持JSON文件导入/排序？ [英] Does LibreOffice Calc support JSON file importing/sorting?

问题描述

我一直在尝试将几个.json文件导入LibreOffice Calc。

I've been trying to import a couple of .json files into LibreOffice Calc.

虽然我可以获取原始数据，但它并没有排序为我认为它可能（通过在每个单元格中放置不同的信息）。

Although I can get the raw data in, it isn't sorting as I would think it might (by placing different pieces of info into each cell).

LibreOffice是否支持导入JSON文件并在单元格中对它们进行排序？ （换句话说，导入+排序）？

Does LibreOffice provide support for importing JSON files and sorting them out in cells? (In other words, import + sort)?

如果似乎没有直接支持这一点，转换为CSV将是下一个合乎逻辑的步骤，以便将数据导入Calc？

If there doesn't seem to be direct support for this, would converting to CSV be the next logical step in order to get the data into Calc?

推荐答案

我自己遇到同样的问题（这就是我发现这个问题的方法）。

Had the same problem myself (that's how I found this question).

因此，对于下一个发现此问题的人 - 答案是否定的 - LibreOffice Calc不支持直接导入JSON。

So, for the next person finding this - the answer is no - LibreOffice Calc does not support direct import of JSON.

下一个合乎逻辑的步骤确实是转换为CSV。有免费的在线JSON到CSV转换器，并使用其中一个（ http://www.convertcsv.com/json -to-csv.htm ），我可以很容易地制作一个正确的CSV，其中Calc导入没有问题。

And the next logical step indeed is converting to CSV. There are free online JSON to CSV converters, and using one of them (http://www.convertcsv.com/json-to-csv.htm), I was easily able to make a correct CSV which Calc imports without a problem.

一个可能的警告是，如果你有用JSON表示的复杂对象 - 可能无法转换为CSV，但如果它不适合CSV，它可能也不适合电子表格格式。

One possible caveat is if you have complex objects represented in JSON - that may not be convertible to CSV, but then again, if it doesn't fit into CSV, it probably doesn't fit into spreadsheet format either.

这篇关于LibreOffice Calc是否支持JSON文件导入/排序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！