excel 相关问题

[YBFACC]

这里使用 exceljs

特定列设置预设值

sheet.dataValidations.model['A2:A9999'] = {
        type: 'list',
        allowBlank: true,
        formulae: ['"male,female,other"']
};

[YBFACC]

下载

function downloadExcel(workbook: Workbook, fileName: string) {
	const buffer = await workbook.xlsx.writeBuffer()
	const blob = new Blob([buffer], {
		type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
	})

	const a = document.createElement('a')
	document.body.appendChild(a)
	a.style.display = 'none'
	a.download = `${fileName}.xlsx`

	const url = URL.createObjectURL(blob)
	a.href = url
	a.click()

	await new Promise<void>(res => {
		setTimeout(() => {
			try {
				document.body.removeChild(a)
			} catch (error) {
				console.warn(error)
			}
			window.URL.revokeObjectURL(url)
			res()
		})
	})
}

[YBFACC]

这里使用 exceljs

特定列设置预设值

sheet.dataValidations.model['A2:A9999'] = {
        type: 'list',
        allowBlank: true,
        formulae: ['"male,female,other"']
};

168. Excel表列名称

[YBFACC]

这里使用 exceljs

特定列设置预设值

sheet.dataValidations.model['A2:A9999'] = {
        type: 'list',
        allowBlank: true,
        formulae: ['"male,female,other"']
};

时间预设

sheet.dataValidations.model[`${convertToTitle(index + 1)}2:${convertToTitle(index + 1)}99999`] = {
					type: 'date',
					showErrorMessage: true,
					allowBlank: true,
					formulae: [],
					error: '正确例子: 2023/1/1 20:20'
				};