Resources  
  • Migrating from Power Pivot for Excel to Power BI: A Practical Guide to Modernizing Your Analytics PlatformMay 21, 2026. Modernize analytics by migrating from Power Pivot for Excel to Power BI. This guide covers migration steps, challenges, and benefits for a scalable solution.
  • C# Excel Library: Comparing 6 Options for .NET Developers in 2026May 05, 2026. Managing Excel files and Excel data is the lingua franca of internal business operations. Every line-of-business project eventually has to read and write them, export data, or convert Excel documents to another structured format. The library you pick shapes your deployment target, your licensing overhead, and how often your team chases down obscure format edge cases.
  • Analyze and Visualize Data Using Microsoft 365 Copilot in ExcelMar 13, 2026. Unlock data insights with Microsoft 365 Copilot in Excel! Analyze data, visualize trends, and leverage the Analyst Agent for advanced data-driven decisions.
  • Top Fixes for the “Too Many Different Cell Formats” Error in ExcelJan 31, 2026. Resolve the "Too Many Different Cell Formats" error in Excel! This guide offers practical solutions, from removing excessive formatting to using repair tools. Get your Excel files working smoothly again!
  • Automating Invoice Processing Using AI Models in Power AutomateJan 26, 2026. Automate invoice processing in Power Automate using AI! Extract key data like invoice ID and vendor from emails, and save it directly to Excel. Step-by-step guide included!
  • What Causes Excel Formulas to Recalculate Unexpectedly in Large Workbooks?Jan 19, 2026. Tired of Excel slowing down? Discover the hidden culprits behind unexpected recalculations in large workbooks and learn how to optimize performance for smoother workflows.
  • Power Apps Quick Functions – A Simple GuideJan 05, 2026. Power Apps functions are built-in formulas that help developers control how an app works. These functions are used to handle logic, manage data, control user actions, and improve the overall user experience. They allow you to build powerful applications with minimal code by defining what should happen when users interact with the app.
  • n8n Native Data Tables - Built-in Structured Data Storage for Smarter AutomationsDec 17, 2025. Unlock smarter automations with n8n Native Data Tables, a built-in data storage feature that allows you to persist structured data directly within your workflows. By eliminating the need for external databases, spreadsheets, or third-party tools, n8n simplifies data management while keeping automations fast and reliable. In this article, you’ll learn how n8n Native Data Tables work, explore real-world use cases, understand their benefits and limitations, and see practical automation examples you can apply immediately.
  • Import All Records into a Predefined Excel Template Using Power AutomateDec 10, 2025. Automate importing data into predefined Excel templates with Power Automate! Learn to dynamically add rows from any source while preserving formatting and layout. Streamline your data processes!
  • Empowering Insights: Data Analysis in Microsoft ExcelNov 25, 2025. Unlock data insights with Microsoft Excel! Master key functions like PivotTables, VLOOKUP, and statistical tools for effective data analysis and informed decisions.
  • CSHTML (Razor) Cheat Sheet — Quick Reference for ASP.NET CoreNov 21, 2025. Quickly master ASP.NET Core Razor syntax with this handy cheat sheet! Covers data binding, tag helpers, loops, forms, partials, layouts, and more for efficient development.
  • Generating Word, Excel, and PDF Documents Dynamically in ASP.NET CoreNov 17, 2025. Learn how to dynamically generate Word, Excel, and PDF documents in ASP.NET Core using OpenXML and QuestPDF. Includes code, diagrams, and best practices!
  • Implementing an Excel-like Editable Grid in Angular — Without Third-Party LibrariesNov 14, 2025. Craft an Excel-like editable grid in Angular without external libraries. This guide covers architecture, UX, accessibility, performance, and implementation.
  • 🧩 Integrating SQL Server with Excel and Access Databases: A Complete Step-by-Step GuideNov 08, 2025. Connect SQL Server with Excel & Access for seamless data workflows! Learn to import/export, query directly, and create linked servers. Boost reporting & automation.
  • 🧾 How To Create an Excel Dropdown List Using a .NET Core APINov 07, 2025. Create dynamic Excel dropdown lists using a .NET Core Web API and ClosedXML. Enhance data consistency and user experience with downloadable templates. Streamline data input!
  • .NET Core Cheat Sheet (Middleware + DI Lifetimes)Nov 04, 2025. Master ASP.NET Core! This cheat sheet covers Middleware (pipeline, registration, rules) and Dependency Injection (lifetimes, best practices, common mistakes).
  • 🌀 Saga Design Pattern - Orchestration Saga – Cheat SheetOct 14, 2025. Master the Orchestration Saga pattern for microservices! This cheat sheet explains how to maintain data consistency across distributed systems without 2PC. Learn to break down long transactions into smaller, manageable steps with compensating actions for rollbacks. Includes a C# example and real-world flight booking scenario. Ace your next interview by understanding the 'do + undo' principle and the difference between Orchestration and Choreography Sagas.
  • SOLID Principles Cheat Sheet 🚀Oct 14, 2025. Master the SOLID principles of object-oriented design with this cheat sheet! Learn Single Responsibility, Open/Closed, Liskov Substitution, Interface Segregation, and Dependency Inversion principles. Improve code maintainability, testability, and scalability. Includes clear explanations, bad/good examples, and memory tips for each principle. Boost your software architecture skills!
  • 🌀 Saga Design Pattern (Choreography Style) Cheat SheetOct 14, 2025. Master the Saga Design Pattern (Choreography style) with this cheat sheet! Learn how to implement distributed transactions using event-driven architecture. Explore the benefits of loose coupling and decentralized control in microservices. Includes a C# example demonstrating an order workflow with compensating transactions for rollbacks. Ideal for interviews and real-world applications like food delivery apps.
  • Azure API Management (APIM) - Cheat SheetOct 13, 2025. Your go-to Azure API Management (APIM) cheat sheet! Master API publishing, security, and monitoring with this concise guide. Learn about key features like security policies, traffic control, transformation, and version management. Explore architecture, common use cases, and best practices for optimal API performance and monetization. Perfect for developers and architects!
  • Gemini CLI Cheat Sheet Oct 13, 2025. Master the Gemini CLI with this comprehensive cheat sheet! Quickly install, configure, and utilize Google's AI-powered terminal assistant. From basic commands to advanced tools, learn to generate code, refactor, fix bugs, and more. Includes setup, usage, troubleshooting, and pro tips for efficient workflow. Boost your productivity with this essential reference!
  • What is Graph Algorithms: BFS, DFS, and Shortest Path with ExamplesOct 12, 2025. Explore graph algorithms like BFS, DFS, and Dijkstra's for efficient problem-solving. Learn how BFS finds shortest paths in unweighted graphs, DFS excels in cycle detection, and Dijkstra's optimizes routes in weighted graphs. Discover real-world applications in navigation, social networks, and AI, mastering essential tools for connectivity, optimization, and exploration in computer science. These algorithms are crucial for developers tackling complex challenges.
  • Automating Gmail to Google Sheets using ZapierOct 07, 2025. Learn how to automate your Gmail data collection into Google Sheets using Zapier! This no-code tutorial guides you through creating a Zap to automatically transfer data from Gmail to Google Sheets, saving you time and reducing manual errors. We'll cover setup, testing, publishing, and even sharing your Zap as a template on GitHub for easy reuse. Streamline your workflow today!
  • 🧾 Automated Student Data & Feedback SystemOct 07, 2025. Arpita Poddar's project automates student data collection and feedback using Google Forms, Excel, Gmail, and Make.com. This no-code system streamlines data entry, instantly sends personalized acknowledgments, and eliminates manual intervention. Learn how to build a fully functional system that enhances efficiency and improves communication through automation. It's a perfect example of automating digital solutions for real-world problems.
  • React Hooks Cheat Sheet Part-2 Sep 16, 2025. Master advanced React Hooks! This cheat sheet explores useMemo, useCallback, useImperativeHandle, useLayoutEffect, and custom hooks. Optimize performance by memoizing computations and functions. Gain control over child components and DOM measurements. Build reusable logic with custom hooks for cleaner, more maintainable React applications. Elevate your React skills today!
  • React Hooks Cheat Sheet Part-1Sep 16, 2025. Learn useState for state management, useEffect for side effects, useContext for avoiding prop drilling, useRef for DOM access, and useReducer for complex state logic. This guide provides practical examples to quickly grasp these essential hooks and build robust React applications. Perfect for beginners and experienced developers alike!
  • AI Sheets: Practical, No-Code Dataset Work Without AgentsSep 01, 2025. AI Sheets is an open-source, spreadsheet-style tool for building, transforming, enriching, and evaluating datasets with AI models.
  • Create an Invoice Number Tracker in Google SheetsAug 27, 2025. Effortlessly create an invoice number tracker in Google Sheets using formulas & Make.com. Automate unique IDs, monthly resets, & notifications without code!
  • Automate Twitter Posts from a Spreadsheet (Free Method)Aug 27, 2025. Automate Twitter (X) posts for free using Google Sheets, Make.com, and Buffer. Schedule tweets from a spreadsheet without code or paid APIs. Perfect for personal or small business use!
  • Use Make.com to Send Slack Reminders from Google SheetsAug 27, 2025. Automate Slack reminders from Google Sheets using Make.com! This guide provides a no-code workflow for scheduling and sending timely notifications. Easy setup!
  • Write Prompts for Data Analysis and Excel Work with AIAug 23, 2025. AI can analyze data, generate formulas, and automate Excel tasks — if you write the right prompts. Learn prompt engineering techniques for data analysis and spreadsheet automation.
  • CSS Basics: Styling, Layouts, and Responsive DesignAug 19, 2025. CSS (Cascading Style Sheets) is used to style and design web pages. It enhances appearance with colors, layouts, and animations, ensures responsive design, separates content from styling, and saves time with reusable code.
  • How document's metadata/property sync behaves - SPO To MS Office Files (Word, Excel, PPT) and MS Office Files Aug 16, 2025. Learn how document metadata and property synchronization works between SharePoint Online (SPO) and Microsoft Office files like Word, Excel, and PowerPoint. Understand sync behavior, limitations, and best practices for managing file properties across platforms.
  • Fetch Column Headers from Excel Files in a Folder using Power AutomateAug 15, 2025. In this article its mainly focus on extracting the column header names from multiple excel sheet stored in a folder using Power Automate.
  • CSS Cheatsheet – A Complete Guide for BeginnersAug 12, 2025. CSS styles web pages by controlling colors, fonts, layouts, spacing, and more. This cheatsheet covers essential concepts like selectors, box model, flexbox, grid, responsiveness, transitions, and advanced features for both beginners and pros.
  • Send Birthday Emails with Gmail + Google SheetsAug 11, 2025. Learn how to send automatic birthday emails using Gmail, Google Sheets, and Make.com—completely free. Step-by-step guide with templates, filters, and a copy-paste blueprint.
  • Beginner’s Guide to Power BI: DAX, Measures, and Learning by DoingAug 07, 2025. I’m still new to Power BI, but I’ve already learned a lot... and I’m still learning! Especially about DAX formulas, measures, and how they’re different from Excel. This post is my beginner-friendly take on what clicked, what confused me, and how I’m figuring it out along the way.
  • Automate Google Sheets Data Entry from Typeform for FreeAug 07, 2025. For lead capture, surveys, and real-time form response tracking #Makecom #GoogleSheets #FreeAutomation
  • Guide: Importing Test Cases into Zephyr Squad using ExcelJul 10, 2025. This guide provides step-by-step instructions for importing multiple test cases into Zephyr Squad using an Excel file. It also explains the importance of the 'Discriminator' field, the correct use of 'Issue Type = Test', and how to structure test steps.
  • Data-Driven Testing in Selenium Using Excel and TestNGJun 20, 2025. Learn how to perform data-driven testing in Selenium using Excel and TestNG. Read test data from Excel with Apache POI and automate test execution using TestNG's DataProvider feature.
  • MongoDB Filter Query Cheat SheetJun 04, 2025. This article explains how to use filters in MongoDB GUI tools (like MongoDBCompress or Compass) using simple query examples. You’ll learn how to search for records, use conditions, sort results, and filter by dates or partial matches, all without writing any code!
  • Power Automate Desktop: Read Excel and Use as Data Table (PAD)May 31, 2025. Learn how to read a local Excel file and convert it into a Data Table using Power Automate Desktop. Easily loop through rows, display data in message boxes, and enhance your automation workflows.
  • Why GenAI LLM Models Fail in Business but PT-SLMs ExcelMay 17, 2025. Many GenAI LLMs struggle in business due to high costs, slow performance, and a lack of domain focus.
  • How to Clean Data in Pivot Query in ExcelMay 16, 2025. In this article, we will learn how to clean and prepare your data directly within Pivot Queries in Excel.
  • Programmatically Manage Power Automate Flows: How to Create, Modify, and Remove Cloud Flows with CodeApr 30, 2025. In this article, learn how to programmatically create, update, and delete flows using the Dataverse Web API and the .NET SDK, whether you're automating deployments, enforcing governance, or integrating with DevOps tools. This article provides C# and JavaScript examples to streamline your flow management process.
  • How to Load Data in ExcelApr 29, 2025. Learn how to import, clean, and manage multiple tables in Excel using Power Query. This step-by-step guide covers importing data from Excel workbooks, transforming data, using "Create Connection" for multiple tables, and loading them into Excel or the data model for further analysis.
  • Excel-Powered CRUD in SharePoint List Using PnP JS and XLSX Apr 24, 2025. Utilizing Excel as an information source, PnP JS for SharePoint operations, and the XLSX library for parsing Exceed expectations records, I will walk you how to perform out CRUD (Create, Read, Update, Delete) method in a SharePoint list.
  • List All Power Automate Cloud Flows ProgrammaticallyApr 23, 2025. Power Automate allows developers to programmatically manage cloud flows stored in Microsoft Dataverse. Whether you’re automating DevOps, migrating solutions, or enforcing enterprise governance, managing flows through code is powerful and scalable.
  • Excel Sheet Encryption using AES encryption in .Net Dec 23, 2024. Learn how to use AES encryption in C# to secure data by encrypting and decrypting files, including CSV or Excel. Explore FileStream, CryptoStream, and the System.Security.Cryptography namespace for robust data protection.
  • Bulk Import of ID Card Data from Excel in ASP.NET MVC C#Nov 22, 2024. This guide covers the process of parsing Excel files, extracting data, and inserting it into a database, ensuring smooth data handling and optimization for large datasets in a seamless, automated process.
  • What are the Main Differences in Service Offerings Between AWS and Azure?Oct 11, 2024. AWS and Azure offer similar core cloud services, but AWS generally provides a broader range of options while Azure excels in Microsoft ecosystem integration.
  • Tracking Exports to Excel in Dynamics 365 CRM with Email AlertsSep 22, 2024. This guide covers the process of monitoring data exports, configuring workflows, enabling real-time alerts, and ensuring efficient data management and timely updates in your CRM system.
  • Download Multiple Excel Files via Web API and AngularSep 20, 2024. In this article, we will learn how to implement file streaming in the backend and trigger downloads via Angular's HTTPClient, enabling efficient file handling across platforms.
  • Download Multiple Excel Files via Web API .NET and AngularSep 20, 2024. To export multiple Excel files, various approaches can be used, including downloading a zip file, creating multiple worksheets in a single Excel file, or calling APIs multiple times to retrieve files. Another method involves using Base64 strings, though it's less efficient due to increased file size.
  • Create Calendar Table Using Power QuerySep 20, 2024. We’ll explore step-by-step instructions for transforming date data, implementing essential date functions, and enhancing your data analysis capabilities in Excel and Power BI. Perfect for improving your reporting and time intelligence skills!
  • Passing Data from Power Automate to Excel sheetSep 17, 2024. Office Scripts are a feature in Microsoft Excel to automate and customize repetitive tasks. It allows the users to create custom functions and automation sequences directly within the Excel interface, by recording tasks or directly coding it in TypeScript.
  • Update a SpreadSheet from a Power Automate FlowSep 17, 2024. Learn how to automate data entry in Excel by integrating flows, streamlining tasks, and improving productivity. Perfect for automating repetitive updates, this tutorial simplifies data management in Office 365 and the Power Platform.
  • Introduction to Office ScriptSep 13, 2024. Office Scripts is a feature in Microsoft Excel that allows you to automate repetitive tasks using JavaScript. This can significantly streamline your workflow by enabling you to create custom scripts that perform various operations on your spreadsheets. Here's an overview of Office Scripts
  • Creating Excel Reports with EPPlus in ASP.NET Core 8.0Sep 02, 2024. Learn how to generate and manage Excel reports in ASP.NET Core 8.0 using the EPPlus library. This guide covers the essentials of integrating EPPlus for creating and manipulating Excel workbooks, including data export and report automation.
  • The Best Way to Work with Excel in .NET: MiniExcelAug 16, 2024. MiniExcel is a lightweight, high-performance .NET library for handling Excel files. Simplifies tasks like reading and writing data with minimal dependencies and fast processing. Ideal for reporting, data export/import, and automation, MiniExcel offers a streamlined approach without the complexity of heavier libraries.
  • Read Excel (XLSX) file in Angular 18Aug 05, 2024. Learn how to read and process Excel (XLSX) files in Angular 18 with this comprehensive guide. Explore methods for integrating Excel file handling into your Angular application, using libraries and tools to parse and extract data efficiently.
  • Exciting New Features in PowerApps: Named FormulasJun 28, 2024. Discover the latest enhancements in PowerApps, including the powerful Named Formulas feature. This blog post walks you through enabling and using Named Formulas, which streamline app development by allowing you to define and reference values consistently across your app.
  • Comparing Performance: Regex vs String Methods in C#Jun 27, 2024. In C#, developers choose between Regex and string methods for manipulating strings. String methods are faster and more readable for simple tasks, while Regex excels in handling complex patterns and advanced text processing.
  • Using C# and OpenXML to Read Large Excel FilesJun 18, 2024. Learn how to efficiently read large Excel files using C# and OpenXML in this comprehensive guide. Explore techniques to handle big data within Excel, leveraging the power of OpenXML SDK for performance optimization.
  • MongoDB Cheat Sheet: Essential Commands and OperationsJun 04, 2024. The MongoDB Cheat Sheet is your go-to guide for essential commands and operations. Covering installation, setup, CRUD operations, indexing, aggregation, data modeling, and more, it simplifies database management.
  • How to Use Microsoft Copilot in ExcelMay 24, 2024. Microsoft Copilot in Excel is an AI-driven tool designed to assist users in performing data analysis, generating insights, and automating tasks. Herein this article we will learn how to get started with Copilot in Excel.
  • JavaScript Cheat SheetMay 07, 2024. In this article, we will see a cheat sheet of JavaScript that will be helpful as a quick reference. Get ready to level up your JavaScript skills with our ultimate cheat sheet! From basic syntax to advanced techniques, this curated collection has you covered for quick reference and easy navigation.
  • MySQL Queries Cheat SheetApr 18, 2024. In this article, we will learn about MySQL querying essentials, covering basic SQL commands, data manipulation functions, constraints, and frequently asked questions, providing valuable insights for both novice and experienced developers.
  • Create Bulk Variables in Azure DevOps Variable Groups with CLIMar 22, 2024. Learn how to automate the process of adding multiple variables to a Variable Group in Azure DevOps using the Azure DevOps CLI and Microsoft Excel. This article provides a step-by-step guide to streamline the process and avoid manual data entry.
  • Save specific Email to Excel File using Azure Logic App Mar 12, 2024. Azure Logic Apps is a cloud-based service that streamlines business processes. This guide details how to automate moving specific emails to Excel in OneDrive seamlessly using Azure Logic App workflows.
  • Top 10 VPNs in 2024Mar 11, 2024. While some VPNs excel in speed, others prioritize features or affordability. Here's a list of some of the top contenders in 2024.
  • Autonumber Attribute Generation: Programmatically or Non-ProgrammaticallyMar 08, 2024. In this article, we will discover techniques for auto-incrementing identifiers, managing data, and implementing automation, potentially utilizing frameworks like Entity Framework.
  • Exploring the Export Functionality within SharePoint ListsMar 04, 2024. The Export feature in SharePoint Lists facilitates exporting list data to formats like Excel or CSV, aiding data analysis and sharing. It enhances collaboration by enabling users to extract and manipulate data conveniently.
  • How to Read or View Exchange Database EDB File ProgrammaticallyFeb 28, 2024. Explore methods to Read or View the Exchange Database EDB File Programmatically. Know how to use this Exchange Server Managed API to View or Read Exchange EDB files.
  • Automating Excel data to SharePoint Lists with Power AutomateFeb 28, 2024. In this article, we will discover seamless automation of Excel data migration to SharePoint Lists using Power Automate. Streamline your workflows, enhance productivity, and ensure data integrity with this efficient solution.
  • How to Create CSV File from Excel Spreadsheet Feb 27, 2024. Explore methods to Create CSV File from Excel Spreadsheet. Get the best solutions to carte or save CSV files from Excel Spreadsheet in easy steps.
  • Create an Excel Template and Upload It to the LibraryFeb 26, 2024. In this article, Here, you'll find instructions on how to create and use an Excel template for various tasks, ensuring a blank starting point for your projects.
  • How to Create a SharePoint List Directly from ExcelFeb 13, 2024. Learn to seamlessly migrate Excel data to SharePoint lists. Enhance collaboration and data management with this step-by-step guide.
  • Excel Formula: Generate Random Dates and Extract Day, Month, Year, QuarterFeb 05, 2024. This article shows how to Generate Randomised Dates and Extract Day, Month, Year, and Quarter using a Single Formula in Excel. Explore advanced Excel formulas using the LET function and dynamic arrays to generate 100,000 rows of randomized dates.
  • PowerApps Save as CSV from Export to ExcelJan 29, 2024. In this article, we will learn how to export a report in CSV format using PowerApps and Power Automate. Create a SharePoint list, connect data sources, and build a flow to export data to a CSV file.
  • PowerApps Save as CSV or Generate Report from CSV/ExcelJan 24, 2024. I often come across where the business wants to have a report in excel format. But the question is could we save as csv using PowerApps. Then with the help of Power Automate we can. There is a lot of requirements which could be achieved in PowerApps with the help of Power Automate.
  • Write the Data to Excel TemplateDec 29, 2023. Learn the art of writing data into Excel templates in C# with this step-by-step guide. Create an ASPX page, use libraries like Newtonsoft.Json, and implement the Factory Pattern effortlessly.
  • Using Date Function in Data Validation in ExcelDec 10, 2023. Learn how to use Excel's DATE function for effective data validation. Set criteria for a date column to ensure entries fall within a specific range, enhancing accuracy and data quality.
  • VSTACK Append in Excel with Total RowNov 24, 2023. In the article, Explore the power of Microsoft Excel with the LET, VSTACK, and HSTACK functions. This article guides you through creating complex formulas for dynamic data combination and summarization across multiple tables.
  • Streamlining Azure DevOps Management with ExcelNov 22, 2023. In the dynamic landscape of software development, effective project management is non-negotiable. Microsoft Azure DevOps emerges as a powerhouse, offering a suite of tools covering the entire software development lifecycle. Among its array of features, the integration of Excel Connector proves to be a game-changer, empowering teams to manage projects more efficiently by leveraging the familiar and flexible environment of Excel.
  • Efficient Data Integration using HSTACK & XLOOKUP FunctionsNov 07, 2023. This article effectively explains how to integrate data from different sources using Excel's HSTACK and XLOOKUP functions. The step-by-step breakdown and the clear demonstration with sample data make it easy for readers to understand and implement the data integration process seamlessly.
  • Create Excel Charts (Waterfall, Funnel, Treemap, etc) with JavaOct 30, 2023. This article explains how to create waterfall chart, funnel chart, treemap chart, box and whisker chart, sunburst chart, and histogram chart in Excel with Java.
  • Creating a Calendar Table in Excel Power Query and its BenefitsOct 20, 2023. This blog is based on Creating a Calendar Table in Excel Power Query
  • Read And Upload Excel Data To Oracle TableOct 18, 2023. In the realm of data management and integration, the process of reading and uploading Excel data to an Oracle table involves multiple fundamental steps. First, the data needs to be read from an Excel file, which might contain various types of information such as numbers, texts, or dates. This data is typically organized in rows and columns.
  • ClosedXML Excel Printing settingsOct 06, 2023. This article will describe all the printing settings available in CloseXML excel library.
  • Python in Excel Data Analysis using the New PY FunctionOct 04, 2023. This article delves into performing Data Analysis using the new Python in Excel PY function
  • Excel Sheet Generation in .NET Core 6 Web API and Angular 15Sep 04, 2023. By implementing this approach, you create a hassle-free way for users to generate and download Excel sheets from your web application, improving data reporting and export capabilities. This can be particularly useful in scenarios where users need to work with tabular data in Excel format without manual data entry or complicated procedures.
  • IoT Success with AzureAug 25, 2023. Unlock Azure IoT Success: Best Practices for Seamless Implementation. From defined objectives to compliance, explore how to excel in IoT projects within the Azure ecosystem for transformative outcomes.
  • Add Row in Excel using Power AutomateAug 18, 2023. Streamline Excel Data Input: Automate with Power Automate and Microsoft Forms. Learn how to effortlessly add rows to Excel using these tools, enhancing data management and efficiency.
  • Convert Excel Data Into DataTableAug 08, 2023. Learn to leverage the .NET Excel framework for effortless handling of Microsoft Excel files in your .NET applications. Discover conversion techniques, API integration, and practical implementation for data manipulation.
  • Extracting Text from Images using Azure OCR and Match in an Excel Sheet using PandasJun 22, 2023. The concept revolves around enabling the police to capture a snapshot of a vehicle's license plate and quickly retrieve the corresponding information from a database. In this particular scenario, an Excel sheet serves as the database for storing and accessing the relevant details.
  • WebdriverIO Functions and CommandsJun 12, 2023.
  • JavaScript Array Methods Cheat SheetJun 01, 2023. Array methods in JavaScript are used for a variety of purposes to manipulate, transform, and work with arrays more efficiently
  • Efficient Directory Monitoring Techniques for Windows 10 with C# and .NET Core 7May 26, 2023. Learn how to monitor a directory in Windows 10 using C# and .NET. This guide will walk you through the different approaches and techniques for monitoring directories and the process of implementing a directory monitoring system that allows you to track file changes and take action programmatically.
  • Export To Excel In Angular Using ExcelJSMay 11, 2023. Export To Excel In Angular Using ExcelJS