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

[rohitchouhan]

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 : https://github.com/SAP-Custom-Widget/fileUploadXLS

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!

Conclusion

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.