前置條件:電腦需安裝Excel
1. 選擇資料來源:從Web
2. 輸入WebAPI URL地址,并點確認按鈕
data2.json
[["2018-03-27","",""],["1980-12-12",28.75,"abc"],["2018-03-27","b",""]]
3. 在Power Query編輯器上點擊’到表格’
前置條件:電腦需安裝Excel
1. 選擇資料來源:從Web
2. 輸入WebAPI URL地址,并點確認按鈕
data2.json
[["2018-03-27","",""],["1980-12-12",28.75,"abc"],["2018-03-27","b",""]]
3. 在Power Query編輯器上點擊’到表格’