how to input in excel in java

Question

HOw do we input data in excel sheet using java code , the excel sheet format is shown in the photo below.

The Total days and Hrs are calculated automatically here in sheet as soon as i enter in the above columns, Please tell me how do start . Also these input are associated to the other sheet(sheet2) . so please tell me the way so that it also flexible and i can modify the data in the sheet2.

![Excel sheet that needs to be automated][2]

Dan D. · Accepted Answer · 2013-01-18 10:30:51Z

2

Use a third party library like apache poi for reading Excel data in Java.

answered Jan 18, 2013 at 10:30

Dan D.

32.4k6 gold badges66 silver badges81 bronze badges

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

Comments

Big Bad Baerni · Accepted Answer · 2013-01-18 10:33:02Z

1

You might want to try the jexcelapi found on sourceforge: JExcelApi

Very easy to use to read & write excel files from java.

answered Jan 18, 2013 at 10:33

Big Bad Baerni

9967 silver badges21 bronze badges

Comments

Matt · Accepted Answer · 2013-01-18 10:42:20Z

0

You use Java Excel API. This is an excellent article that demonstrates reading from and writing to Excel with Java.

Here is the Java Excel API download.

answered Jan 18, 2013 at 10:42

Matt

1,8125 gold badges23 silver badges33 bronze badges

Collectives™ on Stack Overflow

how to input in excel in java

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related