Thank you for your question, @shashankagg.
I found this community blog which has some explicit code on uploading numeric data from spreadsheet, namely the part "for_numeric_value" in this line: from_row( xco_cp_xlsx=>coordinate->for_numeric_value( 2 ).
There might be other approaches: If the number you are attempting to import should have a dimension, ensure to also provide for that dimension. Decimals, if there are any, should be matching the target field's definition for decimals in every row. If the number is not treated like a number - e.g. because it is not used to calculate with, like a phone number, why not importing it as text/characters? Also, ensure the spreadsheet does not contain formula. Make it as plain as possible.
if that helped solve your request, please mark it accordingly. Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.