Introducing fileUploadXLS: The Ultimate Excel Custom Widget for SAP Analytics Cloud

May 17, 2024 | by

fileUploadXLS custom widget is designed to streamline the process of handling Excel or XLS files within SAP Analytics Cloud (SAC), enabling users to easily retrieve file data in various formats such as JSON, raw text, and more.

Key Features

  • File Format Flexibility: Supports Excel and XLS files, ensuring compatibility with common data sources.
  • Data Retrieval: Easily retrieve file data in JSON, raw text, or other formats.
  • Filtering Capabilities: Apply filters to records based on value or character presence.
  • Data Hierarchy: Set hierarchical structures for better data organization.

Installation Guide

Watch Full Guidance on YouTube As well

To integrate the fileUploadXLS widget into your SAP application, follow these simple steps:

  1. Download the Widget:

    Click the link above to download the fileUploadXLS.json file.

    Or Download it from Github :

  2. Add to SAC Portal:

    • Navigate to your SAC Portal.
    • Select “Analytic Application” from the left sidebar.
    • Go to the “Custom Widget” tab.
    • Click the “+” icon on the right side and upload the fileUploadXLS.json file you downloaded.
  3. Start Using the Widget:

    • Once uploaded, the widget is ready to use in your applications.

Methods Overview

The widget offers a range of methods to interact with your data:

Set Methods

Method Parameter Type Description
setHierarchyStructure(hierarchy) Selection/Object array Sets the hierarchical structure for the data.
setFilterByValue(filterByValue) Selection/Object array Applies a filter to records based on a constant value.
setFilterByContains(filterByContains) Selection/Object array Applies a filter to records based on a value that contains a specific character.

Get Methods

Method Return Type Description
getDataAsJson() Selection/Object array Retrieves uploaded data in JSON/Selection/Object format.
getDataAsRaw() string Retrieves uploaded data in raw string format.
getTotalRecordsCount() integer Gets the total count of records.
getHeaders() string[] array Gets the headers of uploaded data as an array.

I hope you find the SAC-P Custom Widget: fileUploadXLS useful for your projects. Your feedback and suggestions are always welcome, as they help in making this tool even better. Thank you for your support, and happy data handling!


The SAC-P Custom Widget: fileUploadXLS is a powerful addition to SAP Analytics Cloud, designed to simplify the process of working with Excel and XLS files. With its robust data retrieval capabilities and flexible filtering options, it enhances your ability to manage and manipulate data efficiently. By following the easy installation steps, you can quickly integrate this widget into your applications and start leveraging its features immediately.


View all

view all