alibaba / easyexcel

快速、简洁、解决大文件内存溢出的java处理Excel工具
https://easyexcel.opensource.alibaba.com
Apache License 2.0
32.08k stars 7.5k forks source link

NullPointerException #1527

Closed InspireYi closed 3 years ago

InspireYi commented 4 years ago
com.alibaba easyexcel 2.2.6

代码 EasyExcel.read(file.getInputStream(), clazz, new SingleRowListener(rowProcessor)).sheet(0).doRead();

导入excel报错堆栈

at org.apache.poi.xssf.usermodel.XSSFTableStyle.(XSSFTableStyle.java:64) at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:247) at org.apache.poi.xssf.model.StylesTable.(StylesTable.java:141) at org.apache.poi.xssf.eventusermodel.XSSFReader.getStylesTable(XSSFReader.java:126) at com.alibaba.excel.analysis.v07.XlsxSaxAnalyser.(XlsxSaxAnalyser.java:81) at com.alibaba.excel.analysis.ExcelAnalyserImpl.choiceExcelExecutor(ExcelAnalyserImpl.java:99) at com.alibaba.excel.analysis.ExcelAnalyserImpl.(ExcelAnalyserImpl.java:51) at com.alibaba.excel.ExcelReader.(ExcelReader.java:145) at com.alibaba.excel.read.builder.ExcelReaderBuilder.build(ExcelReaderBuilder.java:193) at com.alibaba.excel.read.builder.ExcelReaderBuilder.sheet(ExcelReaderBuilder.java:229) at com.alibaba.excel.read.builder.ExcelReaderBuilder.sheet(ExcelReaderBuilder.java:221)

请问这种怎么解决?

Alanscut commented 4 years ago

@InspireYi 我在这个项目的代码中没有找到SingleRowListener这个类,也没有在你的报错信息中看到NullPointerException。你能否提供有关这个NullPointerException问题的全部信息,例如错误提示或屏幕截图?请以附件的形式上传问题的所有代码和对应的excel,例如错误提示、屏幕截图、Demo、测试用例、整个项目的代码、对应的excel,等等,以帮助你分析此问题。谢谢!

InspireYi commented 4 years ago

class SingleRowListener extends AnalysisEventListener {

    private Consumer<T> rowProcessor;

    public SingleRowListener(Consumer<T> rowProcessor) {
        this.rowProcessor = rowProcessor;
    }

    @Override
    public void invoke(T data, AnalysisContext context) {
        rowProcessor.accept(data);
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext context) {

    }
}

List list = new ArrayList<>(); EasyExcel.read(file.getInputStream(), clazz, new SingleRowListener(x -> { list.add(x); })).sheet(0).doRead();

InspireYi commented 4 years ago

@Alanscut excel 我没法发上来,不知道是不是excel格式问题,并且不是所有导入都会报错,仅个别

InspireYi commented 4 years ago

