使用成员类变量读取excel Apache POI Java

Question

嗨，如何在循环中创建动态对象以在对象中存储多个值。然后访问这些对象进行操作

是否可以为对象创建指定动态变量名。我可以在赋值的左边给出变量的动态值吗。如果问题不清楚，请让我编辑，如果解决方案已经可用，请向我指出

package poi;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class ExcelRead_UsingMember {
    public static int C, R, i;
    public static double ID;
    private static final String FILE_READ = "C:/Users/m93162/ApachePOI_Excel_Workspace/MyFirstExcel.xlsx";
    //private static final String FILE_WRITE = "C:/Users/m93162/ApachePOI_Excel_Workspace/WriteExcel.xlsx";

    public static void main(String[] args) {
        List<Member> listOfMembers = new ArrayList<Member>();

        try {
            FileInputStream excelFile = new FileInputStream(new File(FILE_READ));
            Workbook workbook = new XSSFWorkbook(excelFile);
            Sheet datatypeSheet = workbook.getSheetAt(0);
            Iterator<Row> iterator = datatypeSheet.iterator();

             while (iterator.hasNext()) {

                    Row currentRow = iterator.next();
                    Iterator<Cell> cellIterator = currentRow.iterator();

                    int i=0;

                    while (cellIterator.hasNext()) {
                        Member [member+i] = new Member();
QUESTION: I want to create dynamic objects here and store the values below dynamically. How to approach this.

                        Cell currentCell = cellIterator.next();


                        if (currentCell.getCellTypeEnum() == CellType.STRING) {
                            System.out.print(currentCell.getStringCellValue() + "--");
                        } else if (currentCell.getCellTypeEnum() == CellType.NUMERIC) {
                            System.out.print(currentCell.getNumericCellValue() + "--");
                        }

                    }
                    System.out.println();

                }
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }

        }
    }

Answer 1

你可以使用地图

DynamicObject

DynamicObject {
     prvate Map<String, Object> map = new HashMap();

     public void addPropery(String key, Object value) {
          map.put(key, value);
     }
}

Your code

private void processRow(Row row) {
    while (cellIterator.hasNext()) {
        dynamicObjects[member+i] = new DynamicObject();
        DynamicObject dynamicObject = dynamicObjects[member+i];
        Cell currentCell = cellIterator.next();

        if (currentCell.getCellTypeEnum() == CellType.STRING) {
            System.out.print(currentCell.getStringCellValue() + " ");
                        dynamicObject.addProperty("stringField", currentCell.getStringCellValue());
        } else if (currentCell.getCellTypeEnum() == CellType.NUMERIC) {
             System.out.print(currentCell.getNumericCellValue() + " ");
                        dynamicObject.addProperty("numericField", currentCell.getNumericCellValue());
        }

    }
}

然后可以遍历贴图的关键点以获得所有可能的值。也可以将贴图中的其他对象（例如，作为嵌套贴图）作为值存储