0

How to write a program to Read from an excel sheet , write from an excel sheet in java. By creating columns like

name, age,gender, salary, designation.

if ( sal > 5000)
 then update as fresher

if (sal >5000 and < 40000)

then it is lead

if (sal >40000 and <60000)

then it is manager.

Iamat8
  • 3,888
  • 9
  • 25
  • 35
prasad
  • 21
  • 2
  • 1
    Since you have a badge that indicates that you have gone through the [quick tour](http://stackoverflow.com/tour), you should know that this question is not something that you should ask here. Please read further through the [help]. – RealSkeptic Oct 09 '15 at 10:42

3 Answers3

0

try to check out this post :

What is the better API to Reading Excel sheets in java - JXL or Apache POI

It will give you enough informations to get started.


You can also give a try to search about CSV format, which can be imported and exported from Excel

https://en.wikipedia.org/wiki/Comma-separated_values

Community
  • 1
  • 1
Alexandre Beaudet
  • 2,774
  • 2
  • 20
  • 29
0

Your question is vague but as far as I understand it you probably want something like Apache POI

Diyarbakir
  • 1,999
  • 18
  • 36
0

Using below link you can get the both code for read or write data into Excel

http://viralpatel.net/blogs/java-read-write-excel-file-apache-poi/

Shiladittya Chakraborty
  • 4,270
  • 8
  • 45
  • 94