我有以下代码填写Excel文件,其中包含我使用Jsoup从Internet获得的信息.
package knvbj; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.util.List; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.jsoup.Jsoup; import org.jsoup.nodes.Document; import org.jsoup.nodes.Element; import org.jsoup.nodes.TextNode; import org.jsoup.select.Elements; public class KNVBJ { private static int Clnummer=1; public static void main(String[] args) throws IOException { FileOutputStream out = new FileOutputStream("/Users/muratcanpinar/Downloads/KNVBJ/build/classes/knvbj/ClubInformation.xlsx"); ListurlList = ReadXlsx.readXlsx(); urlList.get(1); for (String url : urlList) { System.out.println("url: " + url); } for (int i = 0; i < urlList.size(); i++) { Document doc = Jsoup.connect(urlList.get(i)) .data("query", "Java") .userAgent("Mozilla") .cookie("auth", "token") .timeout(3000) .post(); Element content1 = doc.getElementsByClass("details").first(); String body = content1.toString(); Document docb = Jsoup.parseBodyFragment(body); Element bbd = docb.body(); String kkj = bbd.toString(); Document finalDocument = Jsoup.parse(kkj); Element ClubName = finalDocument.getElementsByClass("title").first(); String NameOfClub = ClubName.text(); System.out.println(NameOfClub); Element Adres = finalDocument.getElementsByClass("text").get(1); String[] addressParts = Adres.html().split("
"); String SplitString; String PlaatsName; String Straat; String telNo; String Accommodatie; String Postcode; Accommodatie = addressParts[0].trim(); Straat = addressParts[1].trim(); SplitString = addressParts[2].trim(); telNo = addressParts[3].trim(); String splitted[]= SplitString.split(" "); Postcode = splitted[0]; PlaatsName = splitted[1]; System.out.println(Accommodatie + " " + Straat + " " + " postcode " + Postcode + " Plaatsname " + PlaatsName+ " "+ telNo); Elements anchors = finalDocument.getElementsByTag("a"); String email = anchors.get(1).text(); String fname = "/Users/muratcanpinar/Downloads/KNVBJ/src/knvbj/Voetbalclubs.xlsx"; InputStream inp = new FileInputStream(fname); Workbook wb = new XSSFWorkbook(inp); Sheet sheet = wb.getSheetAt(0); Row r1 = sheet.getRow(0); r1.createCell(Clnummer++).setCellValue(NameOfClub); r1.createCell(Clnummer++).setCellValue(Accommodatie); r1.createCell(Clnummer++).setCellValue(Straat); r1.createCell(Clnummer++).setCellValue(Postcode); r1.createCell(Clnummer++).setCellValue(PlaatsName); r1.createCell(Clnummer++).setCellValue(telNo); r1.createCell(Clnummer++).setCellValue(email); wb.write(out); } out.close(); } }
使用上面的代码我可以填充一行,然后得到这个错误
Exception in thread "main" org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : The part /docProps/app.xml fail to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller@f46fdc1 at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:479) at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1414) at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:179) at knvbj.KNVBJ.main(KNVBJ.java:101) Caused by: org.apache.poi.openxml4j.exceptions.OpenXML4JException: The part /docProps/app.xml fail to be saved in the stream with marshaller org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller@f46fdc1 at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:470) ... 3 more Java Result: 1
有人能告诉我我在做什么吗?非常感谢.