package com;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.handler.WriteHandler;
import com.alibaba.excel.write.metadata.WriteWorkbook;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder;
import org.apache.poi.ss.usermodel.*;

import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.net.URL;
import java.util.ArrayList;
import java.util.List;

public class EasyExcelImageWriter {
    public static void main(String[] args) throws Exception {
        String fileName = "test.xlsx";

        // 创建示例数据
        List<ImageData> dataList = new ArrayList<>();
        byte[] imageData = downloadImage("<https://image.baidu.com/search/detail?ct=503316480&z=0&ipn=d&word=t%E5%9B%BE%E7%89%87&hs=0&pn=0&spn=0&di=7360350738658099201&pi=0&rn=1&tn=baiduimagedetail&is=0%2C0&ie=utf-8&oe=utf-8&cl=2&lm=-1&cs=3247076483%2C2757966786&os=1048851285%2C2802536375&simid=3247076483%2C2757966786&adpicid=0&lpn=0&ln=30&fr=ala&fm=&sme=&cg=&bdtype=0&oriquery=t%E5%9B%BE%E7%89%87&objurl=https%3A%2F%2Fimg95.699pic.com%2Fxsj%2F1b%2F4t%2Flw.jpg!%2Ffw%2F700%2Fwatermark%2Furl%2FL3hzai93YXRlcl9kZXRhaWwyLnBuZw%2Falign%2Fsoutheast&fromurl=ippr_z2C%24qAzdH3FAzdH3Fxf3_z%26e3Bmllrtv_z%26e3Bv54AzdH3Fp7rtwgAzdH3F8k9pso_z%26e3Bip4s&gsm=&islist=&querylist=&dyTabStr=MCwzLDEsMiw0LDYsNSw3LDgsOQ%3D%3D>");
        dataList.add(new ImageData("图片测试", imageData));
        CustomImageWriteHandler customImageWriteHandler = new CustomImageWriteHandler();
        customImageWriteHandler.afterWorkbookDispose(new WriteWorkbookHolder(new WriteWorkbook()));
        // 使用 EasyExcel 写入数据和图片
        EasyExcel.write(fileName, ImageData.class)
                .sheet("图片测试")
                .registerWriteHandler(customImageWriteHandler)
                .doWrite(dataList);
    }

    private static byte[] downloadImage(String urlString) throws Exception {
        URL url = new URL(urlString);
        try (InputStream inputStream = url.openStream();
             ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream()) {
            byte[] buffer = new byte[1024];
            int length;
            while ((length = inputStream.read(buffer)) != -1) {
                byteArrayOutputStream.write(buffer, 0, length);
            }
            return byteArrayOutputStream.toByteArray();
        }
    }
}

package com;

import com.alibaba.excel.EasyExcel;
import org.apache.poi.ss.usermodel.ClientAnchor;
import org.apache.poi.ss.usermodel.Drawing;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.ByteArrayInputStream;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Base64;

public class EasyExcelWithBase64Image {

