Convert XL data in to latitude longitude format?

[suresh.somepalli]

Hi Frinds,
plz give me the code of converting the xl data into latitude longitude format and that code to store to db.

Thanks
Km

[DarrylBurke]

Moved from a staff-only section.

This is a forum, not a code factory. Recommended reading: How to ask questions the smart way

db

[suresh.somepalli]

Hi
Hear im giving my code..This code to read xl data.
how to convert that xl data into latitude longitude format..
package com.wb;

import java.io.File;

import jxl.Sheet;
import jxl.Workbook;

public class WBEx {

public static void main(String...arg)
{
try {
Workbook wb = Workbook.getWorkbook(new File("d:/iso.xls"));
System.out.println(wb.getNumberOfSheets());
for(int sheetNo=0; sheetNo<wb.getNumberOfSheets();sheetNo++)
{
Sheet sheet = wb.getSheet(sheetNo);
int columns = sheet.getColumns();
int rows = sheet.getRows();
String data;
System.out.println("Sheet Name\t"+wb.getSheet(sheetNo).getName());
for(int row = 0;row < rows;row++) {
for(int col = 0;col < columns;col++) {
data = sheet.getCell(col, row).getContents();
System.out.print(data+ " ");

}
System.out.println("\n");
}
}
} catch(Exception ioe) {
ioe.printStackTrace();
}
}
}

[DarrylBurke]

Please go through Guide For New Members and BB Code List - Java Programming Forum and edit your post accordingly.

db

[Tolls]

Hi
Hear im giving my code..This code to read xl data.
how to convert that xl data into latitude longitude format..

What format is the data in at the moment?
What format is "latitude longitude" format?
How would you go about converting it by hand?

(And please use [code] tags [/code] when posting code)