How to read data from excel and store it in db

[saran123]

Hi,
I wrote the code to read the data from excel and given below.Now its reading all the values and printing it in Java Console. Cold you explain me where to store the data read from excel and how can i connect it to database?If possible.I do not know how to get these data and store in database.So please provide me

public class ReadExcelTest
{
private String inputFile;
public void setInputFile(String inputFile)
{
this.inputFile = inputFile;
}
public void read() throws IOException, WriteException {
File inputWorkbook = new File(inputFile);
Workbook w;
try {
w = Workbook.getWorkbook(inputWorkbook);
Sheet sheet = w.getSheet(0);// Get the first sheet
// Loop over first 10 column and lines
for (int j = 0; j < sheet.getColumns(); j++)
{
for (int i = 0; i < sheet.getRows(); i++)
{
Cell cell = sheet.getCell(j, i);
CellType type = cell.getType();

if (cell.getContents().isEmpty())
{
System.out.println("This column is empty ");
}
if (cell.getType() == CellType.LABEL)
{
System.out.println( "The contents of the excel are "+ cell.getContents());
}
if (cell.getType() == CellType.NUMBER)
{
System.out.println("I got a number "+ cell.getContents());
}

}

}

} catch (BiffException e) {
e.printStackTrace();
}
}

public static void main(String[] args) throws WriteException, IOException {
ReadExcel test = new ReadExcel();
test.setInputFile("C:/xxx.xls");
test.read();
}
}


Thanks in advance

[Norm]

Have you tried searching for code that does that? There are examples posted here to do a lot of it.

[saran123]

I read some threads posted here similar to my thread but i feel my case is different.As i am new to Java, i do not know how(coding) to store the excel read data to database.Please help me to solve this. Any helpy can be appreciated as this is a high priority work for me.

Thanks

[DarrylBurke]

Trail: JDBC(TM) Database Access (The Java™ Tutorials)

db

[saran123]

Thanks Darryl. But i have a query.I read the data from excel and if i want to store it in database, i need jdbc connection.But i am using JExcel API, so is DSN needed for jdbc connection?Because in the code i am giving the Excel path directly.If i use DSN, which path i need to give(whether Excel file path or the Database in which i am going to store)?.So DSN is required or not?But without DSN, how can i connect my database? Please clarify my doubt.


Here i am JEXcel API and giving the Excel path in InputFile
public static void main(String[] args) throws WriteException, IOException {
ReadExcel test = new ReadExcel();
test.setInputFile("C:/xxx.xls");
test.read();
}



Thanks

[mrtshezi]

I will like 2 send a big HELLO 2 everyone in the forum. i am new in this site and i hope i will be able to help others in solving java problems and also get get from others. I am doing java in the university level. Together nothing can stand on our way