CODEWITHSUNDEEP
javaexcelapache-poi
darsheets
darsheets

Reputation: 276

How to update an excel cell using based on its content using Java and Apache POI

I have a predefined excel file which is a kind of form where most of the information is already mentioned but I have to just enter the Name, Address, etc details from my application made in Java.

I can store the cell (like A12, B20, etc) and update those cells using Apache POI libraries and methods easily. But I want it to be dynamic. Like if the users changes the name cell from A12 to B12, the Java code should not be modified.

Is there a way we can store some vaiable name in the excel cell and update the value of that cell from Java ?

Upvotes: 1

Views: 1435

Answers (2)

SivaTeja
SivaTeja

Reputation: 388

You can write a cron job to read the excel file with a particular intervel and compare the cells values with the previous values.

Upvotes: 0

LiuYan 刘研
LiuYan 刘研

Reputation: 1624

You can use CellReference

String sUserInput = "A1"; // A1 or whatever
CellReference ref = new CellReference (sUserInput);
ref.getRow ();
ref.getCol ();

Upvotes: 2

Related Questions