I have an Excel file I am trying to pull into the DataMapper and I cannot determine why it will not work. I have checked and the setting for the excel file and nothing looks out of the ordinary. There are no security settings that would prevent it to open. I am hoping the snippets below will com through. I am getting no other error messages other than “An error occurred while setting the value”. Any insight would be helpful.
Hi,
That seems known issue on Datamapper, If the Excel file has use a personalize cell format. The workaround is use standard or text format or save as a CSV format and import it.