How to Create Excel Spreadsheet File using EPPlus .NET Library (C#) Hindi - PART 1
#EPPlus #ExcelSpreadsheet #DotNet #CSharp #ExcelAutomation #Programming #CodingTutorial #SpreadsheetDevelopment #ExcelFile #Developer #ExcelTips #NETLibrary #LearnProgramming #CodeWithCSharp #SoftwareDevelopment #ExcelTutorial #EPPlusLibrary #TechTutorial #ExcelVBA #OfficeAutomation #EverydayBeCoding
EPPLUS Library - beginners Guide Part - 1
--------------------------------------------------------------------
Epplus library download link : http://epplus.codeplex.com/
-----------------------------------------------------------------------------------------------
English video link : • How to Create Excel Spreadsheet File ...
-----------------------------------------------------------------------------------------------
Blog Link : https://everyday-be-coding.blogspot.c...
------------------------------------------------------------------------------------------------
How to create Excel file (Development) using Epplus .NET Library (C#) [Hindi] - PART 1
------------------------------------------------------------------------------------------------
What is EPPlus?
--------------------------
A library to manage excel spreadsheets. EPPlus is a .NET library that reads and writes Excel 2007/2010 or higher files using the Open Office Xml format. It is support .xlsx, .xlsm excel file format.
Why we are using EPPlus?
-------------------------------------------
1) First of all EPPlus is a free tool.
2) We can do same thing by using Microsoft interop excel. When you are like to doing server side office automation. That is not a supported scenario by Microsoft. Follow this link : http://support.microsoft.com/kb/257757
How to attach EPPlus Library :
-----------------------------------------------------
Option 1 : Download it from : http://epplus.codeplex.com/
Option 2 : To install EPPlus, run the following command in the Package Manager Console
= Install-Package EPPlus
EPPlus Supports :
-----------------------------
Cell Ranges
Cell styling (Border, Color, Fill, Font, Number, Alignments)
Charts
Pictures
Shapes
Comments
Tables
Protection
Encryption
Pivot tables
Data validation
Conditional formatting
VBA
Formula calculation..etc
Today we are learning :
Create a demo an epplus project using .NET technologies (Language C#)
Open Visual Studio (Create a console application) :
----------------------------------------------------------------------------------
using OfficeOpenXml;
using System.IO;
using System;
//add these namespace
class Program
{
static void Main(string[] args)
{
ExcelPackage ExcelPkg = new ExcelPackage();
ExcelWorksheet wsSheet1 = ExcelPkg.Workbook.Worksheets.Add("Sheet1");
using (ExcelRange Rng = wsSheet1.Cells[2, 2, 2, 2])
{
Rng.Value = "Welcome to Everyday be coding - tutorials for beginners";
Rng.Style.Font.Size = 16;
Rng.Style.Font.Bold = true;
Rng.Style.Font.Italic = true;
}
wsSheet1.Protection.IsProtected = false;
wsSheet1.Protection.AllowSelectLockedCells = false;
ExcelPkg.SaveAs(new FileInfo(@"D:\New.xlsx"));
}
}
Now execute this code and see a new file ("New.xlsx") is created on D: drive.
-----------------------------------------------------------------------------------------------------------
Blog : https://everyday-be-coding.blogspot.in/
-----------------------------------------------------------------------------------------------------------
Facebook : / everyday-be-coding-297647894000991
-----------------------------------------------------------------------------------------------------------
Twitter : / everydaycoding
-----------------------------------------------------------------------------------------------------------
#EverydayBeCoding
Please subscribe my YouTude channel & don't forget to like, comments, share this video.