import java.nio.file.*;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.apache.poi.ss.usermodel.*;
|
class ExtractStockXls {
|
static String q(String s){return "\""+s.replace("\\","\\\\").replace("\"","\\\"").replace("\r","\\r").replace("\n","\\n").replace("\t","\\t")+"\"";}
|
public static void main(String[] a)throws Exception{
|
StringBuilder o=new StringBuilder("[");
|
try(var w=new HSSFWorkbook(Files.newInputStream(Path.of(a[0])))){
|
for(int si=0;si<w.getNumberOfSheets();si++){
|
var s=w.getSheetAt(si);if(si>0)o.append(',');o.append("{\"sheet\":").append(q(s.getSheetName())).append(",\"rows\":[");
|
for(int ri=0;ri<=s.getLastRowNum();ri++){
|
if(ri>0)o.append(',');o.append('[');var r=s.getRow(ri);
|
if(r!=null)for(int ci=0;ci<r.getLastCellNum();ci++){
|
if(ci>0)o.append(',');var c=r.getCell(ci);if(c==null){o.append("null");continue;}
|
var t=c.getCellType()==CellType.FORMULA?c.getCachedFormulaResultType():c.getCellType();
|
switch(t){
|
case NUMERIC -> o.append(java.math.BigDecimal.valueOf(c.getNumericCellValue()).stripTrailingZeros().toPlainString());
|
case STRING -> o.append(q(c.getStringCellValue()));
|
case BOOLEAN -> o.append(c.getBooleanCellValue());
|
case ERROR -> o.append("{\"error\":").append(q(FormulaError.forInt(c.getErrorCellValue()).getString())).append('}');
|
default -> o.append("null");
|
}
|
}o.append(']');
|
}o.append("],\"merged\":[");for(int i=0;i<s.getNumMergedRegions();i++){if(i>0)o.append(',');o.append(q(s.getMergedRegion(i).formatAsString()));}o.append("]}");
|
}
|
}o.append(']');Files.writeString(Path.of(a[1]),o.toString());
|
}
|
}
|
