onedevatlasBeta
Browse the atlas
AllCAPUI5ABAPBTP
All UI5FreestyleFiori elementsWeb Components
CapabilityData & Persistence

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

sap/ui/export/Spreadsheet exports tabular data to an XLSX document, with the configuration preset for sap.ui.comp.smarttable.SmartTable and sap.ui.mdc.Table.

Not covered: At export. The spreadsheet export documentation describes no import, so reading a spreadsheet a user uploads is left to the application.

Whether the UI5 export API and the community import components were built to meet has not been assessed; they answer opposite halves of the concern.

SourceSAP-docs/sapui5: Spreadsheet Exportchecked
THE COMMUNITY ADDS

The import side, in the browser: a dialog reads the uploaded file and submits its rows through the app's own OData model, so the service the app already talks to decides what is written.

ui5-cc-spreadsheetimporter

Artifacts1

1 of 1 artifacts
ArtifactSignals
Packages1
ui5-cc-spreadsheetimporterUI5 component adding a spreadsheet upload dialog to Fiori apps
Signals
none

Seen working6

ArtifactSignals
Samples6
spreadsheetimporter/packed-deployment-abapUI5 app template deploying the Spreadsheet Importer once to ABAP
none
spreadsheetimporter/sample-adaptation-banksAdaptation project adding spreadsheet upload to Manage Banks
No license
spreadsheetimporter/sample-adaptation-banks-updateManage Banks adaptation updating existing records from a spreadsheet
No license
spreadsheetimporter/sample-full-btpCAP Risks and Mitigations project with a Spreadsheet Upload button
none
spreadsheetimporter/sample-odata-api-uploadUI5 app opening the Spreadsheet Importer on on-premise OData services
none
spreadsheetimporter/sample-standaloneUI5 app opening the Spreadsheet Importer on its own
No license

Details

Coverage
statecore and community, UI5
assessed
relationshipunassessed
domainData & Persistence
also inABAP, CAP
SourceSAP-docs/sapui5: Spreadsheet Exportchecked
For your agent
Ref
capability:data-import-export
JSON
/capabilities/data-import-export.json
MCP
Connecting an agent