Compare commits
2 Commits
fix/oil-ca
...
fix/export
| Author | SHA1 | Date | |
|---|---|---|---|
| b429cd1264 | |||
| 5bc3600384 |
@@ -913,12 +913,15 @@ async function exportExcel() {
|
|||||||
'容量': vol,
|
'容量': vol,
|
||||||
'单价': ppdNum ? `¥${ppdNum.toFixed(2)}/${unit}` : '',
|
'单价': ppdNum ? `¥${ppdNum.toFixed(2)}/${unit}` : '',
|
||||||
'功效': card?.effects || '',
|
'功效': card?.effects || '',
|
||||||
|
'使用方法': card?.usage || '',
|
||||||
|
'使用方式': card?.method || '',
|
||||||
|
'注意事项': card?.caution || '',
|
||||||
'状态': meta.isActive === false ? '下架' : '在售',
|
'状态': meta.isActive === false ? '下架' : '在售',
|
||||||
})
|
})
|
||||||
}
|
}
|
||||||
|
|
||||||
const ws = XLSX.utils.json_to_sheet(rows)
|
const ws = XLSX.utils.json_to_sheet(rows)
|
||||||
ws['!cols'] = [{ wch: 16 }, { wch: 28 }, { wch: 10 }, { wch: 10 }, { wch: 12 }, { wch: 16 }, { wch: 40 }, { wch: 8 }]
|
ws['!cols'] = [{ wch: 16 }, { wch: 28 }, { wch: 10 }, { wch: 10 }, { wch: 12 }, { wch: 16 }, { wch: 40 }, { wch: 40 }, { wch: 20 }, { wch: 24 }, { wch: 8 }]
|
||||||
const wb = XLSX.utils.book_new()
|
const wb = XLSX.utils.book_new()
|
||||||
XLSX.utils.book_append_sheet(wb, ws, '精油价目表')
|
XLSX.utils.book_append_sheet(wb, ws, '精油价目表')
|
||||||
XLSX.writeFile(wb, `精油价目表${dateStr}.xlsx`)
|
XLSX.writeFile(wb, `精油价目表${dateStr}.xlsx`)
|
||||||
|
|||||||
Reference in New Issue
Block a user