Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0

    Default Convert XL data in to latitude longitude format?

    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

  2. #2
    DarrylBurke's Avatar
    DarrylBurke is online now Forum Police
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,251
    Rep Power
    19

    Default Re: Convert XL data in to latitude longitude format?

    Moved from a staff-only section.

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

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  3. #3
    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0

    Default Re: Convert XL data in to latitude longitude format?

    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();
    }
    }
    }

  4. #4
    DarrylBurke's Avatar
    DarrylBurke is online now Forum Police
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,251
    Rep Power
    19

    Default Re: Convert XL data in to latitude longitude format?

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

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  5. #5
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,016
    Rep Power
    20

    Default Re: Convert XL data in to latitude longitude format?

    Quote Originally Posted by suresh.somepalli View Post
    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)
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. how to convert .PES format to image
    By stratosb in forum Java 2D
    Replies: 3
    Last Post: 12-05-2011, 08:04 PM
  2. How to Convert .jpg to .bmp Image Format
    By deshmukh.niraj04 in forum New To Java
    Replies: 12
    Last Post: 04-07-2011, 11:51 AM
  3. how to convert SWING GUI into exe format
    By santhosh_el in forum AWT / Swing
    Replies: 7
    Last Post: 04-04-2009, 12:36 PM
  4. how to convert one format to another format
    By mahipal_reddy621 in forum New To Java
    Replies: 1
    Last Post: 12-02-2008, 10:21 AM
  5. how to convert date format
    By saran123 in forum New To Java
    Replies: 5
    Last Post: 10-16-2008, 06:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •