• 113 views | 2 messages Discussion: LEAP
    Topic: error importing data from excel Subscribe | Previous | Next
  • Larisa Machado 7/9/2024

    I'm trying to import data from excel sheet trough the command "Analysis/Import Form Excel Templete" and the program show the next error:


    Even if I do the exercise of export and import without change anything and I need to solve this matter to update the data automatically instead manually.
    Thanks
    Larisa
  • Charlie Heaps 8/16/2024
      Best Response

    This usually indicates that an Excel cell does not contain a valid floating point number. Cells may sometime look like numbers but actually be formatted as string (e.g. with a preceding single quite character).
    Meantime, I will work on making LEAP more robust so that it gives a better error message that points to the exact cell with a problem.