Skip to main content

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout

 

 

Template:OutSystems/OSLanguageSwitcher

 

 

 

OutSystems

How to bootstrap numeric data from Excel with blank cells

Template:OutSystems/Documentation_KB/ContentCollaboration
  • Edit
    Collaborate with us
    Edit this page on GitHub
  • Question

    I am trying to bootstrap data from an Excel spreadsheet with blank cells. However, I get an error from blank cells defined as numeric fields. How can I import data from an Excel file with blank cells?

    image alt text

    Answer

    Blank cells cannot be interpreted as numeric, either integer or decimal. You have two options:

    • Change the spreadsheet. Change blank cells defined as numeric fields to 0.

    • Change the import process. Define the numeric fields as Text. Then, use a Data Type Conversion function such as TextToDecimal to convert the text to Decimal or Integer.

    • Was this article helpful?