使用JXLJExcelApi生成Excel文档，并且设置字体、颜色、背景等

最新推荐文章于 2025-08-12 23:51:23 发布

longyangyangyang

最新推荐文章于 2025-08-12 23:51:23 发布

阅读量439

点赞数

分类专栏：基础文章标签： excel 文档 file border string 网格

基础专栏收录该内容

19 篇文章

订阅专栏

本文提供了一个使用Java进行Excel文件写入操作的示例代码。通过jxl库创建了两个工作表，设置了字体样式、背景颜色、边框等样式，并尝试添加了公式计算功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文章出处：http://www.dnbcw.com/biancheng/java/ppli253612.html

import java.io.file; import java.io.ioexception; import jxl.workbook; import jxl.format.border; import jxl.format.colour; import jxl.format.underlinestyle; import jxl.format.borderlinestyle; import jxl.write.formula; import jxl.write.label; import jxl.write.number; import jxl.write.writablecell; import jxl.write.writablecellformat; import jxl.write.writablefont; import jxl.write.writablesheet; import jxl.write.writableworkbook; import jxl.write.writeexception; public class testexcel { public static void writeexcel(file file) { try { //创建一个excel文档 writableworkbook workbook = workbook.createworkbook(file); //创建一个sheet writablesheet sheet = workbook.createsheet("report-1", 0); //是否显示网格 sheet.getsettings().setshowgridlines(true); //设置列宽 sheet.getsettings().setdefaultcolumnwidth(9); //设置行高 sheet.getsettings().setdefaultrowheight(500); label label = new label(1, 1, "this is a lable"); sheet.addcell(label); //设置字体 writablefont font = new writablefont(writablefont.arial, 20, writablefont.bold, false, underlinestyle.no_underline, colour.red); writablecellformat cformat = new writablecellformat(font); //设置背景色 cformat.setbackground(colour.light_blue); label label2 = new label(5, 13, "hello new label", cformat); sheet.addcell(label2); writablesheet sheet2 = workbook.createsheet("report-2", 1); writablecellformat newformat = new writablecellformat(); newformat.setborder(border.all, borderlinestyle.double); label label3 = new label(3, 6, "border", newformat); sheet.addcell(label3); formula l3 = new formula(10, 10, "=sum(c4:c5)"); //公式暂未成功，本来准备计算l1与l2的和，并显示到l3,未成功 //writablecell cell = l3.copyto(2, 5); number l1 = new number(2, 3, 3); number l2 = new number(2, 4, 4); sheet.addcell(l1); sheet.addcell(l2); //sheet.addcell(cell); workbook.write(); workbook.close(); } catch (ioexception e) { e.printstacktrace(); } catch (writeexception e) { e.printstacktrace(); } } public static void main(string args[]) { file file = new file("d:/test.xls"); writeexcel(file); } }