![gembox excel pivot gembox excel pivot](https://www.dummies.com/wp-content/uploads/Refresh.jpg)
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. ( "HeaderAndData", worksheet1.Range( "A1:B4")) 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.
#Gembox excel pivot how to
This C# tutorial shows how to apply named range in Excel.
![gembox excel pivot gembox excel pivot](https://markstownsend.com/assets/images/summarystatistics.jpg)
How to Create Named Range to Spreadsheet in C# language
![gembox excel pivot gembox excel pivot](https://www.gemboxsoftware.com/spreadsheet/examples/6007/content/ReadSpreadsheet.png)
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.