Home
Search results “Npoi style cell”
C# Excel Tutorial   #6 - Read Multiple Cells (Read Range)
 
07:32
Quick guide how to Read Multiple Excel Cells At Once in C# application you are making.
Views: 9167 Bospear
How to Apply Text and Background Color in Excel & Spreadsheet using EPPlus .NET C# [English] -PART 2
 
11:29
EPPLUS Library - Beginners Guide Part-2 ----------------------------------------------------------------- How to Apply Text and Background Color in Excel File or spreadsheet using EPPlus .NET Application [English] PART 2 ----------------------------------------------------------------------------------------------------------- Blog : https://everyday-be-coding.blogspot.in/p/epplus-library-part-2.html ------------------------------------------------------------------------------------------- Hindi Video link : https://youtu.be/gG92P6TULcg ------------------------------------------------------------------------------------------- How to apply cell text & background color in excel sheet? ------------------------------------------------------------------------------------------- Cell text color: ------------------------ In Epplus ExcelRange class has a style property. This style property is the type of ExcelStyle (seal) class. ExcelStyle class has another ExcelFont (seal class) type font properties. ExcelFont class has ExcelColor (seal class) type color property. ExcelColor has SetColor method. This method can accept Color structure object as a parameter. Example: -------------- ExcelRange Rng = new ExcelRange(); Rng.Style.Font.Color.SetColor(Color.Red); *By default EPPlus support black font color, if you are not specify any font color. Now next question in our mind, how to set cell background color? Example: -------------- Rng.Style.Fill.PatternType = ExcelFillStyle.Solid; Rng.Style.Fill.BackgroundColor.SetColor(Color.Green); Here SetColor method can support structure Color property as a parameter. You can also specify the HTML Color code. *By default Epplus support white background color. For Example: --------------------- Color DeepBlueHexCode = ColorTranslator.FromHtml("#254061"); Rng.Style.Fill.BackgroundColor.SetColor(DeepBlueHexCode); In this example FromHtml() directly accept HTML RGB (Red Green Blue) color Code. Source code: --------------------- using OfficeOpenXml; using System.IO; using System; //add two new namespace using OfficeOpenXml.Style; using System.Drawing; 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; } //First Border Box using (ExcelRange Rng = wsSheet1.Cells[5, 2, 8, 4]) { Rng.Value = "Text Color & Background Color"; Rng.Merge = true; Rng.Style.Font.Bold = true; Rng.Style.Font.Color.SetColor(Color.Red); Rng.Style.Fill.PatternType = ExcelFillStyle.Solid; Rng.Style.Fill.BackgroundColor.SetColor(Color.LightBlue); } 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 : https://www.facebook.com/Everyday-Be-Coding-297647894000991 ----------------------------------------------------------------------------------------------------------- Twitter : https://twitter.com/EverydayCoding ----------------------------------------------------------------------------------------------------------- Please subscribe my YouTude channel & don't forget to like, comments, share this video. Thanks and Regards Rajdip
Views: 1550 EVERYDAY BE CODING
How to Use Wrap Text and Merge Cells Formatting to Improve Look of Excel Worksheet
 
11:47
In my experience, many accountants and financial managers do not know how to take advantage of the many formatting commands available in Excel to improve the look and the efficiency of their spreadsheets. For example, instead of typing field labels on two or more rows, use the Wrap Text Command to keep the entire label in one cell. The second example that I demonstrate in this lesson is to merge the text from a single cell across multiple cells. This tip is really useful when you want to automatically widen a column to accomodate a longer text entry without "distorting" the entire worksheet! I invite you to visit my secure online shopping website - http://shop.thecompanyrocks.com - to view all of the resources that I offer you. Danny Rocks The Company Rocks
Views: 155511 Danny Rocks
How to Export DataSet or DataTable into Excel in C#
 
