我正在尝试通过php VAR将json数据发送到datatables，但出现错误：DataTables警告：表id = example-请求的未知参数'Item Number'为第0行，第0列。有关此错误的更多信息，请参见/tn/4。这是我的JavaScript外观：$(document).ready(function() {
$('#example').DataTable( {
"processing": true,
"data": '[1,{"1":{"A":"Item Number","B":"Type","C":"Form Factor","D":"Processor","E":"Condition Code","F":"Receive Status","G":"Unit Cost","H":"Qty"},"2":{"A":"DELL VENUE 11 PRO KEYBOARD","B":"","C":"","D":"","E":"NEW","F":"Received","G":"$80.00","H":6},"3":{"A":"ELITEBOOK 820 G2","B":"Laptop","C":"","D":"i5","E":"REF","F":"Received","G":"$90.00","H":1},"4":{"A":"ELITEBOOK 840 G2","B":"Laptop","C":"","D":"i5","E":"REF","F":"Received","G":"$109.77","H":7},"5":{"A":"ELITEBOOK 850 G2","B":"Laptop","C":"","D":"i5","E":"REF","F":"Received","G":"$226.83","H":5},"6":{"A":"ELITEDESK 800 G1","B":"Desktop","C":"SFF","D":"i5","E":"REF","F":"Received","G":"$75.06","H":3},"7":{"A":"LATITUDE E5550","B":"Laptop","C":"","D":"i7","E":"REF","F":"Received","G":"$164.43","H":57},"8":{"A":"LATITUDE E6430","B":"","C":"","D":"","E":"USED","F":"Received","G":"$96.00","H":10},"9":{"A":"LATITUDE E7470","B":"Laptop","C":"","D":"i7","E":"REF","F":"Received","G":"$191.00","H":6},"10":{"A":"LG 34MU64-P","B":"","C":"","D":"","E":"REF","F":"Received","G":"$90.08","H":22},"11":{"A":"LG 34MU68-P","B":"","C":"","D":"","E":"REF","F":"Received","G":"$90.08","H":2},"12":{"A":"LG 34UB88-P","B":"","C":"","D":"","E":"REF","F":"Received","G":"$90.08","H":1},"13":{"A":"OPTIPLEX 3010","B":"Desktop","C":"TOWER","D":"PENTIUM","E":"REF","F":"Received","G":"$63.19","H":19},"14":{"A":"OPTIPLEX 3011","B":"Desktop","C":"AIO","D":"i5","E":"REF","F":"Received","G":"$185.77","H":20},"15":{"A":"OPTIPLEX 3020","B":"Desktop","C":"USFF","D":"i5","E":"REF","F":"Received","G":"$74.64","H":92},"16":{"A":"OPTIPLEX 3040","B":"Desktop","C":"USFF","D":"i5","E":"REF","F":"Received","G":"$190.91","H":8},"17":{"A":"OPTIPLEX 3050","B":"Desktop","C":"USFF","D":"i5","E":"REF","F":"Received","G":"$213.20","H":11},"18":{"A":"OPTIPLEX 3240","B":"Desktop","C":"AIO","D":"i5","E":"REF","F":"Received","G":"$293.20","H":1},"19":{"A":"OPTIPLEX 390","B":"Desktop","C":"SFF","D":"i5","E":"REF","F":"Received","G":"$35.00","H":1},"20":{"A":"OPTIPLEX 450","B":"Desktop","C":"DESKTOP","D":"PENTIUM","E":"REF","F":"Received","G":"$0.00","H":2},"21":{"A":"OPTIPLEX 5050","B":"Desktop","C":"USFF","D":"i5","E":"REF","F":"Received","G":"$314.96","H":10},"22":{"A":"OPTIPLEX 7020","B":"Desktop","C":"SFF","D":"i5","E":"REF","F":"Received","G":"$100.27","H":61},"23":{"A":"OPTIPLEX 7040","B":"Desktop","C":"USFF","D":"i7","E":"REF","F":"Received","G":"$309.96","H":21},"24":{"A":"OPTIPLEX 7440","B":"Desktop","C":"AIO","D":"i5","E":"REF","F":"Received","G":"$236.13","H":3},"25":{"A":"OPTIPLEX 790","B":"Desktop","C":"USFF","D":"i3","E":"REF","F":"Received","G":"$65.00","H":3},"26":{"A":"OPTIPLEX 9010","B":"Desktop","C":"USFF","D":"i7","E":"REF","F":"Received","G":"$92.68","H":43},"27":{"A":"OPTIPLEX 9020","B":"Desktop","C":"USFF","D":"i7","E":"REF","F":"Received","G":"$106.37","H":203},"28":{"A":"OPTIPLEX 9030","B":"Desktop","C":"AIO","D":"i7","E":"REF","F":"Received","G":"$119.73","H":206},"29":{"A":"OPTIPLEX 990","B":"Desktop","C":"","D":"i5","E":"REF","F":"Received","G":"$77.09","H":11}}]',
"columns": [
{ data: "Item Number" },
{ data: "Type" },
{ data: "Form Factor" },
{ data: "Processor." },
{ data: "Condition Code" },
{ data: "Receive Status" },
{ data: "Unit Cost." },
{ data: "Qty" }
]
} );
});PHP代码正在从XSLT获取数据，并且我对其进行json编码。$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('reports-dropbox/inventory.xlsx');
$data = array(1,$spreadsheet->getActiveSheet()->toArray(null,true,true,true));
$json = json_encode($data);
