search

a8568730 / NativeDB

2 stars 1 forks source link

讀取xlsx檔取出資訊 #4

Closed a8568730 closed 10 years ago

a8568730 commented 10 years ago

要確認xlsx 有哪些欄位

找程式讀取xlsx的資料

a8568730 commented 10 years ago

Converter http://apievangelist.com/2013/09/24/excel-and-csv-conversion-to-json-and-xml-in-javascript-that-runs-100-on-github/ http://shancarter.github.io/mr-data-converter/

xlsx-to-json 要用到node.js https://www.npmjs.org/package/xlsx-to-json

[solved] use python package, xlrd in linux

a8568730 commented 10 years ago

這個部份分兩步驟：

  1. xlsx -> 讀出一行行的row_value組成的array (done)
  2. array -> json