頁:
[1]
用phpspreadsheet excel to json問題?
如題,最近正在學習php語法,想用phpspreadsheet 去讀excel檔,
再把讀到的資料轉成 json格式,
想請教各位大大,我可以用什麼方式讀完excel後去轉成下面的json格式?
json:{"item":[{"A1":"11","B1":"22","C1":"33","D1":"44","E1","55"},{"A1":"66","B1":"77","C1":"88","D1":"99","E1","00"}],"item1":[{"A1":"111","B1":"222","E1","55"}]}
表格如下:
A1 B1 C1 D1 E1
11 22 33 44 55
66 77 88 99 00
A1 B1 E1
111 222 555
...<div class='locked'><em>瀏覽完整內容,請先 <a href='member.php?mod=register'>註冊</a> 或 <a href='javascript:;' onclick="lsSubmit()">登入會員</a></em></div><div></div> phpspreadsheet 我是沒看過,不過有另外一種寫法 “fgetcsv”也是能讀到excel檔。
(發不上code,沒得示範給你看)
那個excel檔必須是csv格式
頁:
[1]