Finally got working a more natural way to deal with collections of rows/columns/ranges ...

Old Method (You have to iterate through every item):
ws2.Columns("G:H").ForEach(c => c.Style.Fill.BackgroundColor = Color.Blue);

New Method (No iteration necessary, the program knows you want to apply the style/whatever to the entire collection):
ws2.Columns("G:H").Style.Fill.BackgroundColor = Color.Blue;

Right now it only works with columns but I'll add it to rows and ranges before release.

Broken build (testing stuff)

Got it the full page setup working (print area, margins, headers, footers, center pages, paper sizes, etc.) and fixed issue #5554

Do not download. This is a broken (work in progress) version.

Fixed error when adding more than 3 sheets, added basic print options to worksheets. I want to implement full print options before next release (to make sure the framework is good).

Renamed XLCellValues.SharedString to XLCellValues.Text

Added ability to switch cell from one data type to another.

Fixed Range.Unmerge() method

Added ability to insert rows and columns to a worksheet and ranges.

Added Merged/Unmerge methods to the XLRange

Checked in by server upgrade

Alpha release

Preparing for alpha release

Working version. Still testing though.

Initial build. Has minimal capabilities. ...

(testing source control)

Initial build. Has minimal capabilities.