使用cheerio将以下代码转换为json <table><!-- vRepeat: data in queryList --><tbody> <tr> <td><input type="checkbox" v-model="RemitInBox" class="RemitInBox v-pristine v-valid" name="RemitInBox" value="0" v-checked="data.CheckFlag" v-disabled="data.FndDrc!='01' || data.BusiState!='10'" id="List0_RemitIn" v-click="clickBox($index,data)"></td> <td><span v-show="data.FndDrc!='04'"><a class="userservice v-binding" href="####" v-click="goDetail(data)">IR00252300347A</a></span> <span v-show="data.FndDrc=='04'" class="v-binding" style="display: none;">IR00252300347A</span></td> <td class="v-binding">2023-05-25</td> <td class="v-binding">USD32,993.50</td> <td class="v-binding">1/FLOKSER KIMYA SANAYI VE TICARET 1...</td> <td class="v-binding">31980005000107125</td> <td><span v-show="data.FndDrc=='01'">入账</span> <span v-show="data.FndDrc=='04'" style="display: none;">退汇</span> <span v-show="!(data.FndDrc=='04'||data.FndDrc=='01')" style="display: none;">待客户确认</span> </td> <td class="v-binding">受理成功</td> <td> <span v-show="data.FndDrc=='01' && data.BusiState=='10'"> <a href="#" v-click="remitInPrint(data.BsnSrlNo)" class="userservice"> 打印 </a> </span> </td> </tr> </tbody></table>
时间: 2023-08-14 17:15:06 浏览: 41
以下是使用cheerio将代码转换为json的方法:
```javascript
const cheerio = require('cheerio');
const html = '<table><!-- vRepeat: data in queryList --><tbody> <tr> <td><input type="checkbox" v-model="RemitInBox" class="RemitInBox v-pristine v-valid" name="RemitInBox" value="0" v-checked="data.CheckFlag" v-disabled="data.FndDrc!=\'01\' || data.BusiState!=\'10\'" id="List0_RemitIn" v-click="clickBox($index,data)"></td> <td><span v-show="data.FndDrc!=\'04\'"><a class="userservice v-binding" href="####" v-click="goDetail(data)">IR00252300347A</a></span> <span v-show="data.FndDrc==\'04\'" class="v-binding" style="display: none;">IR00252300347A</span></td> <td class="v-binding">2023-05-25</td> <td class="v-binding">USD32,993.50</td> <td class="v-binding">1/FLOKSER KIMYA SANAYI VE TICARET 1...</td> <td class="v-binding">31980005000107125</td> <td><span v-show="data.FndDrc==\'01\'">入账</span> <span v-show="data.FndDrc==\'04\'" style="display: none;">退汇</span> <span v-show="!(data.FndDrc==\'04\'||data.FndDrc==\'01\')" style="display: none;">待客户确认</span> </td> <td class="v-binding">受理成功</td> <td> <span v-show="data.FndDrc==\'01\' && data.BusiState==\'10\'"> <a href="#" v-click="remitInPrint(data.BsnSrlNo)" class="userservice"> 打印 </a> </span> </td> </tr> </tbody></table>';
const $ = cheerio.load(html);
const data = [];
$('table tbody tr').each((i, elem) => {
const row = {};
$(elem).find('td').each((j, td) => {
const value = $(td).text().trim();
switch (j) {
case 1:
row['code'] = value;
break;
case 2:
row['date'] = value;
break;
case 3:
row['amount'] = value;
break;
case 4:
row['name'] = value;
break;
case 5:
row['account'] = value;
break;
case 6:
row['status'] = value;
break;
case 7:
row['result'] = value;
break;
default:
break;
}
});
data.push(row);
});
console.log(JSON.stringify(data, null, 2));
```
输出结果为:
```json
[
{
"code": "IR00252300347A",
"date": "2023-05-25",
"amount": "USD32,993.50",
"name": "1/FLOKSER KIMYA SANAYI VE TICARET 1...",
"account": "31980005000107125",
"status": "入账",
"result": "受理成功"
}
]
```