MapInfo Pro

Expand all | Collapse all

Format for Excel Files

  • 1.  Format for Excel Files

    Posted 01-30-2020 16:01
    In my previous version (15), an "imported" Excel file would mostly match with the field formats to those saved in Excel.  The new version coverts all numeric "float" fields to character.  As most fields are like this, is there some way to maintain the formatting (and I have dealt with previous problems using particular Excel formats but I am using "general" here with no designated digits but also doesn't work with "numeric" at 2 digits).?

    ------------------------------
    Rex Edwards
    CAMPBELL AVIATION GROUP
    Alexandria VA
    ------------------------------


  • 2.  RE: Format for Excel Files

    Posted 01-31-2020 02:44
    Hi Rex

    Yeah, I also recently noticed this and raised this issue with our tech support.
    I'll keep you posted on what we find out.

    PS: Have you tried using the "old" XLS format? Does that work better?

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



  • 3.  RE: Format for Excel Files

    Posted 01-31-2020 10:16
    Using the 97-2003 format works just fine.  Thanks

    ------------------------------
    Rex Edwards
    CAMPBELL AVIATION GROUP
    Alexandria VA
    ------------------------------



  • 4.  RE: Format for Excel Files

    Employee
    Posted 01-31-2020 10:57
    Hi Rex.
    I entered the issue into our system.  Need to see if it is a change in the MS Access DB engine that MIPro uses to open the newer XLSX format, to see if it could be returning a different type than MIPro expected.
    Opening as an  older XLS  (which is handled by MIPro internal functions for XLS format) or exporting to CSV in Excel then opening in MIPro seems to work fine.

    Regards,
    -Bill

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