This is a migrated thread and some comments may be shown as answers.

Spreadsheet extensions for C#

1 Answer 99 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Richard
Top achievements
Rank 1
Richard asked on 07 Dec 2017, 08:57 PM

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

1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 11 Dec 2017, 02:54 PM
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.

Regards,
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.
Tags
Spreadsheet
Asked by
Richard
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or