Skip to main content
OutSystems

How to bootstrap numeric data from Excel with blank cells

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?

bootstrap excel blank fields.png

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.