Skip to content

Multiple Ranges

Francois Botha edited this page Feb 26, 2018 · 2 revisions

Handling Multiple Ranges

MultipleRanges.jpg

var workbook = new XLWorkbook();
var ws = workbook.Worksheets.Add("Multiple Ranges");

// using multiple string range definitions
ws.Ranges("A1:B2,C3:D4,E5:F6").Style.Fill.BackgroundColor = XLColor.Red;

// using a single string separated by commas
ws.Ranges("A5:B6,E1:F2").Style.Fill.BackgroundColor = XLColor.Orange;

workbook.SaveAs("MultipleRanges.xlsx");

FAQ

Examples

Real world scenarios

Time Savers

Performance and Memory

Misc

Inserting Data/Tables

Styles

Ranges

Rows

Columns

Page Setup (Print Options)

AutoFilters

Comments

Dev docs

Clone this wiki locally