DEV Community 👩‍💻👨‍💻

carlwils
carlwils

Posted on

Java/ Get Cell Values by Cell Names in Excel

When manipulating an Excel document, we can extract cell values by simply copying and pasting. Alternatively, we can also obtain it programmatically in Java application, which can greatly save time and improve efficiency. In this tutorial, you will learn how to extract the value of a specified cell by its name using a free Java API.

Install the free API (2 Method)

1# Download the free API (Free Spire.XLS for Java) and unzip it, then add the Spire.Xls.jar file to your project as dependency.
2# Directly add the jar dependency to maven project by adding the following configurations to the pom.xml.

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>http://repo.e iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls.free</artifactId>
        <version>3.9.1</version>
    </dependency>
</dependencies>
Enter fullscreen mode Exit fullscreen mode

Get Cell Values by Cell Names in Excel

The detailed steps and complete code are as follows:

  1. Create a Workbook instance.
  2. Load an Excel sample document using Workbook.loadFromFile() method.
  3. Get a specified worksheet using Workbook.getWorksheets().get() method.
  4. Get a specific cell by its name using Worksheet.getRange().get() method.
  5. Create a StringBulider instance.
  6. Get the cell value using CellRange.getValue() method, and then append the value to the StringBuilder instance using StringBuilder.append() method.
import com.spire.xls.*;

public class GetCellValue {
    public static void main(String[] args) {
        //Create a Workbook instance
        Workbook workbook = new Workbook();

        //Load an Excel sample document
        workbook.loadFromFile( "member.xlsx");

        //Get the first worksheet
        Worksheet sheet = workbook.getWorksheets().get(0);

        //Get the specified cell by its name
        CellRange cell = sheet.getRange().get("C3");

        //Create a StringBuilder instance
        StringBuilder content = new StringBuilder();

        //Get value of the cell "D6" 
        content.append("The value of cell C3 is: " + cell.getValue()+"\n");
        System.out.println(content);
    }
}
Enter fullscreen mode Exit fullscreen mode

GetCellValue

Top comments (0)

🌚 Life is too short to browse without dark mode