C# Corner

Resources  
  • What Is New In .NET Framework 4.7.1Nov 20, 2017. Learn about the key features available in .NET Framework 4.7.1.
  • Introducing Visual Studio Live ShareNov 18, 2017. With Visual Studio Live Share you and your teammates use the same debugging session. You can collaboratively step through code or set breakpoints which are reflected in your teammate’s editor in real time. Each of you can independently inspect objects, use features like tips on hover, locals and watches, or make changes to an object’s value. When you are ready to make a fix, simply edit the code and your teammates will see your edits in their editor.
  • How to Return Files From Web APINov 18, 2017. This article explains how to transfer/ return files(PDF/Doc/Excel/zip) files from Web API service
  • Two Way Data Binding In Angular Without $scope Object Using MVCNov 16, 2017. Data binding is the most useful and powerful feature among any of the existing or upcoming software development technologies. It is actually a process that bridges a connection between the view and business logic of the application.Basically we will see one-way and two-way data binding with respect to AngularJS applications. But before we jump to that section we will try to learn something about the scopes in AngularJS.
  • Monitoring S3 With Events And SNSNov 16, 2017. This is Muhammad Habib Jawady in a new DevOps hands-on tutorial. In my first Amazon Web Services tutorial, I will be showing you how to leverage the S3 events feature and Simple Notification Service In order to monitor actions taken on certain assets .
  • Span in C# 7.2Nov 15, 2017. Span is a new feature announced in C# 7.2.
  • Comment Or Reply To A Post In SharePoint Using AngularNov 15, 2017. Nowadays commenting or replying to a post is the most common thing in all social networks. Hence, in this article I am going to explain how it works in SharePoint using AngularJS. By the help of this article you will learn how to set comment or reply feature to a post in SharePoint using AngularJS.
  • How To Lock Objects In Power BINov 11, 2017. Sometimes, there is a situation where when we open a report and click on any visuals, it accidentally nudges a chart a little bit to the right or left. Sometimes, by mistake when end user viewing a report, arrangement of visuals scatters little bit. Microsoft rolls out one new amazing feature to resolve this issue and that is Lock Objects in Power BI.
  • Introduction Of New Useful Features In SSMS 2016Nov 10, 2017. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work and are more convenient to use the SSMS.
  • Masking Sensitive Data With SQL Server 2016Nov 10, 2017. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.
  • Working With View Components In ASP.NET Core MVCNov 09, 2017. View component is newly introduced feature in asp.net core MVC. It is very similar to partial view but it very powerful compared to partial view. It does not use model binding but works only with the data we provide when calling into it.
  • Power BI And Excel File As Data SourceNov 06, 2017. Though we have several options for data sources to connect with Power BI in this blog, I am going to write about how we can use Excel data with Power BI and how to refresh the report when Excel data is changed.
  • MS Visual Studio Code - Guide To GitNov 06, 2017. Hello guys again, this is Muhammad Habib Jawady and today I will be showing you how to use MS visual Studio Code in order to work with git properly. This will be a hands on tutorial, I hope you will find this useful as the number of users of ‘Code’ has grown dramatically throughout the year and the need for a full tutorial on how to use it has became an urge to help people master its enormous number of features.
  • Introduction To Bing Search API In AzureNov 05, 2017. Bing Search API adds intelligent search to your app and also it contains billions of web pages, videos, images. The best feature is that the results can be automatically customized to your user’s locations or markets.
  • How To Connect The Outlook Mail To Excel With Microsoft FlowOct 31, 2017. This article helps you to learn how to create a Flow between the Outlook Mail and Excel Spreadsheet.
  • SystemDataPaths In UWP (Windows 10 Fall Creators Update Features)Oct 31, 2017. This article explains about how to get system , app , user based path information. This SystemDataPaths, UserDataPaths, AppDataPaths class will be supported on Windows 10 Fall creators updated version build or greater and Windows 10 SDK 16999.
  • New Features Of .NET Core MVCOct 30, 2017. By releasing ASP.NET Core, Microsoft has joined a big community of free, open source and platform independent software services.
  • Part 1 Azure Red Shirt Dev Tour NYC 2017Oct 29, 2017. Introduction to Azure, overview, and cool features
  • Power BI New Feature - Bookmarks Pane In Power BI (Preview Feature)Oct 27, 2017. Microsoft recently added one interesting feature in Power BI - the Bookmarks Pane. This is an amazing preview feature rolled out by Microsoft during this October update. In this article, we will learn about Bookmarks Pane in Power BI.
  • How To Read CSV File In ASP.NET With Example C# and VB.NETOct 26, 2017. In this articleI'll explain a way to upload, read/browse and show CSV file (Text File) information in ASP.Net GridView using C# and VB.Net.
  • New Power BI Feature - Selection Pane In Power BI (Preview Feature)Oct 26, 2017. Microsoft recently added one interesting feature in Power BI, i.e., Selection Pane. In this article, we will elaborate its features in a deep manner.
  • User Story In Agile ScrumOct 24, 2017. In this article, we will learn what User Story is and how to write one. User Story plays a major role here. It is the part of the agile process where instead of writing comprehensive requirements, we write a short description of a feature.
  • Amazing Modern SharePoint Admin Center To Try Right NowOct 24, 2017. You’ll learn updated features to the SharePoint Modern admin center in office 365 and how we can navigate from the old admin center.
  • Missing 'Manage Delegates' Option In PWA Setting In Project Server 2016Oct 23, 2017. In this article, we will be fixing the issue Missing 'Manage Delegates' option in PWA Setting.
  • What's New In Microsoft .NET Framework 4.7.1Oct 20, 2017. In this article I will be discussing the new features introduced as part of the .NET Framework 4.7.1 release
  • Find And Replace Text In Word Document Using C#Oct 18, 2017. On Microsoft Word, we can find special text strings and replace them with new text strings easily. We can replace all the searched text automatically at one time and we can also only replace some of them from the searched results. This article will mention various approaches of the finding and replacing feature on the word document by using a .NET API Spire.Doc independently (without using any third-party code) as below.
  • ASP.NET Core 2.0 Response CompressionOct 16, 2017. When you’re unable to use the compression features of web servers (IIS, Apache, Nginx), ASP.NET Core provides an alternate option, Response Compression middleware. It’s performance won’t match server based compression features though.
  • C# 7.0 And C# 7.1 New Features - Part TwoOct 16, 2017. This article explains the new features of C# 7.0 & C#7.1. It covers new features like Discards, Pattern Matching, Generalized async return types, Async Main (Main Method returning Task), Infer Tuple Element Names, Default Literal Expressions & Type Inference and Pattern Matching with Generics.
  • C# 7.2 New Features With Visual Studio 2017Oct 16, 2017. This article explains the new features of C# 7.2. It covers ‘ref readonly’, ‘private protected’ access modifier, Digit Separator After Base Specifier (Leading Digit Separator) and Non-trailing named arguments.
  • Running Business Rule Only On Record CreateOct 16, 2017. We know that business rules are executed on form load and on change of the associated field, which means if we have business rule for any entity it will fire for new record as well for existing records when form loads.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.
  • User-Defined Types In SQL ServerOct 13, 2017. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Read Excel File In C# WinFormOct 13, 2017. Here we are going to learn to read Excel files in C# windows form applications.
  • Getting Started With SharePoint Framework For SharePoint 2016 On-PremisesOct 12, 2017. Once you have installed and upgraded the September 2017 Public Update for SharePoint 2016, you will be able to upload and deploy SharePoint Framework packages that contain web parts via the SharePoint App Catalog just as you would with SharePoint Add-ins.
  • Learn Universal Windows Programming Via Modern C++ (CommandBar Control)Oct 11, 2017. In this article, we are going to learn about CommandBar control in Modern C++. The CommandBar control is a new control in Universal windows programming, it’s a like a Toolbar control, it has more features compared to Toolbar control.
  • SharePoint 2016 - December 2016 CU Issue FixedOct 11, 2017. In this article, we will list all the issues of SharePoint 2016 that are fixed in the December 2016 CU. This month, MSFT released two packages and we should install both.
  • Cloud Databases In Azure - Part OneOct 11, 2017. In my previous articles on Azure, I have explained about the IaaS features of Azure i.e. creating Virtual Machines, databases etc. In this article, we will see the Introduction of Cloud Databases i.e. PaaS side of Microsoft Azure.
  • Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
  • Understanding Face API In AzureOct 11, 2017. Add facial recognition capabilities to your app with the Face API. State-of-the-art algorithms detect human faces in images, opening a range of facial capabilities to your apps. Face detection can also identify attributes, including face landmarks (nose, eyes, etc.), gender, age, and other machine-predicted facial features.
  • How To Use Ratings In Lists And Libraries Using Rating Settings, Server Side Coding And PowerShell CommandsOct 09, 2017. In this article I will discuss how to make use of ratings with your lists & libraries. Ratings are the features introduced by Microsoft which allow users to evaluate & rate the authors. Here I will explain how to use ratings on the lists & libraries.
  • SharePoint 2016 - November 2016 CU Issue FixedOct 09, 2017. In this article, we will list all the issues of SharePoint 2016 that are fixed in the November 2016 CU. This month, MSFT released two packages and we should install both.
  • Sending Bot Reply Message With Attachment Using Bot FrameworkOct 07, 2017. The Bot Framework enables you to build bots that support different types of interactions with users. You can design conversations in your bot to be freeform. Your bot can also have more guided interactions where it provides the user choices or actions. The conversation can use simple text strings, the message with an attachment like the image, File (pdf, word, excel, ppt), mp3, Video or more complex rich cards.
  • SharePoint OnPremises - Client Side File Upload Control And Uploading File In SharePoint Using Rest APIOct 06, 2017. In one of our SharePoint OnPremises projects, we have requirement to upload the user’s photo, his profile image in SharePoint Image library (PublishingImages). So we have implemented this feature using JavaScript and upload image in SharePoint Image library using rest API.
  • Change Site Collection URL, Title, Logo In SharePoint 2013 Using PowerShell Commands, Back Up And Restore OptionOct 05, 2017. In this article I have discussed about how to change the site collection URL, title & logo in SharePoint 2013. Suppose in your company you have already created your site collection & customized everything but later your company decided to change the Site URL & title as well.
  • Create Power BI Report Using Twitter AnalyticsOct 04, 2017. In this article, we will learn how we can use Twitter analytics data and prepare Power BI Report. We can export Twitter analytics data in .csv format and consume that .csv file to prepare a Power BI report.
  • New Power BI Feature - Drill Through Filter In Power BIOct 04, 2017. Drill through feature was introduced recently, in the September update. It’s a most useful filter. Sometimes there is a situation in which we want to redirect our one report page to another report page. This filter made our work much easier.
  • Export Active Users (Licensed Users) In .CSV Format From Office 365 Using PowerShellOct 04, 2017. Sometimes, there is a situation in which we need to connect our PowerShell with Office 365. We have received a requirement from one of our clients, they want csv for all licensed users available in Office 365.
  • ColorPicker Control In UWP (Windows 10 Fall Creators Update Features)Oct 04, 2017. This article explains how to implement ColorPicker control in UWP application. A ColorPicker control is a new control in UWP programming
  • Azure Deployment Details And LogsOct 03, 2017. I am working on Microsoft Azure services from last 3-4 years. I always like to work on cloud platform provided by Microsoft. Microsoft always comes up with new services, features with their products. I have observed one thing with Azure that creating any resources or creating design is not big deal. There are lots of technical material and forums provided by Microsoft. Most challenging thing with azure is troubleshoot any issue till you actual route cause.
  • Read Data From Excel With Preview In ASP.NET MVC Using AngularOct 03, 2017. In this article we will see how to Read data from excel and show preview and after we can update to database with Asp.net Mvc using Angular.
  • How To Start VM Automatically In AzureSep 29, 2017. Virtual Machines provides flexibility to install and configure anything, any time and use it as you want. As well as all these features, VMs are costly so developers or managers of VMs needs to make the cost effective, for this Azure provides Automation Scripting to start and stop a VM automatically so that it will be cost effective besides it is flexible.
  • SharePoint 2013 - Converting GMT/UTC Time To Local Time In XSLT For Rendering RSS Feed ResultsSep 29, 2017. Recently, I came across the requirement where the date coming from RSS feed which is in GMT format needed to be converted to local time and displayed in the required format.
  • SharePoint 2016/2013 - Event Log Monitoring By PowerShell AutomationSep 27, 2017. This article is based on the requirement I recently encountered where I was required to monitor a specific exception type and if it occurred the Admins needed to be notified at the same time.
  • SharePoint 2016/2013 - Exploring Client Side People Picker ControlSep 26, 2017. In this demo, I will be discussing the implementation details of the Client Side People Picker Control in Production Scenarios.
  • Features Of AngularSep 24, 2017. AngularJS is an incredible JavaScript system that has some extremely convincing highlights for engineers, as well as designers too! In this section/ exercise, we will cover what I consider to be the most fundamental highlights, and how they can help make your next web application wonderful.
  • Power Of Slicer In Power BISep 23, 2017. In this article, we will learn how we can use slicer in Power BI. Power BI provides an OOTB slicer. By using slicer, we can achieve so many things. It has lots of hidden features.
  • What Is New In Visual Studio 2017Sep 22, 2017. Learn What Is New In Visual Studio 2017
  • Basic PDF Export Using JQuery In ASP.NET MVC RazorSep 21, 2017. Here i will show you after insert records how to export the record in pdf format using jquery.
  • What Is New In iOS 11?Sep 19, 2017. iOS 11 sets a new standard for the world’s most advanced mobile operating system. Your apps can now become more intelligent using the power of machine learning with Core ML. You can create incredible augmented reality experiences with ARKit. And you can deliver a more unified and immersive user experience with new multitasking features, including drag and drop for iPad, the new Files app, new camera APIs, new SiriKit domains, Apple Music integration, and more
  • Missing Security Section In PWA Settings In Project Server 2016Sep 18, 2017. In this article, we will discuss and solve the issue of Missing Security Setting in PWA Settings in Project Server 2016 / 2013.
  • Introduction To Tag Helpers In ASP.NET CoreSep 18, 2017. Tag helper is a new feature in ASP.net MVC. It enables server-side code to create and render HTML elements in Razor View. It is feature of Razor View engine. They are the C# classes which participate in view generation by creating the HTML elements. Using the tag helper, we can change the content of HTML element and add additional attributes to the HTML element. It is very similar to HTML helper in ASP.net MVC.
  • Start The App In Windows Startup In UWP (Windows 10 Fall Creators Update Features)Sep 17, 2017. A long-awaited feature (other features are LaunchApp, Restart App) has come to Universal Windows Programming i.e. we can run our application on Windows startup (User log in to the system), Previously we had done some workaround to run the app in windows startup, now it's time to say good bye to the workaround.
  • Razor Pages In ASP.NET CoreSep 17, 2017. Razor Pages is a new feature of ASP.Net Core MVC. We can use this approach when there are some page focused scenarios.
  • SharePoint Permission Mode Vs Project Permission Mode In Project Server 2016 / 2013Sep 14, 2017. In this article, we will discuss the Permission Modes in Project Server 2016 / 2013.
  • GitHub Extension In Visual Studio 2017Sep 13, 2017. In this article, I will explore the GitHub Extension for Visual Studio 2017. GitHub is a web-based graphical interface Git or version control repository that mostly used for code. It provides for each project access control and several collaboration features like bug tracking, feature requests, task management, and wikis.
  • Update Managed Metadata Field Using SharePoint Designer 2013 WorkflowSep 12, 2017. In this article, I am going to explain how we can update a managed metadata field using SharePoint 2013 Designer Workflow. This solution will work for both SharePoint 2013 On-Premise and SharePoint Online (Office 365). I tested the below solution in Office 365 environment.
  • SharePoint 2013 - On Premises - Powershell Script To Import Termsets On Given Site From .csv File In Specific FolderSep 10, 2017. In this article I’ll explain how to import multiple termsets using .CSV file from one specific folder.
  • Introduction To Translator Speech API - Microsoft Cognitive ServicesSep 09, 2017. In my previous article on Microsoft Azure Cognitive Services, we saw how to register for Microsoft Cognitive Services and how we can use Face and Emotional API’s. In this article, we will see how we can use Translator Speech API and what its features are.
  • SharePoint 2016/2013/Online - Sites Health Monitoring By PowerShell AutomationSep 08, 2017. In this article, we will discuss a simple yet powerful automation technique using PowerShell that will try pinging the Site and if it fails, it will send the email notifications to the designated SharePoint Admins for the Site.
  • Get Office 365 Data In Excel Using MS Graph APISep 08, 2017. In this article, I will show how you can quickly fetch Office 365 data of your organization in MS Excel using Microsoft Graph API.
  • New Features In ASP.NET Core 2.0Sep 07, 2017. ASP.NET core is a significant redesign of ASP.NET. It is an open source, cross platform framework for developing cloud based applications like web applications, IoT applications, and mobile backend applications.
  • Launch UWP App Via CommandLine ( Windows 10 Fall Creators Update Features )Sep 07, 2017. We can launch Win32 application via command line arguments. Let's see how to implement this feature into our UWP application.
  • ASP.NET Core 2.0 Empty ProjectSep 06, 2017. In this article, we will create an empty ASP.NET Core project that doesn’t include default features, i.e., an empty shell.
  • Advantages Of SharePoint 2016 From A User PerspectiveSep 06, 2017. You might have seen many articles/blogs on the internet about new and deprecated features of SharePoint 2016 or about the comparison between SharePoint 2013 and 2016. However, this article is mainly focused on the new changes introduced in SharePoint 2016, which will help the end users or business users in their day-to-day SharePoint usage.
  • Restart An App Programmatically In UWP (Windows 10 Fall Creators Update Features)Sep 06, 2017. This article explains about how to restart an app programmatically in Universal Windows Programming.
  • SharePoint 2016/2013/Online - How To Upload Files To SharePoint Document Libraries By PowerShell AutomationSep 02, 2017. In this demo we will explore the PowerShell code to upload the file to SharePoint Online/On Premise Implementations which represents just a part of the complete automation process.
  • SharePoint 2016/2013/Online - How Download SharePoint List Item AttachmentsSep 02, 2017. In this article we will explore the PowerShell to download the List Item attachments.
  • Learn About Azure Cognitive ServicesSep 01, 2017. Microsoft Cognitive Services (earlier known as Project Oxford) provides us the ability to build intelligent applications, just by writing a few lines of code. These applications or services are deployed on major platforms like Windows, iOS, and Android. All the APIs are based on machine learning APIs and enable developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications.
  • Custom Left Navigation In SharePoint 2013Sep 01, 2017. In this article, I explore how to create a custom left navigation using Out of Box, without custom development. As we know that there are a lot of ways of creating left navigation, here you will see a new approach for creating a custom left navigation in SharePoint 2013.
  • Extend Built In Label Tag Helper In ASP.NET Core ApplicationAug 31, 2017. Tag helpers is one of the new feature introduced in ASP.NET Core which allows us to add server side code while creating and rendering HTML elements. They are similar to HTML helpers in ASP.NET MVC. ASP.NET Core comes with various built in tag helpers for rendering HTML elements like label, input, img, select etc.
  • IoT Remote Access Pi Login Using Raspberry PI 3 Model BAug 29, 2017. This is an introduction of Raspberry Pi 3 Model B. We will explore what Raspberry Pi 3 has to offer in terms of its features and performance.
  • Manage Features On Web Applications In SharePoint 2016 Central AdministrationAug 28, 2017. These features, when activated or deactivated on the Web Application, will reflect on all the site collections and sites.
  • More Details About Razor Pages In ASP.NET Core 2.0Aug 27, 2017. I built a simple web app to show you the new feature named Razor Pages in ASP.NET Core 2.0 . However it doesn't contain some useful and basic functions. So I decided to write one more article to show more details of Razor Pages.
  • New Features In SQL Server 2017Aug 27, 2017. There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new features in SQL server 2017.
  • JasperReports - Basic IntroductionAug 26, 2017. JasperReports is an open source software which is widely used for creating PDFs. It is not limited to creating PDFs but one can also export any desirable formats such PNG, CSV, Excel, Word doc, and HTML etc.
  • Expected New Features In C# 8Aug 25, 2017. C# 8, C#, C# 8.0
  • What's New In Android OreoAug 24, 2017. Android 8.0 Oreo was officially released on August 21, 2017. In this article, I am going to discuss some of the new features of Android 8.0.
  • Create Office Web Add-In Project Using Visual StudioAug 24, 2017. In this article, I would like to share the steps to create Office web add-in projects using Visual Studio. In this article, we have explored what Office add-ins are and how to create Office web add-in projects using Visual Studio 2015.
  • Virtual Machine Scale SetAug 23, 2017. Virtual Machines are highly flexible such that they can be changed in their size and the performance based on the requirement of the user. The resources which we actually require can be decided by us and then the user can be able to scale up or down the Virtual Machine. When making changes to the Virtual Machine size, the cost that is charged for the Virtual Machine will also vary. Here the size of the Virtual Machine will include the number of cores, the Random-Access Memory, number of data disks, the IOPS range, SSD size, load balancing feature and premium disk support.
  • How To Use Microsoft Graph Provider In Visual Studio Connected ServicesAug 22, 2017. In this article, I am introducing the newly added Microsoft Graph Provider in Visual Studio 15.3.1. This article demonstrates how a developer can use this feature to work with Microsoft Graph API.
  • Remove U+200B (Zero-Width Space) In RichTextHTML Field SharePointAug 22, 2017. In this article, we will explore how to resolve the error that arrives while implementing the validation to enhanced/rich text box of SharePoint 2013 using jQuery. We will call this error the “Zero-width space” issue.
  • Areas In ASP.NET Core MVCAug 20, 2017. Area is a beautiful feature of ASP.net MVC that allows you to organize related functionality into a group. We can create a hierarchy for the physical grouping of the functionality or business component.
  • Reading An Excel File Using HTML 5 And jQueryAug 18, 2017. This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.
  • Setup And Start The SharePoint 2013 User Profile ServiceAug 17, 2017. In this article, you will learn how to setup and start the SharePoint 2013 User Profile Service.
  • SharePoint 2016/2013 - How To Install SharePoint Client Components SDKAug 12, 2017. In this article, we will look for another necessary component that is required when preparing client machines for CSOM based PowerShell Development.
  • SharePoint 2016/2013/Online - How To Download SharePoint Files By PowerShell AutomationAug 12, 2017. In this article, we will explore the PowerShell way of downloading the files in SharePoint Document Libraries.
  • Key Capabilities Of Azure Cosmos DBAug 12, 2017. A few years ago, Microsoft offered DocumentDB as a Service (DaaS) that supported a limited set of features and functionalities. Today, most of the cloud-based services, such as Bing, Azure, and Office 365 are using DocumentDB. Microsoft took DocumentDB to the next level and came up with Azure Cosmos DB - A globally distributed, multi-model database.
  • Join Two Lists Using REST In SharePoint 2013Aug 11, 2017. In this article, we are going to discuss how to join two lists in SharePoint 2013 using REST.
  • Boosting Up The Reflection Performance In C#Aug 10, 2017. Reflection is a way of obtaining metadata information about the types used in applications, which helps you describing the types, modules or assemblies at runtime. This is an extremely useful feature in the strongly-typed languages like C#.
  • Creating Login Form With Authentication For User Login Using C#Aug 09, 2017. This article describes how to create a login form and to validate user login with additional feature like changing pictures according to the type of user

About Export-feature-in-Excel-2013

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!