Resources  
  • Power Apps: Bind Default Values from SharePoint Using Slider ControlMar 28, 2024. In this article, we will learn how to enhance user experience in Power Apps by utilizing the Slider control. This tutorial guides you through binding default values seamlessly from SharePoint, streamlining data integration, and enhancing interactive elements for a more intuitive user interface.
  • What Are Data Attributes in HTML, and How Are They Used?Mar 28, 2024. Know the data attributes in HTML. Data attributes are commonly used in conjunction with JavaScript and CSS to enhance the functionality and styling of web pages.
  • vSphere Pods using VDS based Supervisor in vSphere with Tanzu?Mar 28, 2024. vSphere 8.0 Update 1 removes NSX-based networking restriction for Supervisor Services, allowing VDS-based Supervisors to deploy vSphere Pods.
  • Automated VMware Cloud Foundation Host commission using ESXiMar 28, 2024. Learn how to automate ESXi host provisioning with Kickstart and streamline VMware Cloud Foundation host commissioning workflows.
  • Enhancing Code Quality with SonarQubeMar 27, 2024. In this article, we will explore SonarQube in detail, covering its features, benefits, and hands-on examples to demonstrate its usage in real-world scenarios.
  • Text Sentiment Anlysis using Azure OpenAI Service with .NET CoreMar 26, 2024. Article is about how to set up and integrate it into a .NET Core application, and provide examples of common AI use cases, including text sentiment analysis.
  • RXJS Operators Used in AngularMar 26, 2024. RxJS (Reactive Extensions for JavaScript) empowers reactive programming in Angular, handling asynchronous tasks like HTTP requests. Key operators include map, filter, tap, switchMap, mergeMap, catchError, debounceTime, distinctUntilChanged, and forkJoin for parallel requests.
  • Disable Quick Create Views Using PowerShellMar 26, 2024. In this article we will discuss step by step process to disable quick create view for multiple entities using powershell script.
  • Create Animated ATM Cards Using React With BootstrapMar 24, 2024. In this article, I will show you steps to make an interactive credit card form UI component in React application using the react-credit-cards-2 library.
  • Deletion of Record using Power Shell Script with FetchXML Query in D365Mar 23, 2024. Deletion of Contact Record using Power Shell Script with FetchXML Query in D365
  • Advanced Django Admin Configuration for Quiz App InterfaceMar 22, 2024. This article provides a detailed guide on advanced customization techniques for optimizing the Django admin interface specifically for managing a quiz application. Through practical examples and step-by-step instructions, it demonstrates how to tailor ModelAdmin classes, configure list views, add filters, organize detail view layouts, and enable inline editing, empowering developers to create a user-friendly and efficient admin interface tailored to their project needs.
  • 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.
  • Azure DevOps: How to execute a Pipeline Task using ConditionsMar 22, 2024. Learn how to optimize your Azure DevOps pipelines with tips and tricks for executing tasks conditionally. Utilize conditions to control task execution based on variables, branch policies, and other criteria, streamlining your CI/CD processes for efficient deployment.
  • What Are EOAs and How to Create Ethereum Wallets Using C#?Mar 22, 2024. Discover how to harness the power of Ethereum with C# by learning about EOAs and creating secure wallets for transactions. Dive into the world of blockchain development now
  • Build an Approval-Based Automated Workflows Using Azure Logic AppsMar 21, 2024. Azure Logic Apps is a cloud-based service enabling automated workflows across various applications without coding. Learn to build approval-based workflows, integrating Outlook, approval emails, and Blob storage seamlessly.
  • Update a Contact record in Dynamics 365 (D365) using PowerShellMar 21, 2024. Update a Contact record in Dynamics 365 (D365) using PowerShell involves modifying existing contact information within the D365 environment programmatically. This process utilizes PowerShell scripting to interact with the Dynamics 365 API.
  • Establishing Communication Between Executable Files Using TCP/IPMar 19, 2024. WPF apps use various IPC methods like Named Pipes, WCF, TCP/IP Sockets. TCP/IP sockets offer cross-platform communication with advantages like reliability but face complexity and firewall issues. Steps include server/client development, execution instructions. Use CommonHelper for collaboration.
  • Exploring Inter-Process Communication in WPF Using Named PipesMar 19, 2024. In a WPF application, inter-process connectivity typically involves communication between different components or modules within the same application or between separate WPF applications running on the same system or across different systems.
  • How to Delete a Specific Email using Azure Logic AppMar 18, 2024. How to delete a specific Email using Azure Logic App
  • Creating Global Option Sets & Using Them Effectively in CRMMar 18, 2024. To create a Global Option Set in Dynamics 365, define a set of standardized values applicable across multiple entities. Then, reference this set when creating option set fields, ensuring consistent data entry and easier management across the CRM system.
  • Effective Communication Between Executable Files Using Shared MemoryMar 18, 2024. In a WPF (Windows Presentation Foundation) application, inter-process connectivity typically involves communication between different components or modules within the same application or between separate WPF applications running on the same system or across different systems.
  • How to Add Controls in AG-Grid In AngularMar 17, 2024. AG-Grid, a powerful library for Angular, allows easy integration of data grids. Follow these steps to set up, customize, and enhance AG-Grid in your Angular application.
  • React Apexcharts: Create & Download Column Bar Chart with BootstrapMar 16, 2024. In this tutorial, we will learn how to create a vertical column bar chart component in the React JS functional component. Creating a Column Bar Chart component in React using Apexcharts and Bootstrap. Configure data and options for visualization.
  • What is Use of ‘Using’ Statement in .NET?Mar 15, 2024. In this article, we will cover What is the use of the ‘Using’ statement in .NET. The 'using' statement in .NET ensures efficient resource management, prevents memory leaks, and promotes cleaner, more reliable code.
  • Display API Data on List Using SwiftUIMar 15, 2024. In this article, we will fetch and display data on a list using SwiftUI. Learn to fetch and display data in a list using SwiftUI. Set up a SwiftUI project in Xcode, create a struct conforming to Codable and Identifiable protocols, fetch data using URLSession, and design the UI.
  • Animated Credit Card Design Using AngularMar 15, 2024. To create an animated credit card form in Angular, adjust the app.module.ts file to include necessary modules and define component properties.
  • Sequence Classification Using Hugging Face Transformers LibraryMar 15, 2024. In the area of natural language processing (NLP), understanding sequence classification is key to unlocking the potential of machine learning models. The concept of sequence classification, particularly in the context of Hugging Face's Transformers library, catering to beginners in the field of AI and NLP.
  • 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.
  • Increasing Item Limit in Power Apps: A Step-by-Step Guide up to 2000Mar 12, 2024. In this article, we will learn to Unlock the full potential of Power Apps by increasing the item limit to 2000 with our comprehensive step-by-step guide. Learn how to efficiently manage data sources, optimize performance, and adhere to best practices for app development.
  • Dynamics 365 - Duplicate Detection with PowerAppsMar 11, 2024. This document outlines the process of detecting duplicate contacts in Dynamics 365 when generating a new contact. It explains how to set up a Blank Canvas App, establish a connection with a Dynamics 365 Data Source, and design a dialog screen for duplicate detection.
  • 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.
  • Difference Between .NET Framework, .NET Core, and .NET StandardMar 11, 2024. This article, delves into the distinctions between .NET Framework, .NET Core, and .NET Standard. Exploring their histories, open-source nature, cross-platform capabilities, and performance aspects, the article aims to provide a comprehensive overview for developers.
  • A Seamless Debugging Experience with Source Link in .NET 8Mar 11, 2024. Discover how to enhance your debugging experience in .NET 8 with Source Link, authored by Ziggy Rafiq. This article guides about the efficient use of Source Link for debugging, providing invaluable insights for software developers. With this authoritative resource, you can master the intricacies of debugging in .NET 8.
  • Save Email Attachment to Blob Storage using Azure Logic AppMar 11, 2024. In this article, we are going to learn about how to Save specific Email attachment to blob storage using Azure Logic App
  • Create & Download Area Chart using React Apexcharts with BootstrapMar 10, 2024. Create an Area chart component in a React.js functional component using Apexcharts and Bootstrap libraries. Explore Apexcharts' features, step-by-step implementation, and visualization of data.
  • Fetch Data From API Using URLSessionMar 09, 2024. This article contains simple demo on how to fetch data from API using URLSession in Swift Programming Language.
  • From Script to Screen in Seconds: OpenAI's Sora Reimagines Video CreationMar 09, 2024. OpenAI has unveiled a new tool called Sora that promises to shake up video creation. Imagine describing a scene and having it come to life as a video! This AI-powered tech could revolutionize everything from social media content to educational materials. Get ready.
  • Trigger a Journey when a record is updated using Plugin C# CodeMar 08, 2024. To trigger a journey when a record is updated using C# plugin code.
  • Tan function from Power Fx using Power AppsMar 08, 2024. Reading this article, you can learn how to perform Tan function from Power Fx using in Microsoft Power Apps. Also, you will be able to learn Button control, Label control and TextInput control in the Power Apps environment.
  • Creating Funnels Using Custom Events in Application InsightsMar 07, 2024. Learn to add custom events to a simple .NET application's telemetry and then use these events to create funnels that identify users who complete a specific sequence of steps in your application.
  • Generate QR Code with Text Around It Using ASP.NETMar 07, 2024. To generate a QR code with text around it using ASP.Net, leverage the QRCoder NuGet package. This code snippet demonstrates creating, customizing, and adding text to a QR code.
  • Performance Testing with K6 ToolMar 06, 2024. k6 is an open-source framework designed to simplify performance testing for developers. It leverages the Goja programming language, an implementation of ES2015 JavaScript on Golang. This allows developers to write performance testing scripts using JavaScript syntax compatible with ES2015 standards.
  • Data Migration Using Azure PipelinesMar 05, 2024. In this article, we will discuss how data can be imported from Source to Target environment using Azure Pipelines. Automate data migration in Microsoft's Power Platform using Power Platform Build Tools. Learn step-by-step with examples to create schema files and execute data export and import pipelines.
  • What is PWA & How to Implement It Using JavaScriptMar 05, 2024. A Progressive Web App (PWA) is a type of web application that offers a user experience like that of native mobile apps. PWAs leverage modern web technologies to provide features such as offline functionality, push notifications, and smooth performance, making them responsive, reliable, and engaging for users.
  • How Do I Open an OCR File in PDF?Mar 05, 2024. Explore methods to open OCR files in PDF. Get the best guides to open an OCR file in PDF with easy steps. Open OCR PDF files in C# using the iTextSharp library. Install iTextSharp, write C# code to extract text, and run the code for OCR PDF processing.
  • 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.
  • Product Management Application using .NET Core and React JS with CRUD OperationsMar 02, 2024. In this article, learn to create a product management web API with CRUD operations using .NET Core 6 and React JS. Utilize SQL Server for the backend and Axios for API consumption.
  • Creating Cascading Dropdowns Using Collections in PowerApps Mar 02, 2024. We will explore how to create cascading dropdowns using collections in PowerApps without relying on SharePoint lists. Follow the steps to set up and add data to collections, enabling dynamic user interfaces.
  • How to Open a PSD File Without PhotoshopMar 02, 2024. Explore methods to open a PSD File without Photoshop. Get the program to open a PDF file without Photoshop using C#.
  • MSAL for Vanilla JS SPA: Get JWT Access & ID TokensMar 01, 2024. This document provides an overview of Microsoft Authentication Library (MSAL) and its role in implementing secure authentication in Vanilla JavaScript Single Page Applications (SPAs). It discusses the significance of MSAL in obtaining JWT (JSON Web Token) Access Tokens and ID Tokens from Microsoft identity services.
  • Convert Text to Audio using Azure and .NET 8Mar 01, 2024. In this article, we will learn how to harness the power of Azure and .NET8 to seamlessly convert text into audio. Explore the integration of Azure Cognitive Services for text-to-speech functionality, leveraging the robust capabilities of.NET8 for efficient development.
  • Send Email with Multiple Attachments from SharePoint Library DocsFeb 29, 2024. Sending an email with attachments using Power Automate, specifically focusing on scenarios where files with their metadata are created in a SharePoint Library
  • How to Open, Read or View MS SQL Error Log FileFeb 29, 2024. Explore methods to open, read, or view SQL Server Error Log File. Get the best solution to open or view the SQL Server Log File of MS SQL Server in easy steps.
  • 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.
  • Apache Kafka Without ZooKeeperFeb 28, 2024. Apache Kafka Without ZooKeeper employs the KRaft protocol (KIP 500), replacing ZooKeeper for metadata management. This enables simplified deployment, enhanced reliability, and native support for Kafka's distributed consensus.
  • 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.
  • Customize Your Office Installer Using Office Deployment ToolsFeb 28, 2024. Customize your Microsoft Office installer effortlessly with Office Deployment Tools. Tailor settings, configurations, and deployment strategies to fit your organization's needs using command-line options and XML configuration for seamless setup.
  • Cherry-Pick and Stash for Efficient Development WorkflowsFeb 28, 2024. Excited to share SourceTree tips! Learn how to boost productivity with cherry-pick & stash features. Keep commits clean & manage work-in-progress seamlessly!
  • Enable Audit History Using Powershell in D365 Feb 28, 2024. In this article we will discuss in detail about audit tracking for entities and fields and how it can be enabled in more efficient manner.
  • Using Plugin.Maui.Popup to Create Eye-Catching Popups in AppsFeb 28, 2024. Learn how to utilize Plugin.Maui.Popup to incorporate popup functionality into your Xamarin.Forms application. Follow step-by-step instructions to install the package, create custom popup pages, and call popups from the code behind.
  • Composing Music in Javascript using Tone.jsFeb 27, 2024. In this article, we'll learn how to make music using a special tool called Tone.js, which works with JavaScript. We'll explore how to create beautiful tunes, melodies, and rhythms using this amazing library. So, let's dive in and discover how to compose music in a whole new way.
  • Creating Cohorts Using Custom Properties in Application InsightsFeb 27, 2024. In this article, we will learn how to leverage custom properties in Application Insights to create cohorts for in-depth user behavior analysis.
  • Vue.js Scoped Slots Unveiling Advanced TechniquesFeb 27, 2024. Vue.js, renowned for its flexibility and powerful features, introduces developers to the concept of scoped slots. Scoped slots provide a mechanism for a child component to expose data to its parent, offering unparalleled flexibility in rendering content.
  • How to Communicate from Child to Parent Using Events in Vue.jsFeb 27, 2024. In Vue.js, child components can communicate with parent components through custom events. Child components emit events using $emit, and parent components listen and respond accordingly, enabling dynamic interaction.
  • Using Variables in BicepFeb 27, 2024. Bicep is a domain-specific language (DSL) that is used for deploying Azure resources - learn more about it in this series of articles!
  • 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.
  • Advanced Use Cases of Vue Teleport for Dynamic Content RenderingFeb 26, 2024. Vue Teleport is a powerful feature in Vue.js that allows developers to dynamically move content within the DOM structure. In this article, we will explore four distinct examples showcasing the flexibility and creativity that Vue Teleport brings to Vue.js applications.
  • 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.
  • Angular URL/Site Validation using Regular Expression and Bootstrap with Reactive FormsFeb 26, 2024. Steps to add validation for URL using the regex pattern in the angular application. I will explain steps to create a form with text input using the reactive forms in angular. This input field will only accept the URL.
  • Learn about C# Operators and Their UsesFeb 26, 2024. This article on C# operators from unary and binary operators to overloadable operators, relational operators, implicit and explicit cast operators, short-circuiting operators, the ternary operator, null-conditional operators, "exclusive or" operators, default operators, assignment operators, and sizeof operator.
  • .NET Delegates in Event-Based Asynchronous Pattern for SeniorsFeb 26, 2024. This article dives into the practical learning of delegates, emphasizing real-world examples. It explores the Event-Based Asynchronous Pattern (EAP) in C# and its advantages, using delegates to implement asynchronous operations effectively.
  • Code Generation and Productivity in C#10 with Source GeneratorsFeb 24, 2024. Find out what C# 10 has to offer in Ziggy Rafiq's insightful article, "Code Generation and Productivity in C# 10 with Source Generators." Learn about the power of source generators, which streamline code generation during compilation, reducing redundancy and improving productivity. Discover how source generators offer improved performance, enhanced readability, and practical examples such as auto-implementing interfaces and serialization code generation. C# source generators help you create cleaner, more manageable codebases and will enhance your development workflow and efficiency. Ziggy Rafiq provides an in-depth overview of implementing source generators and demonstrates their versatility in creating cleaner, more manageable codebases.
  • Building an Interactive Chatbot with Prompt Engineering using ChatGPT, .NET Core, and AzureFeb 23, 2024. This article will talk about building an Interactive chatbot with Prompt Engineering using ChatGPT, .NET Core, and Azure.
  • .NET MAUI - Video Player using Community ToolkitFeb 22, 2024. .NET MAUI simplifies app development across devices, while the Community Toolkit enhances it. Dive into video integration for exciting apps! Follow setup steps, install the toolkit, and implement the Video Player control.
  • Using Azure OpenAI Service to Generate Images with DALL-E in .NETFeb 21, 2024. Tutorial to call Azure OpenAI Service DALL-E model to generate images in .NET. Learn how to call the Azure OpenAI Service DALL-E model in C#. Gather necessary data from Azure, deploy a model, and use the Azure OpenAI client library for .NET. Explore generative AI!
  • Enable Change Tracking Using Powershell in D365Feb 21, 2024. In this article we will discuss in detail about change tracking for entities and how it can be enabled in more efficient manner.
  • Azure DevOps: Create Organization, Project, Commit .NET SolutionFeb 20, 2024. Create Azure DevOps Organization & Azure DevOps Project, Commit .NET Solution Project into Azure DevOps. The article provides a detailed guide on establishing an Azure DevOps Organization, creating a project, and committing to a .NET Solution Project.
  • A Comprehensive Guide to Best Practices and Common Scenarios Using Dependency Injection in .NET 8 with C#10Feb 20, 2024. This comprehensive resource covers everything you need to know to leverage Dependency Injection effectively in .NET 8 with C# 10. Ziggy Rafiq explains how to use Dependency Injection in the best possible way. For developers looking to optimize their .NET projects, this guide provides invaluable insight from understanding core concepts to implementing advanced techniques.
  • Mobile Number Validation Using Angular and BootstrapFeb 19, 2024. This article illustrates the implementation steps for 10-digit mobile number validation in an Angular app using reactive forms and Angular's phone number validation pattern. It guides us through setting up the reactive forms module
  • Get Browser Type and Version Using Angular and BootstrapFeb 19, 2024. This article provides a detailed guide on how to detect the browser version and name in an Angular application. It covers steps to create a service for browser detection, configure browser name and version detection methods
  • Auto Detect Responsive Screen Sizes Using Angular and BootstrapFeb 19, 2024. This document provides a comprehensive guide on implementing screen size detection and achieving responsive behavior in Angular applications. It outlines steps to utilize the HostListener decorator for detecting changes in the window size, allowing for dynamic adjustment of screen dimensions.
  • Perform CRUD Operations using Azure DevOps Rest APIFeb 19, 2024. In this article we will discuss Azure DevOps REST API and perform CRUD operations on work items using PowerShell, including create, read, update, and delete.
  • How to Update Enhanced Rich Text Field using PowerShell CSOMFeb 18, 2024. The document explains updating the SharePoint multi-line text which is of enhanced rich text with html content.
  • Show/Hide Div on Click of Radio Button using Angular and BootstrapFeb 18, 2024. Steps to show and hide div by clicking on the Radio Button in the Angular application using the ngModel directive.
  • How to Send Approvals in Microsoft Teams Using Power Automate?Feb 18, 2024. Discover how to easily send approvals in Microsoft Teams using Power Automate. This article will walk you through the process, helping you automate tasks and improve teamwork efficiency. Say goodbye to manual approval hassles and hello to seamless workflow management!
  • How to Shorten URL using Custom Pipe in AngularFeb 17, 2024. In this article, We will learn steps to create a pipe that shortens a long URL and Link.
  • Telemetry in ASP.Net Core Web APIFeb 16, 2024. This article introduces the concept of telemetry in web APIs, focusing on its significance in performance monitoring and issue identification.
  • Android Intent using KotlinFeb 16, 2024. Here in this article, I going to pass data from one activity to another using intent and also able to send email using intent.
  • Android Responsive Login Screen Design using Constraint LayoutFeb 16, 2024. In this article, I going to explain how we can create a responsive Screen for different android Screens using Constraint Layout.
  • Using Azure Workbooks to Visualize Key Metrics for Your WebsiteFeb 14, 2024. Learn how to create a workbook to visualize the region of origin for your website's traffic using Azure Monitor Application Insights.
  • Exporting Custom OpenTelemetry Metrics to Azure Monitor using ASP.NET CoreFeb 14, 2024. Learn how to seamlessly export custom OpenTelemetry metrics from your ASP.NET Core applications to Azure Monitor. Enhance monitoring and observability by integrating with Azure's powerful toolset, leveraging the flexibility and insights provided by OpenTelemetry.
  • Exporting OpenTelemetry Traces to Azure Monitor using ASP.NET CoreFeb 14, 2024. Learn to seamlessly export OpenTelemetry traces from ASP.NET Core to Azure Monitor. Enhance monitoring and optimize performance with Azure's robust tools.
  • Azure Immersive Reader Technology - geting started!Feb 14, 2024. Using Azure Immersive Reader Technology to Help People Consume and Understand Text Based Information
  • Exporting OpenTelemetry Logs to Azure Monitor using ASP.NET CoreFeb 14, 2024. Discover how to seamlessly export OpenTelemetry logs from ASP.NET Core applications to Azure Monitor. Enhance monitoring and streamline log management with this integration, leveraging Azure's robust tools for greater insights.
  • How to Implement Approval in Teams Using Adaptive CardsFeb 13, 2024. This article introduces Adaptive Cards, versatile user interface components formatted in JSON, capable of seamless integration across various platforms. It delves into their significance in enabling lightweight UI exchange between applications and outlines.
  • Resolving Database Reconnection Challenges in .NET with PollyFeb 13, 2024. This content provides an overview and detailed implementation guide of utilizing the Polly library for connection retry in .NET applications. It demonstrates creating an Employee class and table, simulating temporary database disconnection.
  • Analyzing Image Moderation using Azure Content SafetyFeb 13, 2024. At the end of the article readers will able to understand and implement the usage of Content safety studio with moderating image contents in real time scenarios.
  • 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.
  • Master Advanced Angular Techniques for Skillful DevelopmentFeb 12, 2024. Explore advanced Angular techniques and elevate your development skills with this comprehensive guide. Delve into topics such as lazy loading modules, dynamic component creation, and advanced routing techniques, all accompanied by code examples for practical implementation.
  • Date and Time Column Behavior in SharePoint List/LibraryFeb 12, 2024. In this article, we will learn how managing date and time column conversions in applications becomes challenging when your organization spans multiple offices across different time zones.

About how-to-use-excel-advance-open-source-library-EPPlus

NA

OUR TRAINING