public class Start {
    List<Record> records =  new ArrayList<Record>();
    public static void main(String[] args) {
        new Start().start();
    }

    public start() {
        ReaderXlsx readProcess = new ReaderXlsx();
        List<List<String>> listProcess = new ArrayList<List<String>>(readProcess.ReaderXlsx("FileImport", 0, 16, 50));
        records = convertLLtoLR(listProcess);
        new WriterXlsx("ExportBatch",records);
    }

    public List<Record> convertLLtoLR(List<List<String>> listProcess){
        for (int lineListProcessId=0;lineListProcessId<listProcess.size();lineListProcessId++){
            Record record = new Record();
            String outputName = listProcess.get(lineListProcessId).get(4);
            record.setNumber(lineListProcessId);
            if (listProcess.get(lineListProcessId).get(4).contains("\n")){
                outputName = listProcess.get(lineListProcessId).get(4).substring(0,listProcess.get(lineListProcessId).get(4).lastIndexOf("\n"));
                if (listProcess.get(lineListProcessId).get(4).contains(",")){
                    outputName = listProcess.get(lineListProcessId).get(4).substring(0,listProcess.get(lineListProcessId).get(4).lastIndexOf(","));
                }
            }
            record.setName(outputName);
            record.setCode(listProcess.get(lineListProcessId).get(4).substring(listProcess.get(lineListProcessId).get(4).lastIndexOf("\n")+1));
            record.setCount(3333);
            record.setSimultaneouslyProcessedProducts(333);
            record.setSimultaneousProcessing("ss");
            record.setInterchangeability(1);
            records.add(lineListProcessId,record);
        }
        return records;
    }

}