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:
-
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
-
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.
-
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.
