Importing and exporting table data

Getting a file somebody supplies, a spreadsheet, a CSV or a JSON dump, into tables with its columns mapped and its values checked, and getting table content back out as a file. Data shipped with an application for development and demonstration is seed data.

Overview

SAP SHIPS

XCO_CP_XLSX reads and writes XLSX content held as an xstring, and CL_CSV_FACTORY creates writers that turn internal table content into CSV; both are among SAP's released ABAP classes.

Not covered: At converting content. Getting the file from a user, mapping its columns onto a target structure and checking values before they are written are left to the application; SAP's own example uploads through a generated Fiori elements preview.

SAP-samples repositories demonstrate the concern, a JSON uploader for SAP BTP ABAP Environment and an ALV export to Google Sheets; samples are not counted as providers. The community tools differ in where the file is handled: ABAP Spreadsheet Importer parses an uploaded XLSX or CSV file in the backend and creates its rows on a RAP business object, and abap2UI5 for Excel moves table data between an abap2UI5 app and the open workbook without a file. How these tools relate to the XCO classes has not been assessed.

Artifacts7

7 of 7 artifacts
ArtifactSignals
Apps3
abap2UI5 for ExcelOffice add-in running an abap2UI5 app in Excel's task pane
Signals
none
abap2UI5-addons/table-content-loaderUpload, edit and download ABAP table content as JSON, CSV or XLSX
Signals
Functional boundary
boy0korea/abap2jsonExports and imports ABAP table content as zipped JSON
Signals
none
Packages4
ABAP Spreadsheet ImporterABAP component importing XLSX or CSV files into RAP business objects
Signals
none
abapDataToTableImportMaps clipboard, Excel or text data onto a declared ABAP structure
Signals
none
boy0korea/ABAP2XLSX_HELPERHelper methods over abap2xlsx for Excel, JSON and tables
Signals
none
mkysoft/xlsxreaderReader for Excel spreadsheets in OpenXML format from ABAP
Signals
Quiet

Content1

Group by
Piece, what it offers
How to mass upload from a spreadsheet file into an SAP Fiori app in SAP BTP ABAP Environment Part 1
SAP Community, DebrajManna87, part 1 of 2, Blog

Seen working2

ArtifactSignals
Samples2
abap-file-uploaderSample uploading a JSON file into an ABAP table on BTP ABAP
none
SAP-samples/abap-alv-google-upload-sheetSample exporting SAP GUI ALV grid data to Google Drive
Functional boundary

Details

Coverage
statecore and community, ABAP
assessed
relationshipunassessed
also inUI5, CAP
For your agent
Ref
capability:data-import-export
JSON
/capabilities/data-import-export.json
MCP
Connecting an agent