Anda perlu membaca data Excel dan mengubahnya menjadi data JSON. Anda telah menulis fungsi tes dan konversi normal:
Konversi JSON: org.json.jar
Kelas Uji: ImportFile.java:
paket com.siemens.util; impor java.util.arraylist; impor java.util.list; impor org.json.jsonexception; impor org.json.jsonobject; impor org.apache.poi.ss.usermodel.row; impor org.apache.poi.ss.usermodel.sheet; impor org.apache.poi.ss.usermodel.workbook; // impor com.siemens.entity.master; // impor com.siemens.service.masterservice; // impor com.siemens.serviceImpl.masterserviceImpl; // impor com.siemens.serviceImpl.webserviceImpl; Public Class ImportFile {public static void main (string [] args) melempar jsonexception {// master master = new master (); // ApplicationContext ac = new ClassPathXMLapPlicationContext ("ApplicationContext.xml"); // MASTERSERVICE MS = (MASTERSERVICE) AC.getBean ("MASTERSERVICE"); Workbook WB = NULL; Lembar Lembar = NULL; Baris baris = null; String cellData = null; // path file, string filePath = "f: /haoxy/worktable222.xls"; wb = excelbean.readexcel (filepath); if (wb! = null) {// gunakan untuk menyimpan data dalam daftar tabel <jsonobject> listMap = new ArrayList <jsonobject> (); // Dapatkan lembar pertama = wb.getsheetat (0); // Dapatkan jumlah maksimum baris int rownum = sheet.getphysicalNumberofrows (); // Dapatkan baris pertama baris = sheet.getRow (0); // Dapatkan jumlah maksimum kolom int colnum = row.getphysicalNumberofcells (); // Buat objek JSON di sini. Jika Anda menggunakan peta dalam pengukuran aktual, akan ada masalah dengan data JSON JSONObject JSONMAP = new jsonObject (); // baris loop untuk (int i = 1; i <rownum; i ++) {row = sheet.getrow (i); if (row! = null) {// Buat objek daftar untuk menerima daftar data Excel <string> Daftar baru = new ArrayList <String> (); // kolom loop untuk (int! = Null) {// Buat objek Daftar untuk menerima daftar data Excel <string> Daftar baru = ArrayList baru <String> (); // kolom loop untuk (int! = Null) {// Buat objek Daftar untuk menerima daftar data Excel <string> Daftar baru = ArrayList baru <String> (); // kolom loop untuk (int! = Null) {// Buat objek Daftar untuk menerima daftar data Excel Baca <string> Daftar = ArrayList baru <String> (); // kolom loop untuk (int) j = 0; j <colnum; j ++) {cellData = (string) excelbean.getCellFormatValue (row.getCell (j)); list.add (cellData); } //System.out.println(list.get(59)); // Berikut ini adalah format data sesuai dengan persyaratan .-- Membuat objek JSON akan melaporkan pengecualian, dan menangkapnya. JsonObject jsonObject2 = new jsonObject (); jsonobject2 ("skvdorcode", list.get (0)); jsonobject2 ("deskripsi", list.get (1)); jsonobject2 ("disiplin", list.get (2)); jsonobject2 ("prefabricatedskids", list.get (3)); jsonobject2 ("onrack", list.get (4)); jsonobject2 ("offrack", list.get (5)); jsonobject2 ("yard", list.get (6)); jsonobject2 ("hsrg", list.get (7)); JsonObject jsonpptdata = new jsonobject (); jsonpptdata.put ("sc ff", list.get (8)); jsonpptdata.put ("cc ss ct", list.get (9)); jsonpptdata.put ("cc ss occ", list.get (10)); jsonpptdata.put ("cc ss ac", list.get (11)); jsonpptdata.put ("cc ms ct", list.get (12)); jsonpptdata.put ("cc ms occ", list.get (13)); jsonpptdata.put ("cc ms acc", list.get (14)); // turnkey jsonobject jsonturnkey = new jsonobject (); jsonturnkey.put ("PlantDesign", List.get (26)); jsonturnkey.put ("BasicDesign", List.get (27)); jsonturnkey.put ("detailDesign", list.get (28)); jsonturnkey.put ("pemasok", list.get (29)); jsonturnkey.put ("errection", list.get (30)); jsonturnkey.put ("commissioning", list.get (31)); jsonturnkey.put ("blackbox", list.get (32)); jsonturnkey.put ("opsialscope", list.get (33)); jsonturnkey.put ("komentar", list.get (34)); jsonturnkey.put ("internalremark", list.get (35)); jsonturnkey.put ("revisi", list.get (36)); // powercore jsonobject jsonpowercore = new jsonobject (); jsonpowercore.put ("PlantDesign", List.get (37)); jsonpowercore.put ("BasicDesign", list.get (38)); jsonpowercore.put ("detailDesign", list.get (39)); jsonpowercore.put ("pemasok", list.get (40)); jsonpowercore.put ("errection", list.get (41)); jsonpowercore.put ("commissioning", list.get (42)); jsonpowercore.put ("blackbox", list.get (43)); jsonpowercore.put ("opsialscope", list.get (44)); jsonpowercore.put ("komentar", list.get (45)); jsonpowercore.put ("internalremark", list.get (46)); jsonpowercore.put ("revisi", list.get (47)); // powerisland jsonobject jsonpowerisland = new jsonobject (); jsonpowerisland.put ("PlantDesign", List.get (48)); jsonpowerisland.put ("BasicDesign", List.get (49)); jsonpowerisland.put ("detailDesign", list.get (50)); jsonpowerisland.put ("pemasok", list.get (51)); jsonpowerisland.put ("errection", list.get (52)); jsonpowerisland.put ("commissioning", list.get (53)); jsonpowerisland.put ("blackbox", list.get (54)); jsonpowerisland.put ("opsialscope", list.get (55)); jsonPowerIsland.put ("komentar", list.get (56)); jsonpowerisland.put ("internalremark", list.get (57)); jsonpowerisland.put ("revisi", list.get (58)); // Buat objek jsonbmt dan lebih lanjut sarang objek di atas jsonObject jsonbmt = new jsonobject (); jsonbmt.put ("turnkey", jsonturnkey); jsonbmt.put ("powercore", jsonpowercore); jsonbmt.put ("powerisland", jsonpowerisland); // sarang beberapa di atas ke dalam objek lapisan pertama jsonobject2.put ("powerplanttypes", jsonpptdata); jsonObject2 ("BusinessMixtypes", jsonbmt); jsonobject2 ("treedepth", integer.parseint (list.get (59) .substring (0, list.get (59) .indexof ('.'))))); if (integer.parseInt (list.get (59) .substring (0, list.get (59) .indexof ('.'))) <= 2) {List <string> list3 = ArrayList baru <string> (); list3.add ("Non-Place-PlaceHolder"); jsonobject2.put ("anak -anak", list3); } listMap.add (jsonObject2); } else {break; }} // end untuk baris // tambahkan key-griddata jsonmap.put ("griddata", listMap); System.out.println (JSONMAP); }}}Membaca Kelas Alat Excel, lihat Metode Bacaan Netizen seperti dikutip:
Excelbean.java:
paket com.siemens.util; impor java.io.fileInputStream; impor java.io.filenotfoundException; impor java.io.ioException; impor java.io.inputstream; impor org.apache.poi.hssf.usermodel.hssfworkbook; impor org.apache.poi.ss.usermodel.cell; impor org.apache.poi.ss.usermodel.dateutil; impor org.apache.poi.ss.usermodel.workbook; impor org.apache.poi.xssf.usermodel.xssfworkbook; kelas publik ExcelBean {// Baca Buku Kerja Statis Publik Excel ReadExcel (String FilePath) {Workbook WB = NULL; if (filepath == null) {return null; } String extString = filepath.substring (filepath.LastIndexOf (".")); InputStream adalah = null; coba {is = new FileInputStream (FilePath); if (". xls" .Equals (extString)) {return wb = hssfworkBook baru (IS); } else if (". xlsx" .equals (extString)) {return wb = new XSFWorkBook (IS); } else {return wb = null; }} catch (FileNotFoundException e) {e.printstacktrace (); } catch (ioException e) {e.printstacktrace (); } return WB; } Objek statis publik getCellFormatValue (sel sel) {objek cellValue = null; if (cell! = null) {// Judge cell type switch (cell.getCellType ()) {case cell.cell_type_numeric: {cellValue = string.valueof (cell.getNumericCellValue ()); merusak; } case cell.cell_type_formula: {// menilai apakah sel dalam format tanggal jika (dateutil.iscellDateFormatted (sel)) {// konversi ke format tanggal yyyy-mm-dd cellValue = cell.getDateCellValue (); } else {// number cellValue = cell.getDateCellValue (); } else {// number cellValue = string.valueof (cell.getNumericCellValue ()); } merusak; } case cell.cell_type_string: {cellValue = cell.getRichStringCellValue (). getString (); merusak; } default: cellValue = ""; }} else {cellValue = ""; } return CellValue; }}Meringkaskan
Di atas adalah file Java Reading Excel ke dalam format JSON yang diperkenalkan oleh editor. Saya harap ini akan membantu semua orang. Jika Anda memiliki pertanyaan, silakan tinggalkan saya pesan dan editor akan membalas semua orang tepat waktu. Terima kasih banyak atas dukungan Anda ke situs web Wulin.com!