![]() Apply a named range for current worksheet ( "HeaderAndData", worksheet1.Range( "A1:B4")) Apply a named range for workshhet1, this named range can't be used in worksheet2 Apply a named range for workbook var header = ( "Header", worksheet1.Range( "A1:B1")) worksheet2.Cell( "A3").Value = worksheet1.Range( "HeaderAndData") įull code for applying a Excel named range in C# var workbook = new Workbook() Here worksheet1 get range with defined names "HeaderAndData", and then copy this range to worksheet2. ![]() worksheet2.Cell( "A1").Formula = "AVERAGE(FruitPrice)" Here worksheet2 use the named range "FruitPrice" (which is created in worksheet1 with workbook level). worksheet1.Range( "A2:A4").AddToNamed( "FruitName", Scope.Worksheet) ( "HeaderAndData"). = 20 Ĭreate from AddToNamed() method in the Worksheet.Range object. worksheet1.Range( "B2:B4").AddToNamed( "FruitPrice", Scope.Workbook) Ĭreate a named range in worksheet level, this named range can be only used in current worksheet.Ĭreate from NamedRanges object in the Worksheet. BackgroundColor = ExcelColor.Red Ĭreate from AddToNamed() method in the Worksheet.Range object. var header = ( "Header", worksheet1.Range( "A1:B1")) Var worksheet2 = ( "Sheet2") Ĭreate a named range in workbook level, this named range can be used in all the worksheets.Ĭreate from NamedRanges object in the Workbook. ![]() Before working on Named Rangeįirst, we need create two worksheet in Excel, and fill some data to sheet 1. This C# tutorial shows how to apply named range in Excel. How to Create Named Range to Spreadsheet in C# language Using named ranges can make things easier. How to Define and Use Named Range to Excel in C#.NET CodeĪ named range is one or more cells that have been given a name in spreadseet.
0 Comments
Leave a Reply. |