Thanks Thanks:  2
Showing results 1 to 5 of 5

Thread: Need support for export macro excel to Mapinfo

  1. #1
    Member Reputation: 252
    Join Date
    2010-09-26
    Posts
    266


    Default Need support for export macro excel to Mapinfo

    Please could any support me how to creat a line and point in Mapinfo to represent a MW link with its differents parametres (Freq TX RX , RX level , TX level ....) from Excel database.
    Now i'm used to do somes macro with VBA and i want to adjust such table to Mapinfo.

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

  3. #2
    Member Reputation: 279 Maysam's Avatar
    Join Date
    2012-07-05
    Posts
    153


    Default Re: Need support for export macro excel to Mapinfo

    because of TAB file format, it is not easy to do it directly from excel, i suggest to create kml file from your table then import to mapinfo or convert kml to tab file easily.
    also there is an option to write MBX file to create links directly in mapinfo from imported excel file.

  4. #3
    Member Reputation: 252
    Join Date
    2010-09-26
    Posts
    266


    Default Re: Need support for export macro excel to Mapinfo

    Dear Maysam;
    Please would you mind to guide me how to write sush MBX directly in mapnifo from excel import.
    Thanks in advance.

  5. #4
    Senior Member Reputation: 463
    Join Date
    2008-05-22
    Posts
    935


    Default Re: Need support for export macro excel to Mapinfo

    using bellow script in mapinfo,

    update point_table set obj=createline(Start_X, Start_Y,End_X,End_Y)

    point_table = your table name
    Start_X = Long Site A coloum name
    Start_Y = Long Site B coloum name
    End_X = Lat Site A coloum name
    End_Y = Lat Site B coloum name


    put any information you want inside the excel, it will appear in line information you created before
    والسلام عليكم ورحمة الله وبركاته & Regards,

    -kaka-

  6. Thanks william.dg08, ssmc thanked for this post
  7. #5
    Member Reputation: 252
    Join Date
    2010-09-26
    Posts
    266


    Default Re: Need support for export macro excel to Mapinfo

    For whom interested here are the steps:
    1- prepare your excel table with the appropriate column and open it as tab in mapinfo.
    2 -Mapper your table and adjust the projection with Table Structure menue.
    3 -On the HOME tab, in the Windows group, click Tool Windows, and click MapBasic from the list, to open the MapBasic window.
    4- Type the following command in the window:
    update point_table set obj=createline(Start_X, Start_Y,End_X,End_Y).

    But still i dont know how tow to creat Mapbasic macro which can exceute these steps with one clic.

Bookmarks

Bookmarks

Posting Rules

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