BlogBlogtypeA post on somebody's own site or a community platform. Nobody edits it after publication, so it dates from the day it was written.See every one →SAP CommunityPart 1 of 2

How to mass upload from a spreadsheet file into an SAP Fiori app in SAP BTP ABAP Environment Part 1

Part 1 of a three-part series on mass-uploading records from a spreadsheet into a RAP business object in the SAP BTP ABAP environment, using the XCO XLSX module to parse an uploaded Excel file without any open-source library. It reads a named worksheet by its column-and-row coordinates into an internal table through the row-stream operation, then creates or updates records with the EML MODIFY ENTITIES statement, and reserves the Fiori elements custom-action wiring and the download/template generation for Parts 2 and 3.

written for artifact:btp-abap-environment 2208

Where it sits

Explains
Importing and exporting table dataABAPImporting and exporting table datacapabilityGetting 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](capability:seed-data).
Source
reachable

Who is behind it

DebrajManna87author

In this series2

  1. 1
    How to mass upload from a spreadsheet file into an SAP Fiori app in SAP BTP ABAP Environment Part 1you are here
  2. 2

Properties

About this work

declared and crawled
Published
declared
Published on
declared
Views
crawled
32,699

For data-import-export

on the edge
Applies in
authored
abap

Details

Graph8 edges
POINTS OUT →
explainsImporting and exporting table datacapability, core and community
published onSAP Communitypublishing source
discovered viaSAP Communityabap-cloud-tag
discovered viaSAP Communityabap-rap-tag
discovered viaSAP Communitybtp-abap-environment-tag
discovered viaSAP Communityfiori-elements-tag
discovered viaSAP Communityfiori-launchpad-tag
discovered viaSAP Communitys4hana-abap-environment-tag
Source
History1
  • Entered the atlasDiscovered via SAP Community · abap-cloud-tag, SAP Community · abap-rap-tag, SAP Community · btp-abap-environment-tag, SAP Community · fiori-elements-tag, SAP Community · fiori-launchpad-tag, SAP Community · s4hana-abap-environment-tag.
For your agent
Ref
content:how-to-mass-upload-from-a-spreadsheet-file-into-an-sap-fiori-app-in-sap-btp-abap
JSON
/content/how-to-mass-upload-from-a-spreadsheet-file-into-an-sap-fiori-app-in-sap-btp-abap.json
MCP
Connecting an agent