How to make my path relative in selenium apache poi while I input my Excel file? and How to write the test result in excel after performing testing

Question

FileInputStream input=new FileInputStream(new File("C:\\Report\\TestCase.xls"));
HSSFWorkbook workbook=new HSSFWorkbook(input);
HSSFSheet sheet=workbook.getSheet("KeywordFramework");
System.out.println("i am in");

How can i make my path a relative path ? Example (..\..\TestCase.xls) It should search the file in system and call it , is the requirement

HSSFWorkbook workbook=new HSSFWorkbook(input);
  ExpectedOP=Cellvalue;
    int LastRow = 1;
        for(int i1=1;i1<5;i1++)
        {
        String sr [] =new String [10];
        sr[i1]=driver.findElement(By.xpath(".//*[@id='stepList']/li["+i1+"]")).getText();
        System.out.println("UserID = "+sr[i1]);
        for (int j1=1;j1<sr.length;j1++)
            {
            if(ExpectedOP.equals(j1))
            {
                System.out.println("compare pass");
                String status="PASS";
                Row row1 = sheet.getRow(LastRow);

                Cell cell2 = row1.createCell(18);
                cell2.setCellValue(status);
                System.out.println(status);

                input.close();
                FileOutputStream outFile =new FileOutputStream(new File("TestCase.xls"));
                workbook.write(outFile);
            }
            else
            {
            System.err.println("compare fail");
            String status = "FAIL";
            Row row1 = sheet.getRow(LastRow);

            Cell cell2 = row1.createCell(18);
            cell2.setCellValue(status);
            System.out.println(status);

            input.close();
            FileOutputStream outFile =new FileOutputStream(new File("TestCase.xls"));
            workbook.write(outFile);
            }
            }
        }

This is my code to compare value from website and excel and here am telling IDE to place the pass/fail result in cell number 18 , which i want to make dynamic and also in "i1<5" "5" should be removed and made dynamic which number of cell counts Thank you

This is not a Selenium problem! This is a pure Java problem finding a file in the system. — SiKing
– SiKing, Commented Dec 3, 2014 at 6:42
Hi Helping Hands , i went to the link you have referred me to i got the path of the file using the code suggested , but poi considers path as (example : C//123//test.xls) Code suggested there gives path in normal way that is , C/123/test.xls , is there anyway i can fix this ? — user3724559
– user3724559, Commented Dec 3, 2014 at 6:48
yes , you can observe in the code attached to my question above for reference :) , is there anyway i can change "\" in path to "\\" ? — user3724559
– user3724559, Commented Dec 3, 2014 at 6:54

Helping Hands · Accepted Answer · 2014-12-03 07:06:23Z

0

Can you try like :

 FileInputStream input=new FileInputStream(new File("TestCase.xls"));

In your code? I think it should work.

answered Dec 3, 2014 at 7:06

Helping Hands

5,41410 gold badges70 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stefan · Accepted Answer · 2014-12-03 06:57:16Z

0

As long as you pass a valid FileInputStream to POI you can use any valid file path you want to open the workbook. So the following code should work fine:

FileInputStream input=new FileInputStream(new File("../../TestCase.xls"));
HSSFWorkbook workbook=new HSSFWorkbook(input);
HSSFSheet sheet=workbook.getSheet("KeywordFramework");
System.out.println("i am in");

answered Dec 3, 2014 at 6:57

Stefan

1354 bronze badges

2 Comments

user3724559 Over a year ago

An IOException was caught! java.io.FileNotFoundException: ..\..\TestCase.xls (The system cannot find the file specified) This is the error i am getting , where as TeastCase.xls is present in the same folder where the code is

Stefan Over a year ago

Please check what your current working directory is. The code above will look for a file relative to this working directory. When running a maven project for example it is not the directory where your source files are but the root directory of the project. To get your working directory you can try: File workingDir = new File(""); System.out.println("Working directory is: " + workingDir.getAbsolutePath());

Collectives™ on Stack Overflow

How to make my path relative in selenium apache poi while I input my Excel file? and How to write the test result in excel after performing testing

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related