    public static void main(String[] args) {
        // 准备数据
        String filePath = "exampleBase64.xlsx";
        EasyExcel.write(filePath, null).sheet("Sheet1").doWrite(new ArrayList<>());

        // 插入图片（使用 Base64 字符串）
        String base64String = "iVBORw0KGgoAAAANSUhEUgAAAkQAAAEsCAYAAAAir6zwAAAAAXNSR0IArs4c6QAAIABJREFUeF7tnQncdtW4/39HaRIKlVJSSeR0SoOcCEVHUkpJppIpQoPpr1HmDCdSp4QGilSadCKFyhApGpAUydA8kjKE479/rO2s9rmf97mHvffae6/v9fk8n/d9n+fea13ru9b73L97rWtd178IgwAEIAABCEAAApkT+JfMx8/wIQABCEAAAhCAgBBELAIIQAACEIAABLIngCDKfgkAAAIQgAAEIAABBBFrAAIQgAAEIACB7AkgiLJfAgCAAAQgAAEIQABBxBqAAAQgAAEIQCB7Agii7JcAACAAAQhAAAIQQBCxBiAAAQhAAAIQyJ4Agij7JQAACEAAAhCAAAQQRKwBCEAAAhCAAASyJ4Agyn4JAAACEIAABCAAAQQRawACEIAABCAAgewJIIiyXwIAgAAEIAABCEAAQcQagAAEIAABCEAgewIIouyXAAAgAAEIQAACEEAQsQYgAAEIQAACEMieAIIo+yUAAAhAAAIQgAAEEESsAQhAAAIQgAAEsieAIMp+CQAAAhCAAAQgAAEEEWsAAhCAAAQgAIHsCSCIsl8CAIAABCAAAQhAAEHEGoAABCAAAQhAIHsCCKLslwAAIAABCEAAAhBAELEGIAABCEAAAhDIngCCKPslAAAIQAACEIAABBBErAEIQAACEIAABLIngCDKfgkAAAIQgAAEIAABBBFrAAIQgAAEIACB7AkgiLJfAgCAAAQgAAEIQABBxBqAAAQgAAEIQCB7Agii7JcAACAAAQhAAAIQQBCxBiAAAQhAAAIQyJ4Agij7JQAACEAAAhCAAAQQRKwBCEAAAhCAAASyJ4Agyn4JAAACEIAABCAAAQQRawACEIAABCAAgewJIIiyXwIAgAAEIAABCEAAQcQagAAEIAABCEAgewIIouyXAAAgAAEIQAACEEAQsQYgAAEIQAACEMieAIIo+yUAAAhAAAIQgAAEEESsAQhAAAIQgAAEsieAIMp+CQAAAhCAAAQgAAEEEWsAAhCAAAQgAIHsCSCIsl8CAIAABCAAAQhAAEHEGoAABCAAAQhAIHsCCKLslwAAIAABCEAAAhBAELEGIAABCEAAAhDIngCCKPslAAAIQAACEIAABBBErAEIQAACEIAABLIngCDKfgkAAAIQgAAEIAABBBFrAAIQgAAEIACB7AkgiLJfAgCAAAQgAAEIQABBxBqAAAQgAAEIQCB7Agii7JcAACAAAQhAAAIQQBCxBiAAAQhAAAIQyJ4Agij7JQAACEAAAhCAAAQQRKwBCEAAAhCAAASyJ4Agyn4J/BPAoyVtI+kqSX+tYFlE0tqSvifpb+FnC0t6gqRLotffT9J6ki6V9JfwOq+x9SVdLune8L0NJN1f0iGSbmEKIAABCEAAAqkJIIhSz0Da/h9QCJXnSdpZ0jMSuPIHSUsk6JcuIQABCEAAAvchgCDKb0F4F2czSTsGMZRakDxY0l35TQMjhgAEIACBLhFAEHVpNpr1ZV1JLwlCaJkRXf2PpJsl/VzSbys/X1HS8pKul3RD+Fn5Pf/b37c9QtIKkm6UdF34nv/t798k6dehndUkee2dXvS3U7PDpnUIQAACEIDA/AQQRPMz6vMrli3idvYJO0JrzjGQKyUdJelYSbf2ebD4DgEIQAACEJiWAIJoWnLdf87HYmdJWmiEq3dLOl7SMZIu7P5Q8BACEIAABCDQLAEEUbN8U7Tu21vvL+Jy3jSi829KOlLS5yU5oBmDAAQgAAEIQCDEcQBiOARWl3RSEZuzTjQkX6E/sbgav3+IDxrOaBkJBCAAAQhAoCYC7BDVBLIDzewq6SBJi0e+fFvSC6Kg5w64iQsQgAAEIACB7hFAEHVvTib1yLe/vCv0lOhBJ0V8h6QDJfn2GAYBCEAAAhCAwAIIIIj6vTy2lnSyJGeNLs3X5p8fskX3e3R4DwEIQAACEGiJAIKoJdA1d7O0pENDXqG46aMl7Sbp9zX3R3MQgAAEIACBQRNAEPVvercKN8WcY6g01wh7V1Ef7L39Gw4eQwACEIAABNITQBCln4NxPXB26U9J2qLywGcl7V583TFuQ7wOAhCAAAQgAIH7EkAQ9WNFPFLS1UWQ9KKRuy6z8fKQfLEfo8BLCEAAAhCAQEcJIIg6OjGRWxZBF0taK/qey2zsIek33XcfDyEAAQhAAALdJ4Ag6v4cOau0b42VdkCIF+q+53gIAQhAAAIQ6AkBBFG3J8q5hCyASnOhVucWwiAAAQhAAAIQqJEAgqhGmDU3tX1IuFg2650iZ53GIDAXAadj8O3DjYr0C7dLum0MVP4dsGpR++4uSZdLukGSby1iEIAABLIigCDq5nQ/TdJXimv0LtRqcwzRxpL+1E138aphAptIeoSkBwTB4xuH/nqYpOWiv8cJOmdx6XeSbom+HMAf/7v8u79v4fW3WTrjWQhAAAJdIIAg6sIs3NeHZ0k6M8o+/StJ6435ab97o8GjWQg8RtLnJK07SyMNP+vSMN6Jski6SdKtFfFkkebs6Rb4CKeGJ4PmIQCB6QkgiKZn18STb5P0/qhhv4GsLemHTXRGm50l8HBJ75T0qiKA/n4TeOkM5b556J0kH3tZiPx1nueXLBJ9rlj0598F3oH0ztNCE/Q57kt/K+kLknz0a3HEbue45HgdBCDQCgEEUSuY5+1klZB9etPolS7Q+r5KUPW8DfGCXhOwkNlL0lsKYbxYNBLvwjgP1YWSbgxJOL0TU36VuzN1iQwfxTkWKf6yULJQq37/QVMQt3CzKLJA8hdJRaeAyCMQgEC9BBBE9fKcpjW/yVxX+VT+1eKN7zXhE/40bfJMvwj4WOm1xW7O/kFwlN57d+coSW+X5HidLprj3JYPfj9E0grh745tWkmS4+Espub6XeNd0AvCMfEXixQTP+riIPEJAhAYPgEEUfo53qV4Q/l45MYHwi5Bes/woA0CvjnoGnSPrnR2uiQfoXpnqO/24FByZrtil2vzcKQ315g83q9LOkbSd/o+cPyHAAT6QwBBlH6udi0+UR8e3PAbwdPTu4QHLRDYtojzcV4pB8zH9t2Qhdx/DtG8o+Sj4edIcmoJ75DOZWcV6QDeJOknQwTBmCAAgW4RQBCln48jwvGYPXmzpA+ndwkPGibwtSAK4m68M/LW4kbZGQ333bXm15f0XElbFvFETxjhnI/UfJT2n2HnqGv+4w8EIDAQAgii9BPpY4EnBTeeWeQb8pslNlwCFrxvjIbnwOj9QqzQfDfChkvlHyNzrqVXhF2hpUYM9hJJPlI+ZYzbc0NnxfggAIGaCSCIagY6RXP3SFoiPOdMwxRsnQJiTx75SDG/e0a++ljMSRf/0BP/23TTR8e+bbfFiIDsX0g6uBBQn5TkG2sYBCAAgZkJIIhmRjhTAw6k/WlowSUT/AkZGyaBQ4sEhm+IhnZ0yDNEssIFz/ca4SjxpUUdv0UrL70zBF/7Jt6Ph7lsGBUEINAWAQRRW6RH9+NbNyeHHzmA1J+GseERqIqhz0rakczNE020r/HvHtIT+Hp/1XxTz0ePGAQgAIGpCCCIpsJW20PvCrln3KAzVO9dW8s01BUCVTFkAbxDkVvIyRaxyQn4ePmV4ejRRWlje1lRqPbYyZvkCQhAAAJzJ0uDTTsEnKXXN2xsL5J0Qjvd0ktLBD4h6dVRX75B5uv2uQdP14HfJU2eH1JWPDRqcGdJn66jA9qAAATyIsAOUdr5dnDoysGFNYudgyvTukPvNRLwTpCPREv7sqStimMdl2TB6iPgEicuA/KU0KRjsl7Mh4v6ANMSBHIhgCBKN9Pe+vcNM5t3DBbhGCXdZNTcc7zz56YthrYOBVdr7ormwi3NcyVtGIki7xQN7fjMvyMcZ3jNPPFnzgzu+oguCu1bq/5ycV0MAhBYAAEEUbrl4U+03wzd++qwC3ti/SeweHjzcUZmm/NMOTPzH/s/tE6PYMmQuHHdgYkir6fNwlGrb9otNOUseOfMoqgUSL6hF/+7/L7/9Fr1zyzkMQhkQwBBlG6qHx8VsvTRmT/RYf0nsJukQ8Iw/MbiwqZ3939YvRiBd0a8U9R3UeRiuduE7N0W0z4WTGG/DuVlPl9c+PhTCgfoEwJtEkAQtUn7vn3FguiK4vr9v6ZzhZ5rIuBA359F4tZ5hw6rqW2aGY+ARZF3XtcKL/fOSNePzyx4/kPSE8OR2KgSJuXoncTzpui4fRSVFcIRvHeBvKPkrN9l8tfxKN73VW7Hx48fKy5/XDVNAzwDgT4QQBClmyUEUTr2TfXsyvUnhsb9JuJEm2Shbor23O06T9EFRWD1YyNR5KzXXawT+O/hqK88Yq2O6l5J54R6bv9d3Fq8fkqcFuu+jWdxNOrrgdHPN5C0miQ/UzVzdf1Fdo2mnAge6y4BBFG6uUEQpWPfVM+XS/q30LhzTB3QVEe0Oy+BZYvYrW9Icqbr0vYpsl0fOO+T7b3Ax6leMz4ii81Z613Q1mkaXNswhaj2Tpt31pw2wr+rquZYo+OCWPsSF0LaWzT01BwBBFFzbOdrGUE0H6F+/dy1t84LLvtT/cMleZcIS0fAc3BZcdTjLNc2x3R51+6OdC79s2fvCH1dkneIbD7a8/Hqp4r0DN/vgH+xC74A8lpJ24ejuKp7F4fjvo65jTsQmIwAgmgyXnW+GkFUJ830bZ0p6TnBDR8p7JreJTwIsXnehSmPf04KmcJTw/Huim+NlWLICVq9hrps3jXaSdIulZhHizmLzlu77Dy+QWA+Agii+Qg19/NYEN0u6WHNdUXLDRPwsYyTavr/k0tyOP7CNwexbhDwja3TIleeJ+n0hK7tVTm6c3zTQQn9mabrjYrj4VOj3bc3FrFJB0/TEM9AoCsEEETpZsJZix0jYPNWvvONYP0k4Mr1Lw+unxJKSvRzJMP12jtDPvKx+chs9URHZ94Jshgrf/ceI+kVPcX+quII8pPBd+/CrdPTceA2BP5OAEGUbiHEO0S+ObJiOlfoeQYCDoh1vpYyYZ5v6HxvhvZ4tBkCvnn20yJHlP+0WZR4p6hNc3ker43yw49jiJ7R49p2ToZpcVnekHO6AMdsYRDoJQEEUbppI4YoHfs6e/Y1ZB8f2Jz/5ql1Nk5btRKoHp3tIMk7R22Yb5Q5WHql0JnF2fqS7mqj8wb7cJoJp5uwfbTIhL1ng33RNAQaJYAgahTvAhtHEKVjX2fPvn7sYFObs1T/V52N01btBE6IgqrbOjpbNIhl7x7afPvQ2bSHEGe2pSTnR7I5qNq3+P5c+6zRIARaIIAgagHyHF0giNKxr7PnG8MVe7fpuBRnqsa6S6B6dPbVUCusSY/j+CWXwNgk1Lhrss+22vZR8W0h2aP7TB2w3ta46WeABBBE6SYVQZSOfZ09/06SYylsS4fimXW2T1v1E6genX2guNjgm19NWPVG2fOLsiIOvB+S+ahs9zCgn4dblkMaH2PJhACCKN1EI4jSsa+r50WiopfOxTKq1EFdfdFOvQS+JenJockfFNfy1663+b+3Vr1R9s7im+9ooJ/UTTr/VplDycdl/n+BQaB3BBBE6aYMQZSOfV09O17iutDYzdHRWV3t005zBJxg8NOheZeeKJNq1tXjhpLOjyrVDzkdg2/I+qalzXFELpuCQaB3BBBE6aYMQZSOfV09e1ehvGZ8RSV7b1190E4zBDYNdcLcuoWL43rqMmdtdiqNMhXDd0L7jh8aosWCyB8Qypt0QxwrYxowAQRRuslFEKVjX1fPziHjoFybc8q4nhnWDwLOmXNJcLXupIInS9outO0Ys1VD4HE/yEzuJYJocmY80UECCKJ0kxILIt/ScJ4SrF8EnMfG17htQz4S6desjOftoyRdG176K0krj/fYvK9yu1dHyQq3rZQNmbeBHr4AQdTDScPl/0sAQZRuVTjg8guhe2+lL5bOFXqeksDro7xDHw8VwadsisdaJuDcUc4hZfMuzoNq6j9OVPj5KGlhTc13shkEUSenBacmJYAgmpRYfa+Pd4huCAnN6mudltogcEDRSXlr6L2S9mujU/qojYAL8Za/A31D0DcFZ7F/l/Tt0IBvWz1mIMkX52OCIJqPED/vBQEEUbppIoYoHfu6ej60iA15Q2iMat91UW2vnduj2mY+svbR9Szm0hzOQG3LqYwFgmiWVcOznSGAIEo3FQiidOzr6vlzkl4YGttR0mfqaph2WiHgrOKrhZ68m+P6YtOa63n5uMzm+mSrhMKn07bXp+cQRH2aLXydkwCCKN3iQBClY19Xz/Eb6rMlfbmuhmmnFQIXhwKr7sx5gy6asldXe3cgtQOqbW+T9MEp2+rjYwiiPs4aPv8fAgiidIsCQZSOfV09u0jnUqGxF0U3zupqn3aaJXBOVMdsc0lnT9ndWyR9KDzr/EOPLkqB/HHKtvr4GIKoj7OGzwiiDq0BBFGHJmNKV64KgbN+3AG1F07ZDo+lIRDfCJtW0LpYrK/vl7fUnAH7uDTDSdYrgigZejqukwA7RHXSnKwtBNFkvLr4amcgflJwDEHUxRlasE9HSHpNeIlTKBw+xRAOkbRbeO5HRT6qtaZoo++PIIj6PoP4/3cCCKJ0CwFBlI59XT0jiOoimaadA6Mq906Z4NQJk9jqkq6MSnS4HMh5kzQwkNciiAYykbkPA0GUbgUgiNKxr6tnBFFdJNO048Dnt4auz5C09YRunFbUstsmPHNWEZS9xYTPD+XlsSByXJ2PETEI9I4AgijdlCGI0rGvq2cEUV0k07TziaII66tD1y7S6/pm41qchNEJHh8XbpqN+/yQXvdESd8NA3JCykWGNDjGkg8BBFG6uY4F0a1F/MKy6Vyh5ykJIIimBNeRx5xU08k1badGBVnHcS9OwniUpFeN89BAX7NOsbt2aRjbjZJWGOg4GdbACSCI0k2wt+dPD91TyyzdPMzSM4JoFnrpn/XukHeJbJ+UtMuYLr00uknm6/UuDHvLmM8O8WWbSDo3DOzrkp4+xEEypuETQBClm+N4h4hPVenmYZaeEUSz0Ev/7DSCyEWYr4l2Qd4t6e3ph5LUg22L23WnBA8cV+V/YxDoHQEEUbopI4YoHfu6ekYQ1UUyTTvTCKJ9otto3hVatQjMvieN+53p9ZWSjgzeHC3J/8Yg0DsCCKJ0U4YgSse+rp4RRHWRTNPOpILI1+x/Iul+wd3XSvp4Gtc71WucqfsgSf43BoHeEUAQpZsyBFE69nX1jCCqi2SadiYVRBY/ZZyRr5cvI+mvaVzvVK/vkbRv8Mh/vq9T3uEMBMYkgCAaE1QDL0MQNQC15SYRRC0Dr7m7SQVRnHfoMEm+pYZJZvG6AMJ/fgwoEOgjAQRRullDEKVjX1fPCKK6SKZpZ1JB5MKt5ZXydaOr5mm8706vx0tyLTjbtDXhujMaPMmWAIIo3dQjiNKxr6vnn0taJTS2kSQLJKw/BCYRRI8KRVw9ut9JWqq4XeaEjJjkLN2bBxDPknQOUCDQRwIIonSzhiBKx76unh1H4jdGm99cy5s2dbVPO80SmEQQxbmHzo4EQLMe9qP1CyVtGFx11uqL++E2XkLgvgQQROlWBIIoHfu6ev6GpI1DY3tK+mhdDdNOKwQmEUSOi/GtMts0hWBbGVCiTnzzbo3Qt2/i/SyRH3QLgZkIIIhmwjfTw+tJ+l5o4TpJK83UGg+nIPAaSUeEjj9TJOzbMYUT9Dk1gUkE0Q8l/WvoyZmYnZEZ+weBm6PSQw+VdAdgINBHAgiidLP2tCLF/fmh+79IWrz45Ok/sf4QWD86HrhS0pr9cR1PwzHnOKU7Hijpruj/qv/tkh3YPwg4lqp8L3GOpr8BBgJ9JIAgSjtrd0t6QHDhhUXF7BPTukPvExK4f8hS7D/9prCkpD9M2AYvT0dg3B2iLSR9MbjpwHkH0GP/IOA17yBzGzUZWRW9JoAgSjt9u0k6JLjwzaJA4lPTukPvUxCIq547nuhbU7TBI2kIjCuInGhw7+DiBwvR+7Y07nay1xdL+mzwzB8GluiklzgFgTEIIIjGgNTgSx4kyYVdy18iDrT+cYP90XT9BHzk4jdWG4HV9fNtssVxBZHjhcoPK8+V9N9NOtWztuOLBadLel7P/MddCPyTAIIo/WKIb6+4NEB5kyW9Z3gwDgECq8eh1M3XjCOIFg5HQq5yb/OHmPKIqJujas+rfysE0OWhO8c/PqLIWO2CtxgEekkAQZR+2hyIe0Vw4/dFscjlowDO9N7hwXwECKyej1B3fz6OIHpSlHDT/0/Lm2bdHVV7nsUZqo+TtFN7XdMTBOongCCqn+k0LcZb8ntEcUXTtMUz7RIgsLpd3nX2No4giiu5s4P7v/S9G/QrSb5VZltb0g/qnBzagkDbBBBEbRMf3d8Lohtm10h6dDfcwosxCRBYPSaojr1s9yiZpm+RbTnCP8fFbB2+72zVZQBxx4bSujsfkmSxaDtP0qate0CHEKiZAIKoZqBTNuc4hV8XSf4eHp7fTNJXp2yLx9onQGB1+8zr6DEWO5dKcsHWqt0myckGba5n9ss6Ou55G86Z5mSMzsdk20rSmT0fE+5D4J/JtECRnsA7ioRmBwQ3uK2Rfj4m8YDA6klodeO1/jDoN/Vlgjv+v/euimsbSLoofO92SQ/rhuvJvfCx/sHBi2slrUYyxuRzggM1EGCHqAaINTXh3aHrw5m8k/z5jP6mmtqmmWYJEFjdLN8mWo+TLfr/mf+/VavXfySkUnD/rtf1uCYc6Vmbjhly7JB52XaNytf0bCi4C4H7EkAQdWtFnFTcONs+uMQuUbfmZkHeOLDaSekWCp+UfTXbWcix7hL4giTnFLKN2h3y9+Oj0KMkvaq7w2nNs+2Km3Ynh97uDMf897bWOx1BoEECCKIG4U7RdPzLxp9WVyVmYQqKaR7xm8NSoes3FEcxh6Vxg17HIDDubuwZIT7GTb5I0gljtD3klzjW0btDTg1ie4+k/Yc8YMaWFwEEUffmO64cfVYRw+Ctfaz7BOI3T+/07dB9l7P10DtCjtmzeadomzlIXF3cKls9/OwJxesuy5aYtGhxtf40Sc8ODFzA1cKSRIwZL4qhDR1B1L0ZXUPSj4pPX/40ZuOTaffmaJRHfsO8JPzAx2feLeIooXtz5xgYx+qVNzr9gcMfPKrm408XK/WfNmeq9r9zNBegdrmSTaLB+1aZb5dhEBgMAQRRN6fy3ZL2C675dovzEv2mm67iVUTAV7IfGf69bfhEDaBuEXCuobIWmY9/fJXeux1VcwB1WVfQr1u5W8NozRvHw51bMFsv9OijfGekJh9Ta1NAR20RQBC1RXqyfrw9faWkVcJjDu701W6s2wTiquifk+RK4Fi3CFgMlQkYHf/iOJhR5iKlp4YfnFOU73hWt4bRijfOv2Qx5JplNtcre344ZmzFATqBQJsEEERt0p6sr6eHDLDlUxtFNZUma4lXt0VgnSKrsRP82Tg2a4v6+P2MG0ztFveSdGBo+lBJzmqdk60g6fwohsrHhRaJo44Xc+LCWAdMAEHU7ck9VtKOwcWrQmFJf0rDukuAY7Puzs07i1xDbw/uOUDYx5pz2ackvSz88PWSDu/usGr3zDvTFkPl8a/FvXfIvll7TzQIgQ4RQBB1aDJGuOIt658W9ZaWDj/zFr6v5mPdJfDeIph6n+Aex2bdmadqMPXmks5egHsXFrshG4afPyMcHXVnNM15smbYmV42dHFXEEPmgUFg0AQQRN2f3j0lOWNuad4x+kz33c7WQ1f9Lq9nc2zWnWXgJIy+Ym9bUDB16fHvJC0Z/rFiuJnWndE044kDp11Dscyn5YscT6OKfTOwabV7BBBE3ZuTUR75F/hK4Qc+MvuPSnxRP0aRj5dx/hpum3Vj3l3Nvszpta8kB8DPZctFZXOccbwsYtqNkTTjxcYhPshX7G2+3frU6KZdM73SKgQ6RABB1KHJWIArvvr63SJT7mPDa7yN7e1811fCukfAN5f8pmvj2Cz9/DiY+gbp78Ws/YHC//Yb/lz2nKh6u8Wtc4MN2Zxs0TFVvt1qMytf6vBxPQaBbAggiPoz1S6m+H1J/vRqc3I5iyL/iXWLgK8pXx5c+ms4evljt1zMyps4r9cp4er4ggDERV2vCXnAhgrMtROPjxLBejfau0X+E4NAVgQQRP2a7rXC1ftyW9s7RBZF3jHCukXgHklLBJdc18z1zbD2CVSDqX3c/JV53Ijj9hx47QDsIdorJB0Zds48Pu8IeWfIO0QYBLIjgCDq35Q/U9KXo5IC35Dk7/25f0MZtMd+o3llGKEzITs4lWvL7U+565T5OMg2TjC1X+fr9r52b/u0pJ3bd7vxHquXNZyV2zFDCzpKbNwpOoBASgIIopT0p+87/oXtVk4s4oleOH1zPNkAAf/fslh9Smj7pmKeXA6CEiwNwF5Ak04kWO7w7F3UJHv/GN0PXRC5sK0L3Jbmo3h/qGJtjrE4eMlwCSCI+ju31V9qXw+3aH7f3yENznMH7/5Q0sPCyL4kyQG7WDsE1i94Xxy6ciyX4+/G2QEZsiBygsldI/zOL2Qx5CNeDAJZE0AQ9Xv6Tyhqnu0QDeE6SXtENZj6PbpheO+kfs7tUlpuWY9TzaJvhn1b0kOCA870Xt7SnM+nIQoi/673Ma7jhkrzEa4zUDtfFgaB7AkgiPq9BBYrCoj6WnCZo6gcjY8J/CnQZSSw9AQ+LOmNwY17Ja0r6Yr0bg3WA/N1QVZnei/NsURlYsb5Bj40QbRwuEnmG2Xx7wjXJnONMgwCEIhuFwCjvwQsancqgqx9tTgWRv7U5zISHypKSfhNGEtHYJGQR8rFX22+zeOr+VzFr39ONpHkivblTUy/4btC+5kTdDUkQfQYST5O9/FtaSdLelHIyTQBFl4KgWETYIdoOPPr3SIXrnxLIYTuHw3LeVS8Te4AXywdgUeFXaHyKv4ni+vNu6RzZ5A9Oyu4j5HL9e/yG046eMGEox2CIPLEPaLZAAAUaklEQVQ6c+D0m6IcQ8ZwXLg19z8TMuHlEBg8AQTR8KbYsRNHF0cGG1WG5vpn/uV46/CG3JsRVW8HUtajvql7taSPR7veN4b4GAe1T2p9F0Q+GjtY0gqVgX+tEIebFULJaSAwCECgQgBBNNwl4SKw/ymprFrtkfparSuxH8EvxWQT71IeZYoE72C4uriD4bHpCbwz7I6WLfys2BHdtMgD9espm+yrIPKHoU+EfELx0B1PZbF46pQ8eAwCWRBAEA17ml0D7QPhaMYZe0u7pAi4fjlVrJNMvguF/qBI/OcjNJt37Fbh2vNUc+HfX36j9+5QaZeGXZBxrtfP1anbs7CwOQmqj926bEsWzjkNx+6V43InovSt09O77Dy+QaArBBBEXZmJZv14Yrhy69IfsbksgRPVOb6ImIJm5yBu3cHVFqXl/78rQ/2oWd7E2/O+Gz05TsjxQj52LO28ot7fVjWIS4uhUmR1vZaZg6O9Exwfjzlr/UHF+vLOGYH73ViveNEDAgiiHkxSTS56h8j1tN4X3cApm/ZRmj9F+lqyr+xzFbcm6AtoJn7T9ct8zOP4jl8033Xve/ANMt8k842y0nwc5KPIOkrY+GKCb2fanKvHJS26Zj5q/dgI3/zhxsH6zruEQQACExBAEE0AayAv9fXby0LW3lFD8nV9F7/0NWVfz71zIOPu4jAcz/WeaKfolpA1eJpA4C6OrwmfnFvI6/MJUeO+sfeaGuPiuhxD5OOxdxUZt3er3B5zaZg3h3xDTXCnTQgMngCCaPBTPOcAXfV7PUlbS/KR2qi14HIH3wo7RxZH0wap5kt5/pHXdVV8/p76/YoHS/JFAcfElakLPCLn2tqv5qF1VRC9NOxcxTmF/H/0sGJnbN8i5cbdNXOgOQhkRQBBlNV0zznYZUIshrP5+naOEwmOMgcDl0drjoHB6iHgox8fVzrg2uYjyxdzK0iLF7FWzw1JBB3YXF2XTZVB6Zog8vGYd8GqqTQuCrFO/n+JQQACMxJAEM0IcICPOz7Dbz4OTt1uRLxROWR/Mr22iNv4SXFc4Zwv3rIf9UWx2fEWiQPeXfOsTJPgXDE+BvIbYU7mYGnX13I8kEtLxLtBJQez2av42QcbAtMVQeRbos5Ab+G3UDRWB997/EfVeEzYEEqahUB/CCCI+jNXKTz1m5N3L7xz5E/qj5jCCQdszyWWYiHl+JnczVfxfVOqvJJvHr5O7dtCQzb/HnLgsnfFXGajLMgaj9nB0o4d8k7alxrO3ZRaEJXleCz44jxiFoIWQRZD3Egc8v8IxpaEAIIoCfbedupYI4sj5zspa0XVNRj/svfVf8cpnVEcBVxf+fL3c7hC7DdA7xTFKRLqDhqua85mbWf9cBy2wxxi22vCt7yOl/T5Yt3dMWuHYz6fUhC5xp3n2//XYvOxmFMB+JgMgwAEGiCAIGoAaiZN+hO9Y10c4Ll8+NN/L7/K780VjzQNpt9WRJIzPN8Qvlf+6V2nvptjibwTUr1W7h2UvqdEcLHRlwQhtPocE/V9Sc7o7S/Pa9uWQhAtFW4cvrZyPHaXpP0l/Re5wtpeBvSXGwEEUW4z3v54fU26KpJGCadRxyTTemuhFIsl7zb5jbX8njP4Or1Al83HlRYEjuMqzcckLyiOl87tsuMjfFspxARZ0Dkp5Shz3hyP97MhJ1PKIVqUOMePzcdzz2nQGf8OdtZ4J0j15YbYvDPmq/Q+csYgAIGGCSCIGgZM82MTWDQqYeFYJX85+2759/jPOo7r4t2mcnepekx3c+JP5f7/eWgIqo1BflfSgWEXaWzAE77QQbzOeeOgZn+Zefn3Ud/zjTC/Jn6ddz18LGZRPMq8m+fq6yeGzN0TutjYyz9S1P3bM7TuSwOPa6gnB40fHj4wxF1cHQLqz2+oX5qFAARGEEAQsSz6SMBvtBZL/lqxIpq8++QdCR/Z1WFOTOk3e+d48fHFfGZB4N0uH23VFSi+3BwxW/dKsrBzkdhJzYLHfvq2oHfOPMZY6Cw8aYNjvv62EA/k3SDnuOpi5XXHNLksiM0ZxOc62htzyPd52YYhn5Jv0VWFotfMAaHsxl+maZxnIACB6QkgiKZnx5PdJ1AVS+WuUyykvAuCNU/ApTZ8DOWbYl1/s/eaKEWmhXCZH2paShbojktyYknHUI2y70iyECP56bSUeQ4CMxJAEM0IkMd7T8Bvfn7DKkVSfEznXabHh6Oj3g90wgH4xp9zSFW/LBAcfxV//54Rryu/t7QkFxFOERw94ZDv83If55UZoS2kJ/XfIsrxXjuFwr2jftdeLumkIu+Xj0C/NouzPAsBCMxOAEE0O0NaGD4B183y0dS4ZlE16RvouG2Xr/Nxl4NxXc7BCfxis2hxcPLRRUFfH1HNZRZ8jt3ysWBV1OSQ4mBBzC1QnLXd5jI33tmaz3wM6aSSFkEuibPYiAcstMq5uXK+Bvk5BCDQHgEEUXus6QkCTRDwTsSuhWB744jgXIuaY8INJt+sw8Yn4GD2N4SXm+3BC3h03XAc5lt0cSLF8hHvpp0m6diQY8q7bxgEINAxAgiijk0I7kBgSgLe6fGO0VuLN95VK204cNpBwu8rjnF+PGX7uT1mkekbYDYnStylAsDHaWVckI9Vq2bR46zjvkXnwsjegcMgAIEOE0AQdXhycA0CUxC4X8j54/IOcbZrN+UbXWcGYXThFG3n9MjTJJXX3r9dHJk9Odz0c14oH4k5aaZZV82C0yLIu0FNH5vmNB+MFQKNE0AQNY6YDiCQjIAL9O4ryVe9q+YcS44xsjC6TBJHavcl5KMvM7I5iPyUUGx2VA4sp1dwGgELIWfZxiAAgR4SQBD1cNJwGQITEti4yIu0d3Gb6dkLeM51wiyMLgl/+u8O+s013sXJGC1unJ9plDk+yzX3vBP05ZDPacJp4eUQgECXCCCIujQb+AKBZgmsXSSyPDJkjx6nJ7/p+2q4vy4NQsl/73rZk3HGNuo13hXyrT3nCxpVYqQsNltm154mIea0vvEcBCDQMAEEUcOAaR4CHSSwpSRXVV+tKP/hlAIOCh63CK9FgXeOLIzK3ST/2VYl+hinf3/FGbbj0iKjvu/vlSVGytf6376p55tiC8pu7niinYvA9V92cD5xCQIQqIEAgqgGiDQBgZ4TcJkOiyKLI++M+E9/TZKh2WUnfL3chUh9q60Oc9Cyd21c6NZ15uxnLHpG5fmpo1+34UK6txa38x4bGvxNkcJg5THLt9TlA+1AAAItEkAQtQibriDQMwKrjBBJzto8ZHN9tQ+F+CDfLPO/S3NyRsdh1SX4hsyRsUGgdwQQRL2bMhyGQFICLkjq46V4J2kNSal+l5Q7U3EpkWppEf9svu/59piP/qp5mvaoJGV0DNark84AnUMAAo0QSPVLrJHB0CgEIJCEgI+xninpXknX1ezBUpKWCWkBRtVWc0xT0/bhkAm87McZrA9rulPahwAE2iWAIGqXN71BAAL9I+BYpi+FOmX23kdmm4VM1P0bDR5DAAIjCSCIWBgQgAAE5iewZKhKv2Z46V2SNpB09fyP8goIQKAPBBBEfZglfIQABLpAYKWQbmDp4My1ktaTdGcXnMMHCEBgNgIIotn48TQEIJAXAd88c9FWpwKwXVD823XPuHmW1zpgtAMkgCAa4KQyJAhAoFECzmbtbNWlcfOsUdw0DoF2CCCI2uFMLxCAwLAIfFDSW6Mh7Snpo8MaIqOBQF4EEER5zTejhQAE6iHg351nRTfPXAR3C0ln19M8rUAAAm0TQBC1TZz+IACBoRBwMseLJJU3zxxHtL2k04YyQMYBgZwIIIhymm3GCgEI1E3AN89+JOlBoWHvFL1e0hF1d0R7EIBAswQQRM3ypXUIQGD4BDYPx2fxSB107RIfLi2C5UfA2c1fF3YQn5rf8Ps5YgRRP+cNryEAgW4R8FHZoZKWi9y6XNLWkn7ZLVfxpmECB0raK+rjxZI+13CfNF8DAQRRDRBpAgIQgECouXaKpI0jGr+RtJ2kcyE0eAKPCjcNnxuN1BnNvUNkcYx1nACCqOMThHsQgECvCCwkyVfy3xR57biitxfJHN/bq5Hg7LgEFg07QvtIWiR6yMWOXyDpC+M2xOvSEkAQpeVP7xCAwDAJbCvpWEm+iVbamZJeUogl7xpgwyCwuyQfkS0RDefPks6Q5NxU1w1jmHmMAkGUxzwzSghAoH0Ca4TdAf9Z2jUhruiK9t2hxxoJLCvp8HAcGjf7FUm7SvI8Yz0jgCDq2YThLgQg0CsC3iE6QdKWkdd/KAKtXy7pxF6NBGdLAr496GPRpSq7QjtLOh5M/SWAIOrv3OE5BCDQHwJvCzFEjjEq7RBJb5b0l/4MI2tPV5X0qUrQ/N8kOZDeuaduyZrOAAaPIBrAJDIECECgFwQ2LbJan1Rcz39o5O2FkhxvdGMvRpCnkxaxrlt3gKTFIgQ/lbSTJM8hNgACCKIBTCJDgAAEekNgRUmnStog8thBuC4M+24Crjs3j+uE4Pi1KvP1fknvkeSbZNhACCCIBjKRDAMCEOgNAV/NdkDuKyse/1HSpyV9RNJVvRnNMB1dPAiePQqhGh9zfi/sCl05zGHnPSoEUd7zz+ghAIF0BJzN2Fe2R9n5Rdbrj4X4FBeNxdojsImkY4qvlaMu75a0b8hG7rghbIAEEEQDnFSGBAEI9IbA0yW9RdIzKvEp5QB+FYTRJyTd0ZtR9dPRpYubYweHHaB4BOeE3TxyCvVzXsf2GkE0NipeCAEIQKAxAg+S9IqQw+YxI3rxcZrrYfk47YeNeZFvw/sXt/32q2Savj0kV/xMvljyGjmCKK/5ZrQQgED3CTwzXOPeqhK/Unp+QTi68XVvruzPNp9PCSJz/Uozvl7v8it3ztY8T/eJAIKoT7OFrxCAQE4EVgg7Rk4EuNyIgd8g6YhwpHZbTmBqGKtvjTm54uaVtrwTt42ks2vogyZ6RgBB1LMJw10IQCA7AvcPJSJeV0kKWILw1W/nNzqoeDO/LDs6kw14lRDI7qKr8fufxeVxIfXBPZM1yauHQgBBNJSZZBwQgEAOBNaUtJukl0pacsSALwrHaRZI5Mj5X0DLh8SKTnWwcMTNR2IfkOSs4S6pgmVMAEGU8eQzdAhAoLcEHijpZeFIzSKpajdL8s005zu6qbejnN1x1xvbO4hI5xYq7fdBBDntwV2zd0MLQyCAIBrCLDIGCEAgZwLOm7OLpO1HBGE7Z46Pg86T9IsgjiyQyi+XDLE4GJpZ/OxZjO3/VYqwOgj9yLBbRO2xoc36jONBEM0IkMchAAEIdISAj4UcgO1Yo1FB2HO5+duKQIoFUyyc+iAgfBxmBr5Gbx6lWRieWBwj7lPsrF3bkfnCjY4RQBB1bEJwBwIQgMCMBCwKfFPKCR83nLGt+HFnzLZAsrhw+RHvLl1fQ/uPDALOiQ9nKXL7EElrFzFB8dGY3ftiODYjf1MNkzXkJhBEQ55dxgYBCORO4FmSHl9Ua/fNqYeP+PIuyqIDhfT9kEvoGwMdH8OqmQCCqGagNAcBCECgZwS8sxKLJYukqnjy9x7ak3E5l9COkk7uib+42RECCKKOTARuQAACEOg4AR+TWSg9VtKTJV0uyeJjVvMRl3exXEl+FrOws3DzFfo/zdIQz+ZJAEGU57wzaghAAAIQgAAEIgIIIpYDBCAAAQhAAALZE0AQZb8EAAABCEAAAhCAAIKINQABCEAAAhCAQPYEEETZLwEAQAACEIAABCCAIGINQAACEIAABCCQPQEEUfZLAAAQgAAEIAABCCCIWAMQgAAEIAABCGRPAEGU/RIAAAQgAAEIQAACCCLWAAQgAAEIQAAC2RNAEGW/BAAAAQhAAAIQgACCiDUAAQhAAAIQgED2BBBE2S8BAEAAAhCAAAQggCBiDUAAAhCAAAQgkD0BBFH2SwAAEIAABCAAAQggiFgDEIAABCAAAQhkTwBBlP0SAAAEIAABCEAAAggi1gAEIAABCEAAAtkTQBBlvwQAAAEIQAACEIAAgog1AAEIQAACEIBA9gQQRNkvAQBAAAIQgAAEIIAgYg1AAAIQgAAEIJA9AQRR9ksAABCAAAQgAAEIIIhYAxCAAAQgAAEIZE8AQZT9EgAABCAAAQhAAAIIItYABCAAAQhAAALZE0AQZb8EAAABCEAAAhCAAIKINQABCEAAAhCAQPYEEETZLwEAQAACEIAABCCAIGINQAACEIAABCCQPQEEUfZLAAAQgAAEIAABCCCIWAMQgAAEIAABCGRPAEGU/RIAAAQgAAEIQAACCCLWAAQgAAEIQAAC2RNAEGW/BAAAAQhAAAIQgACCiDUAAQhAAAIQgED2BBBE2S8BAEAAAhCAAAQggCBiDUAAAhCAAAQgkD0BBFH2SwAAEIAABCAAAQggiFgDEIAABCAAAQhkTwBBlP0SAAAEIAABCEAAAggi1gAEIAABCEAAAtkTQBBlvwQAAAEIQAACEIAAgog1AAEIQAACEIBA9gQQRNkvAQBAAAIQgAAEIIAgYg1AAAIQgAAEIJA9AQRR9ksAABCAAAQgAAEIIIhYAxCAAAQgAAEIZE8AQZT9EgAABCAAAQhAAAIIItYABCAAAQhAAALZE0AQZb8EAAABCEAAAhCAAIKINQABCEAAAhCAQPYEEETZLwEAQAACEIAABCCAIGINQAACEIAABCCQPQEEUfZLAAAQgAAEIAABCCCIWAMQgAAEIAABCGRPAEGU/RIAAAQgAAEIQAACCCLWAAQgAAEIQAAC2RNAEGW/BAAAAQhAAAIQgACCiDUAAQhAAAIQgED2BBBE2S8BAEAAAhCAAAQggCBiDUAAAhCAAAQgkD0BBFH2SwAAEIAABCAAAQggiFgDEIAABCAAAQhkTwBBlP0SAAAEIAABCEAAAggi1gAEIAABCEAAAtkTQBBlvwQAAAEIQAACEIAAgog1AAEIQAACEIBA9gQQRNkvAQBAAAIQgAAEIPD/AfS/8odgkNSJAAAAAElFTkSuQmCC";  // 替换为你的 Base64 字符串
        insertImageBase64(filePath, base64String, 1, 4);
    }

    public static void insertImageBase64(String excelFilePath, String base64String, int row, int col) {
        try (FileInputStream excelFile = new FileInputStream(excelFilePath);
             Workbook workbook = new XSSFWorkbook(excelFile)) {

            // 解码 Base64 字符串为字节数组
            byte[] imageBytes = Base64.getDecoder().decode(base64String);

            int pictureIdx = workbook.addPicture(imageBytes, Workbook.PICTURE_TYPE_PNG);

            // 获取第一个工作表
            Sheet sheet = workbook.getSheetAt(0);

            // 创建绘图对象
            Drawing<?> drawing = sheet.createDrawingPatriarch();

            // 设置图片插入位置和大小
            ClientAnchor anchor = workbook.getCreationHelper().createClientAnchor();
            anchor.setCol1(col);  // 图片起始列
            anchor.setRow1(row);  // 图片起始行
            anchor.setCol2(col + 2);  // 图片结束列
            anchor.setRow2(row + 2);  // 图片结束行

            // 插入图片
            drawing.createPicture(anchor, pictureIdx);

            // 保存修改后的文件
            try (FileOutputStream outFile = new FileOutputStream(excelFilePath)) {
                workbook.write(outFile);
            }

            System.out.println("图片插入成功！");

        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}