How to read from excel in java

Question

1.00/5 (1 vote)

See more:

I am reading from excel.Can someone explain this loop in detail :-what will be the output for this

for (int i= 1 ; i < totalNoOfRows; i++) {
for (int j=0; j < totalNoOfCols; j++) {
arrayExcelData[i-1][j] = sh.getCell(j, i).getContents();
}
}

What I have tried:

for (int i= 1 ; i < totalNoOfRows; i++) {
for (int j=0; j < totalNoOfCols; j++) {
arrayExcelData[i-1][j] = sh.getCell(j, i).getContents();
}
}

Posted 21-Feb-17 23:28pm

Member 13016695

Updated 22-Feb-17 1:02am

Add a Solution

Comments

[no name] 22-Feb-17 6:47am

There will not be any output. You should run the code in your debugger, step by step, and you will see exactly what is happening.

Abigaill 9-Nov-18 3:34am

You should try out this Excel library for Java, it provides a simple means for reading Excel files, check it out.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Answer 1 · 2017-02-21T23:50:00

If the code is working (that is: it is able to read data from Excel without an error), your arrayExcelData is probably filled with the string data from the rows 1 to totalNoOfRows (excluding the first row which might be a header row) and columns from index 0 to totalNoOfCols.

You did not specify what kind of functions you are using but I guess they are jxl.
Then see Sheet getCell(int, int)[^] and Cell getContents()[^].

Patrice T · Answer 2 · 2017-02-22T01:02:00

Quote:
I am reading from excel.Can someone explain this loop in detail :-what will be the output for this

Why not ask the author ?

When you don't understand what your code is doing or why it does what it does, the answer is debugger.
Use the debugger to see what your code is doing. Just set a breakpoint and see your code performing, the debugger allow you to execute lines 1 by 1 and to inspect variables as it execute, it is an incredible learning tool.

Debugger - Wikipedia, the free encyclopedia[^]
http://docs.oracle.com/javase/7/docs/technotes/tools/windows/jdb.html[^]
https://www.jetbrains.com/idea/help/debugging-your-first-java-application.html[^]

The debugger is here to show you what your code is doing and your task is to compare with what it should do.
There is no magic in the debugger, it don't find bugs, it just help you to. When the code don't do what is expected, you are close to a bug.

How to read from excel in java

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0