<[{"bytes":"UEsDBAoAAAAAAIdO4kAAAAAAAAAAAAAAAAAJAAAAZG9jUHJvcHMvUEsDBBQAAAAIAIdO4kBie5TdOQEAAEMCAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2RwUoDMRCG74LvEHJv0xYRKbspgoqXYsHqPWZnu4HdJGTGpfVZvHgQfANPvo2Cj2F2A7oVT95m8v/8880kW2ybmrUQ0Dib8+l4whlY7QpjNzm/WV+MTjhDUrZQtbOQ8x0gX8jDg2wVnIdABpDFCIs5r4j8XAjUFTQKx1G2USldaBTFNmyEK0uj4czp+wYsidlkcixgS2ALKEb+O5CnxHlL/w0tnO748Ha98xFYZqfe10YrilvKpdHBoSuJLZU2lhxW7Hyroc7E0JZdgurOsFImoMxamregyQWG5iEeYsbZnULoBuS8VcEoS3FQZ0tNX9ceKciP1+f3t8fPp5dMRD299eXQOqzNkZz2hljsG7uAxBGFfcK1oRrwqlypQH8AT4fAPUPCTTjXFQClmUO+fuM46Ve2+Pl9+QVQSwMEFAAAAAgAh07iQIRu/vdFAQAAaQIAABEAAABkb2NQcm9wcy9jb3JlLnhtbI2SUU+DMBSF3038D6TPQlu2GNIwFqeZPjhjIkazt6a924hQSNvJ+PcW2BCdDz6259yv59w0nh+K3PsEbbJSzRANCPJAiVJmajtDr+nSj5BnLFeS56WCGWrAoHlyeRGLiolSw7MuK9A2A+M5kjJMVDO0s7ZiGBuxg4KbwDmUEzelLrh1R73FFRcffAs4JOQaF2C55JbjFuhXAxEdkVIMyGqv8w4gBYYcClDWYBpQ/O21oAvz50CnjJxFZpvKdTrGHbOl6MXBfTDZYKzrOqgnXQyXn+L31eNLV9XPVLsrASiJpWBCA7elTtYPN0/3V96ibPYQ45HQLjHnxq7cvjcZyEXzy3uuO25Xo4eD9Fww1tc4KW+T27t0iZKQhMQnkU+mKZ0wGjFC1u3zP+bboP1FcQzxDyKNUkpZOGWEjognQBLjs8+RfAFQSwMEFAAAAAgAh07iQAMNSqT+AAAAfwEAABMAAABkb2NQcm9wcy9jdXN0b20ueG1sndDLaoQwFAbgfaHvELKPiSnpjKIOVWc2XbTQ6ewlxpmAuZBEWyl990aml32Xh//w8Z9T7N7VCGbhvDS6hGlCIBCam17qcwlfjwe0hcCHTvfdaLQo4SI83FW3N8WzM1a4IIUHkdC+hJcQbI6x5xehOp/EWMdkME51IY7ujM0wSC5awycldMCUkHvMJx+MQvaXg1cvn8N/yd7wtZ0/HRcb61bFN76AQQXZl/CjZU3bMsIQ3WcNSklao+wu2yCyJYTWtDlkD/tPCOy6TCHQnYqnP748RbafeKgnOfYn4SI9h3y0bz64ihJGI5VsE5KwTcoK/JcV+KdCVeC12/Vz1RdQSwMECgAAAAAAh07iQAAAAAAAAAAAAAAAAAMAAAB4bC9QSwMEFAAAAAgAh07iQGB7rbZ/AwAAYhEAABAAAAB4bC9jb21tZW50czEueG1s7VfLbttGFN0X6D8QLJAdzafEoSPJoCwqSdtFF+2q6IKQaEuIRBoc1nVSBHDc+qmoQmvXaRLBtZv4ASSxEiRNbcuCP6acEbXKL/TSlKU4cIGgSNSNBIHQuZp7LjmX58xMYmymXGKmLRcXHTvJiiMCy1h2zskX7ckk+9WXWQ6xDPZMO2+WHNtKsjcszI6lPv4okXPKZcv2MAMENk6yBc+bGuV5nCtYZROPOFOWDf9MOG7Z9AC6kzyeci0zjwuW5ZVLvCQIcb5sFm02lTC/9QqOi89+pLxc8nsVybqhaRlOlRSN0wxF5dKyqnJIELJxJMtpQZdvJfgo9VymoWUFSdXTHMpKOiciBXFIMQQugyRRQzFVlDPKxZlqWo2LmmRwMaTGOC2mxKFcRuOQqklxRRLTMZS9OBMqKbICdyvqus6Nx6GmnjEQl84omiGMqwiJ+huZ3duGJ+5O4+dF7PUA41oTSTYjskz0dNfySVaAafKsGRjkwvcLuOCbzLRZgp4JLA+hrGN7UYDsV/zWahjMFUwXW92wKCthjD9N9sK2jeIpMwc9hb5gy5222NTX7aOT9l6FLh/SF3vfXPpEFC4neKjJh0U/YN3BVfJbm+37PxozOavUXl6i9Sek1ggaTVJbp08fvfn0lxm/tUB25uhGndT36IOXdP1ZlHGW7x88pcur5HiWri/6zVevj++QpXukcRjNHl2e9Vt1GOs3m37rV7p2SFb2Oj+0yLOF4I/HZGmzc+/R37Nz/tFCsPswaOy0mwv+yRa93RhlQilh0NKkM1Iu5lwHOxPeCLwo/MR3paJ9nR8Lr8V8EqmCJimDm7vBVYK3r7O4Mjq4ggx82g9+a88dQrvIyhY00z/aJau36Z+VzmLtrWBnsUo3wsZGI+nBfPBy1z+o0I1XvSAw0JVtWv29F4n4g/0tsvRLLxicrPkn+z3Yma+GVKfMPeXxkfD5rle85RPGOZ8Q2aFPvA8nHPrEf19FBifb/8UnSPUnUr1L69Xg4Typ/Xyq19V3FGv2nFiloVjfy7ZlKNahWC/YzYaLeppuViS6fayTO0ewJIdQBpjuQwXgeB/GAGb6MA7QiKDepcr2YUh1pQ9Dqqt9GFJd68OQ6tM+FAF+BvAdnePKOeeQh84xdI7hceBDnYND5/Cb20HlOZztOrN3Se2vzv219k7z38V6tjuPTvJnCKf+AVBLAwQKAAAAAACHTuJAAAAAAAAAAAAAAAAADAAAAHhsL2RyYXdpbmdzL1BLAwQUAAAACACHTuJA9LuJ8KkCAADODAAAGwAAAHhsL2RyYXdpbmdzL3ZtbERyYXdpbmcxLnZtbO1XTW/aQBC9V+p/sLZXA/6IgSzgqEqbW1upTdVjtNgL3mS9Y3kHY/LrO2ubqhxaIUU5BUuY5e28mfGbZ8ssb9pSe42srQKzYuE4YJ40GeTKbFfs5/3daM48i8LkQoORK3aQlt2k798tHY8+xnIQK7arDbdZIUthR6XKarCwwVEGJYfNRmWSiwxVI5CqsIFWncGqYC/rCpTBI6s9gyXbTOojAc4g9D0eGc3/GE2pWboEbgtRSS0OsEOv4bLFFZO5wm5P5aWoTlAvF0gqhWySLicn5HTZ9Lk8la/YQxvQ8WDDIEqYR4EV5Y2CiHl4qEj9D0MAdpjFgyawAqucsFysLegdyoWWG+RBhQuEqvsuRb1VZtThUTQbRwltDqCLCccOKKTaFsin0/HM/dyrHAseBnG32Sir1korPPBC5bk0C+ZtlNYZaKipszs6Poc9JulSaGIWa3ga1sCVsRJLyKljsUNgXgZQ51Y9ExCF0yDwuzMp2PBKYEFSNdxV8JwzKV1XKfq7FGQ72ycI/MBpS1p2NftYCnVyBuTpR/LQIFepUNZ9sCrFVrrRkNSo0InpNoBryJ5OByhsJTOsnYNXbNPTkca+hpaus5tDrmoKcYPQWC96b4w2Gva8gFo9g0GhF6WFUQ0oUPJgQdeaq+bId+lGQqstJaABuhqThg9F0mXLb7WSBj+5fr+tH6nWfWeKr4CSMrX8CzTyl8LiVmptid3yH6TuKfLRZNRNGvvz2CfF/Ss/DGd0ni0nLR82ifgd9mngILdwpclYpUljBw3rbvmno67X7qb4p6Onr+boeXhx9Ft39JWfhJ2jEz8639BXLzH07LUMHcfJxdAXQ4dR/4xO/Ovrsx/RyUscTS97r/PSEc+vL45+645O/Lg39NSfBWcbenqWoSf0XyT9DVBLAwQKAAAAAACHTuJAAAAAAAAAAAAAAAAADgAAAHhsL3dvcmtzaGVldHMvUEsDBBQAAAAIAIdO4kD/es9NlwIAAHkGAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sjVXbbqMwEH1faf/B8nu55VaikKpNmnalXana67MDQ2LVYNZ2kvbvd7CBQhttm4cYz/E5c/PA4uqpEOQISnNZJjT0AkqgTGXGy11Cf/3cXFxSog0rMyZkCQl9Bk2vlp8/LU5SPeo9gCGoUOqE7o2p5r6v0z0UTHuyghKRXKqCGdyqna8rBSyzpEL4URBM/YLxkjqFufqIhsxznsJapocCSuNEFAhmMH6955Vu1Z6yD+llip0w1zaeXohrh3R64fhNfAVPldQyN14qC9+F9jbL2I8HeRbpG6EzxSqYejxUFyhcYXJbLrh5tunS5cKW8EH5y0XGsQx174iCPKHX4fwuomi3J35zOOneMzFs+wMEpAYy7DUldQ+3Uj7WB7+gKai17YFakaWGH2EFQiT0PsSLof9aJ/UzuvA7H/3n1t/G9v1BkQxydhBmJcUfnpl9QmPa2r7L0z3w3d5gMBNvNqFEHozgJXyFIwhEbZB9G6okdFp7T6VAV/hPCl5fXEoK9uSScm4uvQgF04M2smg8hw3RUUYNBdeTo4TBe5xxw8G15SD9P04wBBsXrg0hetfJtOHg2jqJvOk72cwaEq4taeyF50m+K57t35oZtlwoeSI4LlhFXbF6mMP5DO9CWhuv0Yod0rg/LoOFf8R2pw1208fCIbbqY9EQW/ex0RC77WPjIbbpY5MhdtfHph3mY25dgtHZBCOb2qvwb/Bsl/ask7MlWTnGKA6DVwVZ91mXQ9ZtH4uH2KaPha9EcaRfQglf4nSpuTl0fazYDr4xteOlJgJyjD/wpnE8CibtDy+VciN3BjGyqhn1JG6lwcFpd3t8bwPehcDD655LadoNTqLDNtaIWwE7lj43L0+i5jxLqPqS2beS3300lv8AUEsDBAoAAAAAAIdO4kAAAAAAAAAAAAAAAAAJAAAAeGwvdGhlbWUvUEsDBBQAAAAIAIdO4kBObI0m8AUAACsZAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1ZS28bNxC+F+h/WOy9kWTrERmRA1uPuI2dBJGSIkdql9plxF0KJGVHtyA5FQUKFEiLXAoUvfRQFA3QAA3aQ/9LXSRI0x/RIXe1IiUqfsCHNIjsg5b7zczHGe435OrK1QcJ9Q4xF4SlLb9yqex7OA1YSNKo5d8Z9D657HtCojRElKW45c+w8K9uf/zRFbQlY5xgD+xTsYVafizlZKtUEgEMI3GJTXAK90aMJ0jCJY9KIUdH4DehpY1yuV5KEEl9L0UJuL05GpEAe3+/+OP1D0//evgl/Pvb8xhdCoFSKdRAQHlfRcCWocaG44pCiJloU+4dItryIVzIjgb4gfQ9ioSEGy2/rD9+aftKCW3lRlSusTXsevqT2+UG4XhDx+TRsAhardaq9Z3CvwZQuYrrNrr1br3wpwEoCGCmGRfbZ2OjXc2xBij76vDdaXQ2Kxbe8L+5wnmnpv4svAZl/qsr+F6vDVm08BqU4Wsr+Npuc7dj+9egDF9fwTfKO51qw/KvQTEl6XgFXa7VN9vz2RaQEaN7TnizVu01NnLnCxSshmJ1qRAjlsp1ay1B9xnvAUABKZIk9eRsgkcogMXcRpQMOfH2SRRLFQZtYWTcz4YCsTKkInoi4GQiW/5nEwSPx8Lryxcvjh89P3702/Hjx8ePfjG9W3Z7KI1Muzc/fv3vdw+9f379/s2Tb7LQy3hh4l/9/MWr3/98m3t4mAxa3z579fzZy6dfvf7picP7DkdDEz4gCRbeDXzk3WYJTFBnx+aDh/xsFoMYEcsCxeDb4borYwt4Y4aoC7eL7RTe5aAjLuC16X2Laz/mU0kcka/HiQU8YIzuMu5MwHUVy8jwYJpG7uB8auJuI3Toit1GqVXg7nQCAkpcLtsxtmjeoiiVKMIplp66x8YYO2Z3jxArrwck4EywkfTuEW8XEWdKBmRoLaSF0R5JoC4zF0EotZWbg7veLqOuWXfwoY2ExwJRB/kBplYar6GpRInL5QAl1Ez4PpKxi2R/xgMT1xUSKh1hyrxuiIVw2dzkMF+j6NdBQ9xlP6CzxEZyScYun/uIMRPZYeN2jJKJC9snaWxiPxVjWKLIu8WkC37A7CdEXUMdULq23HcJtsp9shDcAfk0KS0WiLoz5Y5aXsPMWr/9GR0hrFUG1N0S7YSkJyp4FuHitdvB/GJU2+3YyvvLs+n1DifOp2ZvSaXX4f6H2txB0/QWhsdhtTd9kOYP0uy/99K87lm+eEFeaDDIs9oFZvttvftO1m6+R4TSvpxRvC/0/ltA5wl7MKjs9PkTF4exSQxf1ZMMASxcxJG28TiTnxMZ92M0gb17xVdOIpG7joQ3YQLOjHrY6Vvh6TQ5YGF25qxU1PkyEw+B5GK8XCvG4bwgM3S9sThHFe4120ifd+cElO1ZSBjBbBKbDhKN+aBKkj5dQ9IcJPTMLoRF08HisnI/L9UKC6BWVAW2Rh5sqFp+rQomYASHJkRxqOqUlXpeXV3Mi6z0umRaK6AM7zfyFbCodFNxXTs9NbtsqZ2i0hYJY7nZJHRmdA8TMQpxvjrV6GlonLXWzUVJLXoqFXkuDBqNy29jcd5ag92yNtDUVAqaekctv75ZgyUToEnLH8HZHb4mE1g7Qm1pEY3gPVggefbAn0dZJlzIDhJxlnAtOpkaJERi7lGStHw1/aIMNNUaorlVNkAQ3llyTZCVd40cFN0uMh6NcCDNshsjKtPZJSh8phXOu9r8/GBlyaZQ7n4cHnlDOuW3ESyxWqOiEhgSAS94Klk2QwLvJAshW6y/pcaUy675UlCvoWwc0UmM8o5iinkG11Je0NFXRQ6Mq3zOkFAjJXkjHEaqwZpJtbpp0TUyDmu77slGKnOGaC56pqUqqmu6VcyKMG8DS7k8X5M3WM1TDO3S7PCZdC9LbnOudUv7hKJLQMKL/Dm67ikagkFtEcyiphivyrDS7HzU7h3zCZ5A7TRNwlD9+tztUt6KHuEMB4Pn6vxgt7xqYWg031fqTOvfMMzfF9jwPohHB97kTqkUmUBo0PZ/UEsDBBQAAAAIAIdO4kB2WYeWeQkAAH9MAAANAAAAeGwvc3R5bGVzLnhtbNVc22/bVBh/R+J/sDzBw8SW+JIbNB1bmCUeQEgbEhKgyW3cNpJjl8RBLU+DMQpIQ0IMBtMkBmiMB1augmnA9s+QNH3iX+A7F5+Lc5y40DhO81Db8Xf/fd/5js9xVs7sdH3tTa/X74RBUzdOl3XNC9bDdifYbOovX3RO1XWtH7lB2/XDwGvqu15fP7P6+GMr/WjX9y5seV6kAYug39S3omj76VKpv77ldd3+6XDbC+CbjbDXdSM47W2W+ts9z233EVHXL5nlcrXUdTuBvroSDLpON+pr6+EgiJq6zS5p5Jvn23DR1DXCrRW2QZVL2pNvDMLomX8e3SEHJ7UTT504Ub6kPaP46rVTU74k9KfIP0z/7CVNL8V6iUoYSSVEqSc1UcxJqmAmvnaSr9q40+Xp9qV+L5l45sx0I62kMtTImDuzk1+Ywr9Eo7u6shEGPMimAVFGV1ZX+m9pb7o+4M9ETl8P/bCnRQAjiLKBw+B2PXLHwb0PDh48wndtub0+oI8QWja6hrFH7+x2grCHLpaIjIQkzFeSVM4kCd/1v+TkZ1E2SRktWkP+jeNUQb6SvGdl8p7xf+LU21xr6o5jwadWzSTuv5iGDZmnaZIjBRgK5lnOcZrHojYprNEqQxU+TmEzrHPO1p4rzz3TqCuPX1iadbRYHXMSDMSUmwwehK7sHCtSZgisg8B6XsEDXBr5IcVBzpxbHtQR53nWlM50pNQc9JmbeZPQdPBfHgKP1CZkHA+mFsxq5biAghuTPvRAHd9nra9loa4IrqyubLtR5PUCB040enxxdxt6ogBaceTbErlvxt2bPXfXMPGInY2gH/qdNtJisyV2YhjEa/RaJ2h7Ox505VXceJUEXbPqlSKmoWtRB00CyqcrDfiz6o2q2agbZWzB/OXXFiwfJlyx/TUwv25U6/V6w7YM7Og52h8PmpC6rRaCVx6yWq1GIydZpgOfOcui1Qgmc3EMLYhhrVKpV4yGaRvztpXKry5KPsNQq9Y6n7uvF1IvBF8vRL6AtXzrxSTWFiJfGC8WkmvCeJGvfJprrep5J69cqyyqrlCsCfLzzTXq67MV9Mmnrgm4WnReLUR+LR835xRNAbn5epONyOfPNebd1bERYb7NIxUz736YihH68XxrzqT8fMcXKv/ILSueZMK0di3stWFhSaNrOg2YUZJLqyu+txEBRnqdzS30Pwq3EWLCKAq7cNDuuJth4PpwWIop4v9TKGGdCpakmnrXa3cGXZAmPXAh01QiY7aImFe0hZenCCeaSudM9EHVqYS0oWZkpMAmY4szEoBvYtdkpDgOG/kDo6w2ChTZbBQIMtooUByHjWgdgTxoz2qjQJHNRoEgo40CRVYbAYiqRIrR0g4Ha77H0oGNB/AwFz+3gxRDeTc7J2bISUs7NhO20dMMu2aXa3bFrJIEyip7ujGC0xQZqXaAQDMZy5kkimjOpMlqq+zn2HKpEokjYGm2LtLt09Sg5RaK97rn+xdQPX1lg1VwG5XwnQ1hNRx2C6BlVbQ6jw7hQSU9JOWanKyuuH5nM+h6ASzWer2os46Wetfh1CPrszsbCbZkpZ/wRYv+ar6au73t7zogH0snZ3ArPzuHRyB+fjbWg196qRdG3nqEdz+Uwbyjqip4AC2aU00NaPdEFxBVXxx017yegzdEcA3yVRIUi5WECQbXEZTHDlTrOAfH2XjDw1LE2MZ7PpZC1RQ4QnR5qOGeKaHOF47QXMdwNMDLBVLSxntgli3oCKlxDYI4F8ifAjJhlw/T8ghKOnnXdniyGI9uszQuzihkCMNQkZ0r4EFwLjxM55iF61MKlezyOYxQgoZiWgEquIpwzxQVz+Xaf6ACGif/kkQe9UnLpjJAdNlUhk5vyVRGzSEdxyQoA8Sn5JsjjRDzLQlpMCiOhkI5WL6aBe4tSKAFNxrSlKlItV/IcGip+fgEeTTFjfPNENQ+0RyWdMp9qgmBivs4Q5hwwP5zwVPgwYV5SmjZTDjm4SsSxIQ8gM1kRVUSxVo1cIDGU8Kb58ABe4DUKgI0i6KiMPyijCkmIE0h1mZhK7OQ28XNGo5Is7CtguBI2ApZUEyKSsL0tZiJIyhpShPuIg03opKgVzE9KY6Jha2TopLLkDjmMiROYR0pRruoaSPktrUMuW2BUwtfgKxlSBuIfOEdaSx8TCyJq+9kLV5YhkevTR99FV7b2TjCcjzWAGQKGwHkbQBMQy2Ad7Ob+vD+/fHdd3UmRVsbdHx4B4LIhC0NSYLxr3eH999+tfx6TINyjNPg3Z9JGrP8hHZKG/75YPzjldFne8N7Nw6/vjX+4GcNYEXMQznAmVjkvbt4KwNVdfzwk+HVOzEFQiSngDlFqq4xBSr9nALvK0sqOrx25e+/rg3ff+/w5nXBRDQB4JT4tdskpT3TRIROzsTC2/OSXIa/78faookRvx3mSQr7RHVjOtTOcDryUnTCkdWZuqLJBGdiq53729XDTx6OPmIRMdCQwKmUMTz44iF4d/TD9VhdvHrMifCu3kmv/Dzef3R4Y//g5rvjCakydJRuHf3y3eHeh0ykDB1QW+HaVB+BOAJZPJnhmltKWIxu7x1+/bkG0KNEMpTIe0VJe8f3vh1+/CEkyujW94xQhg+4TaE0kcZIZAjBmo2CZHz3G3DN6PLdhDgZRhUljqhxUACocTJsoB4rBFIi5kb0NEBADTyqVRClRoPJxg8FhWjgbWpJx1LZvOrI2IFHJkeRzYKKn/1x2bBDRsEGVa+9B7GrTLkYgfYqkv2vDvZvMBIZOtBtK0hG31wefXlneO3T4dUro9t/MloZPaCwgja1SgMxrdIyoirKzFGUeR5sGVbwzqxCD1JVJm2Q0QUeVNCOftobXf4j1hc3qTww5F3aJCiGd/5i98tjGUyyFSIOL7/z9/17jESGkKmEUKpnIaTEs+AJMQtspWSFZxn+4fc5RAbwOEiheqoenI0MMnCggk3qWMfZyHiDPlzBJlUbBhdLxhv5DZJk/FK14WwSqFMWQoVzWZ2AwVp0LqilMEfBgFUIGEFFBrAxTcEg1R+cjYxP2G6pYJPqD85GxizsmFKwUZjD0Ir2WAk121Y6NFUPzkbGrK10a2rp52xkzNrKFFSYw8oaZJtkjjJ3Us3hbGS0VpRBTjWHs5HRWsFB5jMLaO0jFzaG402+rLcHYLS9DXfgRxfZl02dH7+A360wYQbCiWlb/cLuhTf85wixrtGXPnDel/i9ILXEfzls9V9QSwMEFAAAAAgAh07iQBcMYkkkAQAA0QEAABQAAAB4bC9zaGFyZWRTdHJpbmdzLnhtbG2RwUrDQBRF94L/EGZvp3ahIsmUbtx1px8wpGMTaGZCZhTdiSCoNdZSxaLFKqXUrSBUE8WfyUv6GU5REKbC27x73uVeeHb1IGhZ+yySvuAOWi2VkcW4Kxo+bzpoZ3trZQNZUlHeoC3BmYMOmURVsrxkS6ks7eXSQZ5S4SbG0vVYQGVJhIxrsiuigCq9Rk0sw4jRhvQYU0ELV8rlNRxQnyPLFXtc6dwKIrb0ia0IJB3oTG2siI3nyq866cFVvKB2+zAdz2fRkaUpnD8VLyk8tE1ffnYEg+cs7UHS+59pkJ9+mSz7HGRvd3CRwHBosll3lKU3kFyboLjvF8fvP3VMBvElxLf5IJ6NTqDTnb1OdCnzqJY/ttfz8UddB5usXvtTsH4J+QZQSwMEFAAAAAgAh07iQICfNVU0AQAA9QEAAA8AAAB4bC93b3JrYm9vay54bWyNkU1PwzAMhu9I/Icod5au+9CY1k5CgNgFITG2c2jcJVq+lGR0/HuclgFHTo5j58nr16v12WjyASEqZys6HhWUgG2cUPZQ0bft482Ckpi4FVw7CxX9hEjX9fXVqnPh+O7ckSDAxorKlPySsdhIMDyOnAeLldYFwxOm4cCiD8BFlADJaFYWxZwZriwdCMvwH4ZrW9XAvWtOBmwaIAE0Tyg/SuUjrVet0rAbJiLc+2duUPdZU6J5TA9CJRAVnWDqOvi9mFESTv7upDRWbydFSVn9M+RLIOgJDKitVHH/PX1uyi7sFHTxtz+npFNWuG6vRJIVLRfFAr0d7p5AHWRCuyfFfJYR7A+jNwhZfSS2V/+aTRvjJnLcoEA8h6XCQ9iIcU+4PGu4brJcDH3jdDorhz8uG6u/AFBLAwQKAAAAAACHTuJAAAAAAAAAAAAAAAAABgAAAF9yZWxzL1BLAwQUAAAACACHTuJAezh2vP8AAADfAgAACwAAAF9yZWxzLy5yZWxzrZLPSsQwEMbvgu8Q5r5NdxUR2XQvIuxNZH2AmEz/0CYTklntvr1BUSzUugePmfnmm998ZLsb3SBeMaaOvIJ1UYJAb8h2vlHwfHhY3YJIrL3VA3lUcMIEu+ryYvuEg+Y8lNouJJFdfFLQMoc7KZNp0elUUECfOzVFpzk/YyODNr1uUG7K8kbGnx5QTTzF3iqIe7sGcTiFvPlvb6rrzuA9maNDzzMr5FSRnXVskBWMg3yj2L8Q9UUGBjnPcnU+y+93SoesrWYtDUVchZhTitzlXL9xLJnHXE4fiiWgzflA09PnwsGR0Vu0y0g6hCWi6/8kMsfE5JZ5PjVfSHLyLat3UEsDBAoAAAAAAIdO4kAAAAAAAAAAAAAAAAAJAAAAeGwvX3JlbHMvUEsDBBQAAAAIAIdO4kDl8KIY7QAAALoCAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHOtks9qwzAMxu+DvYPRfXHSjTFGnV7GoNetewBjK39oYgdLW5u3n8ihWaB0l1wMn4S/7yfL292579QPJmpjMFBkOSgMLvo21Aa+Du8PL6CIbfC2iwENjEiwK+/vth/YWZZL1LQDKXEJZKBhHl61JtdgbymLAwbpVDH1lkWmWg/WHW2NepPnzzr99YBy4an23kDa+ydQh3GQ5P+9Y1W1Dt+i++4x8JUITY1N6D85yXgkxjbVyAYW5UyIQV+HeVwVhsdOXnOmmPSt+M2a8Sw7wjl9kno6i1sMxZoMp5iO1CDyzHEpkWxLOhcYvfhx5S9QSwMECgAAAAAAh07iQAAAAAAAAAAAAAAAABQAAAB4bC93b3Jrc2hlZXRzL19yZWxzL1BLAwQUAAAACACHTuJAaR9Jxc8AAAC4AQAAIwAAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQxLnhtbC5yZWxzrZDJagMxDEDvhf6D0T3WTA6hlHhyCYVcQ/oBwtYsdLxguWny93UohQwEeulR29OTtruLn9WZs0wxGGh1A4qDjW4Kg4H309vqBZQUCo7mGNjAlQV23fPT9sgzlTok45REVUoQA2Mp6RVR7MieRMfEoVb6mD2VGuYBE9kPGhjXTbPBfM+AbsFUB2cgH9wa1Oma6ua/2bHvJ8v7aD89h/JgBZ79vM/0VY+rVMoDFwNao/vJyV291bUX8LFT+59ONvqbriyMfpOtrv+7aeDi3903UEsDBBQAAAAIAIdO4kC8fgaOfwEAAO0FAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK2Uy27CMBBF95X6D5G3VWLooqoqAovSLluk0g9w7QmJ8Ese8/r7TgJUAlFCBJtIiTP33Dsz8mC0NjpZQsDK2Zz1sx5LwEqnKjvL2ff0PX1mCUZhldDOQs42gGw0vL8bTDceMKFqizkrY/QvnKMswQjMnAdLJ4ULRkR6DTPuhZyLGfDHXu+JS2cj2JjGWoMNB2MoxELH5G1Nn7dOlkaz5HX7X43KmfBeV1JEMsqXVh1BUlcUlQTl5MKQdEb14yBWFIPxk4AAGrsRdhEyqmxcYFl5fKCc/xDqk/8j7Oo+qfehUpBMRIgfwlBQTiEmwXnkFDk7r9LeCKh7qkClniQhxAr+PJ9lSxegO3zfo7q6M3GB0ZnuzKPJy0bmQvha0zKaemOwfzUZfQChsASIRmd73f2GnOo24bEUAdRXDLSqeGMLB9ptPuJGw80NNKIt5EiXBvDmef0MGpkW4MqF+Y9z85t3mwafGVHZC/jNliBNn2quT324eXW+RnjvgzeX9fAXUEsBAhQAFAAAAAgAh07iQLx+Bo5/AQAA7QUAABMAAAAAAAAAAQAgAAAAgSQAAFtDb250ZW50X1R5cGVzXS54bWxQSwECFAAKAAAAAACHTuJAAAAAAAAAAAAAAAAABgAAAAAAAAAAABAAAACnIAAAX3JlbHMvUEsBAhQAFAAAAAgAh07iQHs4drz/AAAA3wIAAAsAAAAAAAAAAQAgAAAAyyAAAF9yZWxzLy5yZWxzUEsBAhQACgAAAAAAh07iQAAAAAAAAAAAAAAAAAkAAAAAAAAAAAAQAAAAAAAAAGRvY1Byb3BzL1BLAQIUABQAAAAIAIdO4kBie5TdOQEAAEMCAAAQAAAAAAAAAAEAIAAAACcAAABkb2NQcm9wcy9hcHAueG1sUEsBAhQAFAAAAAgAh07iQIRu/vdFAQAAaQIAABEAAAAAAAAAAQAgAAAAjgEAAGRvY1Byb3BzL2NvcmUueG1sUEsBAhQAFAAAAAgAh07iQAMNSqT+AAAAfwEAABMAAAAAAAAAAQAgAAAAAgMAAGRvY1Byb3BzL2N1c3RvbS54bWxQSwECFAAKAAAAAACHTuJAAAAAAAAAAAAAAAAAAwAAAAAAAAAAABAAAAAxBAAAeGwvUEsBAhQACgAAAAAAh07iQAAAAAAAAAAAAAAAAAkAAAAAAAAAAAAQAAAA8yEAAHhsL19yZWxzL1BLAQIUABQAAAAIAIdO4kDl8KIY7QAAALoCAAAaAAAAAAAAAAEAIAAAABoiAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQIUABQAAAAIAIdO4kBge622fwMAAGIRAAAQAAAAAAAAAAEAIAAAAFIEAAB4bC9jb21tZW50czEueG1sUEsBAhQACgAAAAAAh07iQAAAAAAAAAAAAAAAAAwAAAAAAAAAAAAQAAAA/wcAAHhsL2RyYXdpbmdzL1BLAQIUABQAAAAIAIdO4kD0u4nwqQIAAM4MAAAbAAAAAAAAAAEAIAAAACkIAAB4bC9kcmF3aW5ncy92bWxEcmF3aW5nMS52bWxQSwECFAAUAAAACACHTuJAFwxiSSQBAADRAQAAFAAAAAAAAAABACAAAADwHQAAeGwvc2hhcmVkU3RyaW5ncy54bWxQSwECFAAUAAAACACHTuJAdlmHlnkJAAB/TAAADQAAAAAAAAABACAAAABMFAAAeGwvc3R5bGVzLnhtbFBLAQIUAAoAAAAAAIdO4kAAAAAAAAAAAAAAAAAJAAAAAAAAAAAAEAAAAAQOAAB4bC90aGVtZS9QSwECFAAUAAAACACHTuJATmyNJvAFAAArGQAAEwAAAAAAAAABACAAAAArDgAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIAIdO4kCAnzVVNAEAAPUBAAAPAAAAAAAAAAEAIAAAAEYfAAB4bC93b3JrYm9vay54bWxQSwECFAAKAAAAAACHTuJAAAAAAAAAAAAAAAAADgAAAAAAAAAAABAAAAALCwAAeGwvd29ya3NoZWV0cy9QSwECFAAKAAAAAACHTuJAAAAAAAAAAAAAAAAAFAAAAAAAAAAAABAAAAA/IwAAeGwvd29ya3NoZWV0cy9fcmVscy9QSwECFAAUAAAACACHTuJAaR9Jxc8AAAC4AQAAIwAAAAAAAAABACAAAABxIwAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDEueG1sLnJlbHNQSwECFAAUAAAACACHTuJA/3rPTZcCAAB5BgAAGAAAAAAAAAABACAAAAA3CwAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsFBgAAAAAWABYAWwUAADEmAAAAAA==","contentType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","empty":false,"inputStream":{"channel":{"open":true},"fD":{}},"name":"file","originalFilename":"作业区域配置表.xlsx","size":11170}]>

