Level of Difficulty: Beginner. There are multiple ways to download files from Google Drive, some of which require authenticaton and others that require lots of code. Here’s the simplest way to download the files, provided you’ve got the right file url. The above approach also works when writing to memory stream, instead of copying toContinue reading “[Automation] Download Files from Google Drive in C#”
Category Archives: .NET Core
[Automation] Using Power Automate as a Data Integration Tool with Excel (for Bulk Processing)
Level: Beginner – Senior. Power Automate connects into multiple different platforms and systems, making it a very powerful integration tool. Power Automate has been positioned by Microsoft as a platform that aims to facilitate Robotic Process Automation (RPA). Although there is still some work to be done before the Power Automate toolset can match competitors,Continue reading “[Automation] Using Power Automate as a Data Integration Tool with Excel (for Bulk Processing)”
[Azure] In-Stream Excel Manipulation in .NET Core, using Azure Blob Storage and Azure Functions
Level of Difficulty: Junior – Senior. So you have an Excel template stored in Azure Blob Storage which will be read and manipulated by inserting data into the Excel template returning the manipulated file in stream. This can either happen (Time Trigger) on a schedule or per request (HTTP Trigger) basis. The decision is toContinue reading “[Azure] In-Stream Excel Manipulation in .NET Core, using Azure Blob Storage and Azure Functions”
[Python] Automating ASP.NET Core Web API Creation That Communicates With Your Database in 60 Seconds or Less
Creating an ASP.NET Core Web API That Communicates With Your Database in 60 Seconds or Less
The JPanda 