Home > Back-end >  Java JXL parse excel
Java JXL parse excel

Time:11-06

 
WorkbookSettings workbookWetting=new WorkbookSettings ();
WorkbookWetting. SetInitialFileSize (1024 * 500);
WorkbookWetting. SetArrayGrowSize (1024 * 500);
WorkbookWetting. SetGCDisabled (true);
System. The out. Println (workbookWetting getEncoding ());//output here is GBK
Workbook=workbook. GetWorkbook (new ByteArrayInputStream (SRC) (byte []), workbookWetting);

Background: check the name of the point (,), should only be for Chinese, here only input a Chinese point (,)
When excel file is to use the WPS editor named point (DE) is a normal
When excel file is to use office editing point (,) is stil in name, as shown in figure shown in
  • Related