This release took longer than expected because I had to refactor the way I was handling rows, columns, and ranges.New on this release:1)
Inserting rows/columns to worksheets/ranges will shift existing referenced ranges accordingly.
var rngTitles = worksheet.Range("B2:D2");
Console.Write(rngTitles.ToString()); // Prints "B4:D4" because the entire range moved down 2 rows.
See examples Inserting and Deleting Rows
and Inserting and Deleting Columns2)
Added a DateFormat to the styles. It does the same function as Style.NumberFormat but it will be more intuitive for
someone trying to format a date.
So instead of doing:
rngDates.Style.NumberFormat.Format = "MM/dd/yyyy";
You can now do:
rngDates.Style.DateFormat.Format = "MM/dd/yyyy";3)
Modified IXLRange to have the "IXLRanges Ranges(...)" methods. IXLRanges is a collection of ranges which allow you to
modify them all in one shot.
See example Multiple Ranges4)
Worksheet.Style, Worksheet.Columns(), and Worksheet.Rows() now apply to the entire worksheet (not just the used cells).
worksheet.Style.Fill.BackgroundColor = Color.Blue; // Will turn every
worksheet.Columns().Style.Fill.BackgroundColor = Color.Blue; // Will do the same (turn every cell blue)
worksheet.Rows().Style.Fill.BackgroundColor = Color.Blue; // Will do the same (turn every cell blue)
worksheet.Columns().Width = 30; // Will set the width of every column to 30
worksheet.Rows().Height = 15; // Will set the height of every row to 15
See examples Style Worksheet
and Style Rows and Columns5)
Fixed a bug in the Saving function.
Fixed inserting an entire row/column to a worksheet (now that we're supporting entire worksheets/rows/columns)New Examples:Multiple RangesStyle WorksheetStyle Rows and ColumnsInserting RowsInserting and Deleting RowsInserting ColumnsInserting and Deleting ColumnsExamples changed:Data TypesLoading and Modifying FilesHeaders and Footers TabExamples removedInserting Rows and Columns