In our project, we have a requirement to load the data from a macro file. I tried to load the data using Excel Workbook format but it seems a subset of data is not getting loaded correctly i.e. if I have 100 records to be loaded, then 96 records are getting loaded correctly but the remaining 4 records are wrong (shows incorrect value).
Isn't it possible to get the data from an xlsm file using Excel File Format in BODS? Please help !
I am re-opening the thread since it is identified again that the problem still exists with some of the files though the cursor is in the home position.
You, 1st of all need to take help from your OS support team to help your users to get the Exact tables/indexes & vlookup job done properly, because that's why the error will occur in some matters only, not all the matter. If SAP issue, then it would have occurred in the scenarios. Its not SAP issue. If the Excel is formatted properly, then there is no issue from the SAP side.
I have gone through the links that you shared above. But I am able to load the data from xls file accurately and the data variance happens only with a few records when the data is loaded from xlsm (macro file).
You need to take help from your BASIS person for the macro enabled for uploading data in all the correspondence ALEs & also for the correspondance BASIS settings parameters values increasing. On the contrary, in your case, the .xlsx file also should get uploaded fine
Finally the cause of the issue is identified. This data discrepancy happens when the macro file is saved without moving the cursor back to the home position. So if we ensure that the file is saved correctly with the cursor begin in the home cell, then the data would get loaded correctly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.