Skip to main content

 

 

Data

 

 

OutSystems

How to bootstrap numeric data from Excel with blank cells

  • Edit
  • 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?