14:14
Step by step tutorial on how to export DataTable or DataSet into an Excel file in C#. You can use this method in any c# application like Windows Form Application, WPF, ASP.NET Application also. To use this method you need to have Microsoft Excel Application installed in your system.This method will make use of Excel Interop Assembly. You can export windows form datagridview or asp.net gridview to excel using this method. Discussed points : 1) How to create excel .xlsx file in c# from data or dataset 2) Format excel cells 3) Create multiple sheets Best C# Books from Amazon (Affiliate) : ➤ http://geni.us/O6o6pe Download Project From Git Hub : ➤ https://goo.gl/TgmCZh Buy me a Coffee (Channel Support By Donation) ➤ https://goo.gl/bPcyXW Subscribe to this channel ➤ https://goo.gl/RFY5C2 Popular Videos : Build Complete Asp.Net MVC App From Scratch using Datatable Plugin : https://goo.gl/yHZcCo All You need to know about jQuery Ajax in Asp.net MVC : https://goo.gl/ZXKqT9 Link to this video ➤ https://youtu.be/yX-JOqV_ZR0 Our Website ➤ http://www.codaffection.com ______________ ✪ Related Links ________________ https://goo.gl/FxwPXb : String Vs StringBuilder in C#. https://goo.gl/KeeYku : Code Execution Time in C#. ______________ ⌘ Social Media Links ________________ Blog : http://www.codaffection.com Facebook : https://www.facebook.com/codaffection Google plus : https://plus.google.com/+codaffection Twitter : https://twitter.com/codaffection Youtube : https://youtube.com/codaffection ______________ ↪ About this Channel ________________ CodAffection - for passionate programmers. This channel is all about teaching and inspiring developers to build applications/ websites in various technologies like Angular, NodeJS, Asp.Net MVC, JavaScript, SQL, React, Python etc. 2 Videos per Week - 12:30 PM UTC On MON and THU ______________ ₪ All Playlist ________________ https://goo.gl/gvjUJ7 : Asp.Net MVC https://goo.gl/ahk39S : Angular 5 https://goo.gl/viJcFs : Node JS https://goo.gl/itVayJ : Web API https://goo.gl/YJPPAH : MEAN Stack https://goo.gl/s1zJxo : C# Tutorial https://goo.gl/GXC2aJ : Asp.Net WebForm https://goo.gl/vHS9Hd : C# WinForm https://goo.gl/MLYS9e : MS SQL https://goo.gl/Ha71kq : Angular 4 https://goo.gl/5Vou7t : Crystal Report https://goo.gl/EPZ69B : Common C# Excercises https://goo.gl/qEWJCs : CG Exercises in C Program
Views: 28580 CodAffection
C# Excel Tutorial - #1 - Open and Read Excel Files
 
07:04
Quick guide how to open and read excel file through C# application you are making.
Views: 77611 Bospear
Java Apache POI Extract Text from Word Document
 
05:54
Learn how to extract text from word document using Java Apache POI.
Views: 3450 DevNami
Excel TextBox Auto Resize and Word Wrap
 
03:15
http://www.contextures.com/exceltextboxformat.html Use an Excel TextBox to add information on a worksheet, to help users get started. In Excel 2007, you can set the TextBox to resize automatically, if the text or text size is changed. In Excel 2010, the text wrapping can also be enable, when the resize is set to automatic. This video shows how to manually change the Excel 2010 settings, or use a macro to change all the text boxes.
Views: 19838 Contextures Inc.
How to resolve Excel found unreadable content
 
06:37
How to resolve excel found unreadable content. This is programming of Codeigniter. when you want to export data to excel with phpexcel. You see error like that.
Views: 48812 Unik dan Nyata
How to Read Excel File Java
 
02:20
In this video tutorial we will learn how to integrate Java with excel to read excel file in java. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Microsoft Excel can be integrated with other programming languages to build powerful software applications. Follow this easy step by step tutorial to learn how to read Excel file in Java by using a Java-Excel API Step 1 - Creating a new Java Project For that we have created a new java project in eclipse named "Open Excel File" and a class "ReadExcel" in the package reader. Step 2 - Downloading API To read excel file in java we need the Jxl library which does the I/O operation of the excel files. So, to download that API, let's open up www.sourceforge.net/projects/jexcelapi/files/jexcelapi/2.6.12 On that page, click on jexcelapi and download it. Step 3 - Importing the Library Now the next step is to import the library to our project. For that, go to eclipse, move over file and click on Import. Step 4 - Giving Import Source Select the File System directory here and click on next. Step 5 - Giving the Library Path Now let us locate the JXL library which we have just downloaded After locating the file, we have to select the jxl.jar file. Step 6 - Inserting Library into the project After that done, we have to browse and select our project where we want to import the library. Step 7 - Finalizing the import With all that taken care of, we just have to click on Finish. After that we can see the JXL.jar in our project explorer. Step 8 - Adding in build Path After that we have to Right click on the library icon, hover over to build path and Click on the Add to build Path option. Step 9 - Code Now let's go through the code. First we open the file using file descriptor FILE. Then we create a workbook object to access the excel file. The getSheet method allows us to access the sheet of the workbook. The getColumn and getRows method returns the column and rows of the file and the getContent method returns the content of the file. Step 10 - Inside Main Let us move on to Main. We are creating an object test of our class. In the setInputFile method, we have to give the path of the excel file we want to read. As written here our excel file is in the E drive named excel.xls. In this file, we have some labels written. Step 11 - Debug So now, let's run the program. After running the code, we will get the contents of the file in console. And this is how we can read excel file in java.
Reading Large Excel Files using the Open XML SDK
 
05:58
Learn how to use the Open XML SDK to read very large Excel files. The Open XML SDK provides two approaches for parsing Open XML files: 1. using the SDK DOM, 2. using the SAX-like reading/writing capabilities. We'll compare the two approaches. Source code for the project can be found here: http://zeyadrajabi.members.winisp.net/sourcecode/ReadLargeExcelFiles.zip
Views: 10602 Zeyad Rajabi
how to create [Report] using MS word Template with C#
 
16:07
Reporting using word and C# : Attachements : https://mega.nz/#!mgMREajS!tDhCdHdGIetVS06GvC9bm-jlLJAPpczDCxUXvS7uJf4 Advice : - if the form is started , make sure that the word file is closed
Views: 64482 SMPS TV