POI导出Excel划斜线

最新推荐文章于 2023-03-03 11:29:23 发布

Edens_Song

最新推荐文章于 2023-03-03 11:29:23 发布

阅读量7.2k

点赞数

分类专栏： JAVA学习文章标签： excel string class c

本文链接：https://blog.csdn.net/sony87615/article/details/7929455

版权

JAVA学习专栏收录该内容

36 篇文章 0 订阅

订阅专栏

public class Test
{
	
	/**
	 * @param args
	 * @throws FileNotFoundException 
	 */
	public static void main(String[] args) throws FileNotFoundException
	{
		HSSFWorkbook workbook = new HSSFWorkbook();
		HSSFSheet sheet = workbook.createSheet();
		
		HSSFRow row = sheet.createRow(0) ;
		row.setHeight((short) 500) ;
		sheet.setColumnWidth(0, 4000) ;
		
		HSSFCellStyle cellStyle = workbook.createCellStyle() ;
		cellStyle.setWrapText(true);
		cellStyle.setAlignment((short)2) ;
		cellStyle.setVerticalAlignment((short)1) ;

		
		HSSFCell cell = row.createCell(0) ;
		cell.setCellValue("姓名            密码") ;
		cell.setCellStyle(cellStyle) ;

		//画线(由左上到右下的斜线)
		HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
		HSSFClientAnchor a = new HSSFClientAnchor(0, 0, 1023, 255, (short)0, 0, (short)0, 0);
		HSSFSimpleShape shape1 = patriarch.createSimpleShape(a);
		shape1.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE); 
		shape1.setLineStyle(HSSFSimpleShape.LINESTYLE_SOLID) ;
		
		OutputStream outputStream = new  FileOutputStream("C:\\test.xls") ;
		try
		{
			workbook.write(outputStream);
		}
		catch (IOException e)
		{
			e.printStackTrace();
		}
		System.out.println("generate  excel success ! ");
		
	}
	
}