Thread: Can't Find File Apache Poi

I'm trying to read a .xlsx file using Apache Poi on Eclipse and store the data into an ArrayList.

My code :

 
import org.apache.poi.ss.usermodel.*;
import java.io.*;
import java.util.*;
 
public class parseReadFiles 
{
    public static void main(String[] args)
    {
        try
        {
            ArrayList<String> firstList=new ArrayList<>();
            //ArrayList<String> secondList=new ArrayList<>();
            //ArrayList<String> thirdList=new ArrayList<>();
 
            Workbook wb = WorkbookFactory.create(new FileInputStream("Users/Divjot/Desktop/first.xlsx"));
            Sheet sheet = wb.getSheetAt(0); ...
        }
        catch(FileNotFoundException e)
        {
            e.printStackTrace();
        }
        catch(Exception e)
        {
        }
    }
}

I keep getting a FileNotFoundException: Users/Divjot/Desktop/first.xlsx (No such file or directory). I've tried different combinations of file names and paths but can't get the program to find it. Should the file be stored in a special place or should the class path be different?

I'm on a Mac and I tried to find the absolute path but I couldn't. If I click command-I on the file name, it says that it's located under Users/divjot/Desktop/first.xlsx (I tried changing Divjot to lowercase but that didn't work). How can I find the absolute path and is it possible for me to store this somewhere in Eclipse so I don't need the absolute path?

I don't have it in front of me, but I'm pretty sure that Eclipse allows you to add the file to the project, similar to updating the CLASSPATH with that file's location. Rather than constantly chasing files stored in random locations on your system, put them all in a common resource location and point Eclipse at that. Right click on the project and look through the available settings. The Eclipse Wiki and online documentation should help if you can't find it.

I'm currently running Netbeans 8.0 and attempting to use Apache POI to read various .xlsx files. Currently, I'm getting a java.io.FileNotFoundException. I'm using a Mac. What is the correct way to list the file path for my files in Netbeans? Also, is it possible to add the files to my actual project and access them inside the project?