Saya mencoba membaca file excel dan menjalankan kasus pengujian saya, sekarang kesalahan yang saya dapatkan adalah java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell Berikut adalah implementasi kode saya: Anda mungkin memperhatikan bahwa saya memiliki pengguna String.valueOf(); tapi tidak berhasil.


    public static List<Map<String, String>> getTestDetails()
    {
        List<Map<String, String>> list = null;
        FileInputStream fileInputStream = null;
        try 
        {
           fileInputStream = new FileInputStream(FrameworkConstants.getExcelsheetspath()+"TestCasesToBeExecuted.xlsx");
           XSSFWorkbook workbook = new XSSFWorkbook(fileInputStream);
           XSSFSheet sheet = workbook.getSheet("RunManager");
                        
           int lastRowNum = sheet.getLastRowNum();
           int lastColNum = sheet.getRow(0).getLastCellNum();
                        
           Map<String, String> map = null;
           list = new ArrayList<Map<String,String>>();
                        
           for(int i=1; i<lastRowNum; i++)
           {
                map = new HashMap<String, String>();
                for(int j=0; j<lastColNum; j++)
                {
                    String key = sheet.getRow(0).getCell(j).getStringCellValue();
                    System.out.println("Value of key:: "+key);
                    String value = String.valueOf(sheet.getRow(i).getCell(j).getStringCellValue());
                    System.out.println("Value of value:: "+value);
                    map.put(key, value);
                }
                list.add(map);
            }
        } 
        catch (FileNotFoundException e) 
        {
            e.printStackTrace();
        }
        catch (IOException e) 
        {
            e.printStackTrace();
        }
                    
        if(Objects.nonNull(fileInputStream))
        {
            try 
            {
                fileInputStream.close();
            } 
            catch (IOException e) 
            {
                e.printStackTrace();
            }
       }
       return list; 
    }

Dan ini kode saya untuk pemanggilan metode:


public List<IMethodInstance> intercept(List<IMethodInstance> methods, ITestContext context) 
{
   List<Map<String, String>> list = ExcelUtils.getTestDetails();
   List<IMethodInstance> result = new ArrayList<IMethodInstance>();
    
   for(int i=0; i<methods.size(); i++)
   {
        for(int j=0; j<list.size(); j++)
        {
            if(methods.get(i).getMethod().equals(list.get(j).get("Test Name")))
            {
                if(list.get(j).get("Execute").equalsIgnoreCase("yes"))
                {
                    methods.get(i).getMethod().setDescription(list.get(j).get("Test Description")); 

methods.get(i).getMethod().setInvocationCount(Integer.parseInt(list.get(j).get("Count")));                          methods.get(i).getMethod().setPriority(Integer.parseInt(list.get(j).get("Priority")));
                result.add(methods.get(i));
                }
            }
        }
    }
 
  return result;
}

Impor saya adalah sebagai berikut

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.util.NumberToTextConverter;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
1
enthusiasticCoder 30 September 2021, 18:11

1 menjawab

Menurut dokumen https: //poi.Apache.org/apidocs/dev/org/Apache/poi/xssf/usermodel/XSSFCell.html#getCellType--

Anda harus dapat melakukan:

String value = null;

    if (sheet.getRow(i).getCell(j).getCellType() == CellType.NUMERIC) {
        value=String.valueOf(sheet.getRow(i).getCell(j).getNumericCellValue());
    } else{
        value = sheet.getRow(i).getCell(j).getStringCellValue();
    }
1
Andreea Frincu 30 September 2021, 16:58