Hi Manoj,
If the excel file always contains the same number of GPS coordinates in the
same cells in the spreadsheet, you can use MapInfo to create the header once
and for all. Just open the XLS file and MapInfo will guide you through the
process. You can also add point objects based on the coordinates the first
time. Next time the XLS file is updated, you just open the TAB file again
and re-calculate the point objects like this:
set coordsys <table>
update <table> set object=createpoint(x,y)
commit table <table>
x and y is the name of the 2 fields in your TAB file with coordinates.
If the excel file contains different number of GPS coordinates, I think you
can solve it by defining the TAB header to include plenty of rows. Just edit
the TAB file with a text editor.
I hope this helped you.
Uffe Kousgaard
----- Original Message -----
From: manoj mohan
To: [email protected]
Sent: Thursday, March 09, 2006 5:47 PM
Subject: [MI-L] [Spam] Converting excel to TAB automatically
Dear all
Please find a solution to my problem
I am having an excel file containing longitude & latitude values which are
updated automatically from GPS.
I wanted this convert this file to a TAB format inorder to view it in
mapbasic window.
My query is, does any mapbasic program is there which will convert the excel
file automatically to TAB and shows it in mapwindow (as the new locations
can be seen automatically in the map window whenever the excel file is
updated)
Thanks & Regards
Manoj
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
