Spreadsheet extensions for C#

2 posts, 0 answers
  1. Richard
    Richard avatar
    147 posts
    Member since:
    Feb 2012

    Posted 07 Dec 2017 Link to this post

    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
  2. Veselin Tsvetanov
    Veselin Tsvetanov avatar
    858 posts

    Posted 11 Dec 2017 Link to this post

    Hi Richard,

    Thank you very much for the shared extension methods for the Telerik.Windows.Documents.Spreadsheet.Model members. I believe that those will be of help for other developers too.

    As a small token of gratitude for the shared implementation, I have updated your Telerik points.

    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top