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

Question

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 ?

LiuYan 刘研 · Accepted Answer · 2012-06-09 01:57:21Z

2

You can use CellReference

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

answered Jun 9, 2012 at 1:57

LiuYan 刘研

1,6241 gold badge16 silver badges31 bronze badges

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

1 Comment

darsheets Over a year ago

Thanks @LiuYan for the response. But I dont want the sUserInput = "A1" all the time. If the customer changes the template of the excel file(like change the field for total of the A column from A50 to A51), then there should not be any change in the java code.

SivaTeja · Accepted Answer · 2015-05-13 11:16:12Z

0

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

answered May 13, 2015 at 11:16

SivaTeja

3881 gold badge5 silver badges17 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related