Integrating Excel Calculations into UIPath with SpreadsheetWeb API | Step-by-Step Tutorial
In this video, we walk you through the process of automating Excel-based calculations using the power of UIPath and SpreadsheetWeb API. Learn how to transform your Excel files into APIs and seamlessly integrate them into UIPath workflows. By the end of this tutorial, you'll be able to dynamically send inputs to the API, retrieve calculated results (such as shipping costs), and automate Excel calculations effortlessly.
📌What You'll Learn:
How to upload Excel files to SpreadsheetWeb and convert them into APIs.
Configuring UIPath to interact with the SpreadsheetWeb API.
Sending dynamic inputs to APIs using UIPath.
Processing and logging API responses.
Automating complex Excel-based workflows for better efficiency.
SpreadsheetWeb is a no-code platform that helps businesses translate their collective Microsoft Excel expertise into robust web applications with limited reliance on IT resources. It empowers ordinary Excel users to create secure, responsive, database-driven applications directly from their Excel spreadsheets. By transforming the data collection mechanism from individual file-based spreadsheets into structured databases, the system provides a higher level of governance for critical information. With built-in workflow and reporting capabilities, SpreadsheetWEB offers an end-to-end platform for business users seeking to create and manage their web applications.
Video Chapters:
00:00 Introduction
00:05 Overview and Purpose
00:10 Setting Up Excel and API
00:21 Reviewing the Sample Excel File
00:35 Publishing Excel as API
00:50 UiPath Project Setup
01:19 Creating Variables in UiPath
01:48 Configuring HTTP Request in UiPath
02:37 Setting Headers and Body
03:10 Deserializing JSON Response
03:36 Logging and Testing the Results
04:05 Running Tests and Reviewing Outputs
Sign up to use SpreadsheetWeb- it's free and always will be! Start using the app right away once you've created your account:
https://identity.spreadsheetweb.com/i...
Let's connect:
Twitter - @spreadsheetweb
Facebook - / spreadsheetweb
LinkedIn - / pagos-spreadsheetweb