3625001 - Data inconsistency occurs when uploading an Excel sheet using CL_FDT_XL_SPREADSHEET

Symptom

You are using the class CL_FDT_XL_SPREADSHEET for reading the data from an excel.
But it doesn't work properly.

1. The amount fields in the internal table have more decimal places than the values in the Excel sheet.
2. The Amount column in the internal table displays the incorrect value.
3. It's getting blank value when trying to read the Excel data for a field.

Environment

Office Integration
SAP GUI for Windows

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

Excel format, Upload, Download, Excel sheets, Frontend service methods, Unknown error, Arbeitsblatt, Unpredictable behavior , KBA , BC-FES-XXL , XXL List Viewer/Lotus Connections , BC-FES-GUI , SAP GUI for Windows , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.