MapInfo Pro

Expand all | Collapse all

Open excel file 250+ columns

  • 1.  Open excel file 250+ columns

    Posted 03-01-2020 21:22
      |   view attached
    Hello,

    Is it possible to open excel files with large number of columns, i.e 250+

    Thanks


    ------------------------------
    Alban Spella-Barberet
    Senior Planner - Wireless RF/TX Engineering & Deployment Standards
    NBN Co Limited
    North Sydney
    ------------------------------

    Attachment(s)

    xlsx
    test_315 columns.xlsx   9K 1 version


  • 2.  RE: Open excel file 250+ columns

    Pitney Bowes
    Posted 03-01-2020 23:46
    Hi Alban,

    Yes, it is possible with the Native X format.

    Go to Backstage, Options, System Settings
    Check box for 'Encode Workspace and Tab files'
    Set New Table Format to 'MapInfo Extended' and charset to 'UTF-8'
    Now when opening the XLS\XLSX file, the TAB file generated will be NativeX  using UTF-8 charset and will open it.

    NativeX can support up to 1000 columns.



    ------------------------------
    Shweta Shukla
    Pitney Bowes Software India
    Noida
    ------------------------------



  • 3.  RE: Open excel file 250+ columns

    Posted 03-02-2020 19:18
    Hello,

    Not working. (Several team members tried without luck)
    Have you tried the file I attached ?

    Thanks.

    ------------------------------
    Alban Spella-Barberet
    Senior Planner - Wireless RF/TX Engineering & Deployment Standards
    NBN Co Limited
    North Sydney
    ------------------------------



  • 4.  RE: Open excel file 250+ columns

    Pitney Bowes
    Posted 03-03-2020 00:04
    Hi Alban,

    Not working for me either. What I suggested is just meant for Tab files with more than 250 columns. Sorry about the confusion.

    This issue is already filed for a future fix.

    Regards,
    Shweta

    ------------------------------
    Shweta Shukla
    Pitney Bowes Software India
    Noida
    ------------------------------



  • 5.  RE: Open excel file 250+ columns

    Posted 03-03-2020 02:23
    Could you save the XLSX file to a CSV file and open this instead?
    I haven't tested myself with a 250+ column CSV file.

    ------------------------------
    Peter Horsbøll Møller
    Distinguished Engineer
    Pitney Bowes Software & Data
    ------------------------------



  • 6.  RE: Open excel file 250+ columns

    Posted 03-03-2020 02:29
    I just tested this, and it also fails. Too many columns

    ------------------------------
    Peter Horsbøll Møller
    Distinguished Engineer
    Pitney Bowes Software & Data
    ------------------------------



  • 7.  RE: Open excel file 250+ columns

    Pitney Bowes
    Posted 03-03-2020 02:32
    Yes a csv works Peter, I have tried it with a csv.


    ------------------------------
    Shweta Shukla
    Pitney Bowes Software India
    Noida
    ------------------------------



  • 8.  RE: Open excel file 250+ columns

    Posted 03-03-2020 03:16
    Ah, if you make sure to uncheck "Create Copy in MapInfo Format for Read/Write" it does work. Thanks, Shweta.

    ------------------------------
    Peter Horsbøll Møller
    Distinguished Engineer
    Pitney Bowes Software & Data
    ------------------------------



  • 9.  RE: Open excel file 250+ columns

    Pitney Bowes
    Posted 03-03-2020 08:39
    If you choose to "Create Copy in MapInfo Format for Read/Write" you need to make sure your system preference is set to use MapInfo Extended format  (NativeX) for new tables as the default, else it tries to create them in Native format which is capped at 250 columns.

    ------------------------------
    Bill Wemple
    Principal QA Engineer
    Pitney Bowes
    Troy, NY
    ------------------------------



  • 10.  RE: Open excel file 250+ columns

    Posted 03-03-2020 21:20
    Hello,

    CSV is not very convenient as we have some very large integer in some columns which are being converted by MI as scientific notation when doing the import and we don't want that.

    Is there a way to avoid this?

    I remember I wrote a case on previous version:

    Case Number
    22064454

    which I got told by support it would be fixed on V2019.
    Sadly that's not the case!

    So, we are a bit stuck at the moment.


    Best regards
    Alban



    ------------------------------
    Alban Spella-Barberet
    Senior Planner - Wireless RF/TX Engineering & Deployment Standards
    NBN Co Limited
    North Sydney
    ------------------------------



  • 11.  RE: Open excel file 250+ columns

    Pitney Bowes
    Posted 03-05-2020 13:07
    Edited by Bob Fortin 03-05-2020 13:08
    Hi Alban,

    We have a fix for this Excel column limit issue and plan to include it in 2019.1.

    -Bob

    ------------------------------
    Bob Fortin
    Software Architect and Distinguished Engineer
    MapInfo Pro Development Team
    ------------------------------