程序环境:
- 测试文档:Office Excel 2013
- 编译环境:IntelliJ IDEA 2018
- JDK版本:1.8.0
- Excel库:Java系列free spire.xls.jar 3.9.1
import com.spire.xls.*;
import java.awt.*;
import java.awt.image.BufferedImage;
import static java.awt.image.BufferedImage.TYPE_INT_ARGB;
//java项目www.fhadmin.org
public class SingleWatermark {
public static void main(String[] args) {
//加载Excel测试文档
Workbook wb = new Workbook();
wb.loadFromFile("test.xlsx");
//设置文本和字体大小
Font font = new Font("仿宋", Font.PLAIN, 40);
for (int i =0;i<wb.getWorksheets().getCount();i++)
{
Worksheet sheet = wb.getWorksheets().get(i);
//调用DrawText() 方法插入图片
BufferedImage imgWtrmrk = drawText("内部专用", font, Color.pink, Color.white, sheet.getPageSetup().getPageHeight(), sheet.getP