/// <summary>
/// 下载导入数据地图模板
/// </summary>
/// <returns></returns>
[HttpGet]
public void DownloadMapTemplate()
{
IWorkbook workbook = new XSSFWorkbook();
ISheet sheet = workbook.CreateSheet("导入地图数据模板");
IRow row = sheet.CreateRow(0);
row.CreateCell(0).SetCellValue("项目名称");
row.CreateCell(1).SetCellValue("地图名称");
row.CreateCell(2).SetCellValue("地图类型");
row.CreateCell(3).SetCellValue("经纬度");
ISheet sheet1 = workbook.GetSheetAt(0);//获得第一个工作表
CellRangeAddressList regions = new CellRangeAddressList(1, 65535, 2, 2);//约束范围:c2到c65535
XSSFDataValidationHelper helper = new XSSFDataValidationHelper((XSSFSh
Npoi导出Excel并设置下拉选择限制
最新推荐文章于 2023-10-07 17:29:27 发布