0
 Followers
3
 Likes

Ignore the Excel calculation error

Backend
New

Hi

One of our requirement is to import a financial spreadsheet which has multiple sheets with each sheet has more than 300 columns of data with formula. As we load the data into table, certain cell in sheet has calculation error and data is imported as "#DIV/0!" from excel but it fails to write to table even though the corresponding table column is text.

 Can we default the attribute value to null when its corresponding cell has errors.

Thanks.

Created on 11 Jan
Comments (1)

Changed the category to Backend


views
67
Followers
0