I found my self constructing a complex Worksheet server side in C#. Most of the spreadsheet methods are not chainable, as I had become accustomed to in my experience with LINQ processing and client side javascript. I'm paying it forward with this code, some simple CellSelection extension methods that made constructing my worksheets easier. The methods are not comprehensive -- only made the ones I needed. For example:
- ExcelColumnNameToNumber - convert those letter named columns into Excel column number
- Range - CellSelection using Excel addressing formats; RC or A1. Single cell or ranges (:)
- _Merge, _Bold, _Italic, _Center, _Left, _Right, _Middle, _Background, _Box, _FontSize, etc...
- Create your own methods for cell manipulation -- find more information in the documentation