Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NullPointerException #1527

Closed
InspireYi opened this issue Aug 18, 2020 · 11 comments
Closed

NullPointerException #1527

InspireYi opened this issue Aug 18, 2020 · 11 comments
Assignees
Labels
bug Something isn't working developing This feature will be added in future releases development completed Development completed, waiting for release question Further information is requested

Comments

@InspireYi
Copy link

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)

请问这种怎么解决?

@InspireYi InspireYi added the bug Something isn't working label Aug 18, 2020
@Alanscut
Copy link

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

@InspireYi
Copy link
Author

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
Copy link
Author

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

@InspireYi
Copy link
Author

<[{"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
Copy link

Alanscut commented Aug 22, 2020

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

@InspireYi
Copy link
Author

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

@InspireYi
Copy link
Author

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

@InspireYi
Copy link
Author

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

@zhuangjiaju
Copy link
Collaborator

贴全代码 并上传文件。

@zhuangjiaju zhuangjiaju added the question Further information is requested label Aug 29, 2020
@InspireYi
Copy link
Author

@zhuangjiaju zhuangjiaju added the developing This feature will be added in future releases label Apr 12, 2021
@zhuangjiaju zhuangjiaju added the development completed Development completed, waiting for release label Sep 17, 2021
@zhuangjiaju
Copy link
Collaborator

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working developing This feature will be added in future releases development completed Development completed, waiting for release question Further information is requested
Projects
None yet
Development

No branches or pull requests

3 participants