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?
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.