Alanscut commented 4 years ago

我按照你的代码新建了这个SingleRowListener,发现Consumer涉及导包有多个选择的问题,尝试几次后发现仍然编译报错。excel 应该可以上传,评论窗口下方有attach files,点击这个就可以上传excel、代码、图片、压缩包等。你说“不知道是不是excel格式问题,并且不是所有导入都会报错,仅个别”,我如果看到这个问题的全部信息后,就方便debug分析了。还请以附件的形式上传问题的所有代码和对应的excel,例如错误提示、屏幕截图、Demo、测试用例、整个项目的代码、对应的excel,等等,以帮助你分析此问题。谢谢!

InspireYi commented 4 years ago

@Alanscut 已将报错demo放至git,地址 https://github.com/InspireYi/easyexceltest 麻烦看看

InspireYi commented 4 years ago

TestApplication 直接运行main,有报错和不报错的示例

InspireYi commented 4 years ago

StylesTable 240行 CTDxfs styleDxfs = styleSheet.getDxfs(); 这个对象为空

zhuangjiaju commented 4 years ago

贴全代码 并上传文件。

InspireYi commented 4 years ago

https://github.com/InspireYi/easyexceltest @zhuangjiaju

zhuangjiaju commented 3 years ago

已经在3.0.0-beta1 版本修复,beta版本会在一个月内升级成正式版。