CHANGE THIS BOLD URL WITH YOUR FILE ADDRESS WITH SERVER ADDRESS AND THEN JUST COPY PASTE THE CODE TO JAVA FILE.
NOTE : U MUST HAVE TO ADD JAR FILE TO YOUR PROJECT CLASS PATH FROM THIS http://jexcelapi.sourceforge.net/ DOWN LOAD JAR FILE FROM HERE IF JAR IS NOT AVAILABLE ON THIS URL THEN SEARCH JXL JAR AND DOWNLOAD IT.
import java.io.IOException;
import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import java.net.URLConnection;
public class ReadExcel {
public void read() throws IOException {
java.net.URL url = new java.net.URL("http://www.XYZ.org/alphaguru.xls");
URLConnection conn = url.openConnection();
conn.setRequestProperty("Connection","Keep-Alive");
conn.setConnectTimeout(10000);
System.out.println("value of sTring is:"+conn.getInputStream().toString());
Workbook w;
try {
w = Workbook.getWorkbook(conn.getInputStream());
// Get the first sheet
Sheet sheet = w.getSheet(0);
// 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);
if (cell.getType() == CellType.LABEL) {
System.out.println("I got a label "+ 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 IOException {
ReadExcel test = new ReadExcel();
test.read();
}
}
