XSSFWorkbook 导出模板下拉菜单设置

最新推荐文章于 2024-07-12 09:20:01 发布

chonghuan5167

最新推荐文章于 2024-07-12 09:20:01 发布

阅读量2.8k

点赞数 5

文章标签： java c#

原文链接：https://my.oschina.net/u/3484671/blog/2873618

版权

这篇博客记录了如何在Java或C#中利用XSSFWorkbook为Excel2007版创建下拉菜单模板的步骤，适用于需要导入带有下拉选项的Excel模板的需求。

摘要由CSDN通过智能技术生成

package test;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.DataValidation;
import org.apache.poi.ss.usermodel.DataValidationConstraint;
import org.apache.poi.ss.usermodel.DataValidationHelper;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.xssf.usermodel.XSSFDataValidation;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Demo {
	public static void main(String[] args) throws IOException {
		XSSFWorkbook workbook = new XSSFWorkbook(); 
		XSSFSheet spreadsheet = workbook.createSheet("Sheet Name");
		String[] strs = new String[]{"aa","bb","cc","dd","ee","ff","gg","hh","ii"};
		CellRangeAddressList regions = new CellRangeAddressList(0, 9, 0, 0);  
		DataVali