Spreadsheet Importer Update: Wizard Dialog + Clipboard Uploads in Seconds

Spreadsheet Importer Update: Wizard Dialog + Clipboard Uploads in Seconds

🚀 Import Wizard & Copy-Paste Magic — UI5 Spreadsheet Importer


📌 Why another upload dialog? The wizard dialogue offers the option of importing unstructured data more effectively. In the first step, the correct header can be selected, but there are of course many more options for data that does not always correspond to the template.


🧙 Wizard Mode (since 2.2.0)


Article content

  • Guided sap.m.Wizard with four intelligent steps: Upload → Header Mapping → Messages → Preview.
  • Auto-progress when no issues are detected, but interactive fixes when they are.
  • Works in any UI5 app ≥ 1.84 via the simple flag useImportWizard: true (https://docs.spreadsheet-importer.com/pages/Wizard/).
  • Keeps all the validations, events and OData-agnostic magic you already know.

<core:ComponentContainer
    usage="spreadsheetImporter"
    async="true"
    settings="{
        useImportWizard: true,
        debug: true
    }"/>
        

✂️ Copy-Paste Super-power (new in v2.3.0)


Article content

Your users can now:

  1. Ctrl + V spreadsheet ranges directly from Excel/Sheets.
  2. Paste an .xlsx file copied from the desktop.

No temp files are written and you stay on the Upload step — perfect for lightning-fast repetitive imports . Works in the Standard Dialog and in the new wizard dialog.

By default, pasting is always enabled, but can be disabled with enablePaste : false.

settings="{
    useImportWizard: true,
    enablePaste: false
}"
        

🗺️ Try it live

Spin up the live demo and see the wizard and pasting for yourself:

https://livedemo.spreadsheet-importer.com/launchpad.html#ordersv4freestyle-136&/wizard


🎁 Meet me at Code Connect 2025

I will be at Code Connect again this year. Contact me directly there for a discount code on any Spreadsheet Importer plan. First-come, first-served!


🔗 Resources

Happy importing — and see you at Code Connect!

Jörg Brandeis

SAP training from a professional - Author of the book "SQLScript for SAP HANA".

1mo

Hi Marian, thank you for implementing this requirement. Copy & paste is really important for my customers and is always asked for. This is often missing in web interfaces in particular.

Tushar Patil

Analyst 2 @ Deloitte USI | SAP UI5 | SAP Fiori | OData | REST API | Ui5 | BAS | BTP | CF JavaScript

1mo

Excellent work Marian

Like
Reply
Renan Augusto Ferreira

Consultor SAP ABAP S/4HANA | RAP | Fiori/SAPUI5 | BTP IS CI/CPI

1mo

Hi Marian!!!! First, thank u for contribution, the comp. is amazing!! Then, one doubt, is this component works in a deep entity structure native? Need some adaptation in JS? I already worked with non deep entity and works fine :) thanks!!

Like
Reply
Radu Simen

SAP Business Technology Platform (SAP BTP) Cloud Architect / Engineering Team Lead & PhD Candidate (Smart Parking in Context of Complex Cyber-Physical Systems)

1mo

Excited for this 🔥

To view or add a comment, sign in

Others also viewed

Explore topics