Telerik.Web.UI.Export.Utils
Static class containing Export-related utilities
Inheritance Hierarchy
- System.Object
- Telerik.Web.UI.Export.Utils
Methods
ConvertBorderStyle
Converts the ASP.NET BorderStyle enumeration values to Excel BorderStyle enumeration values
Parameters
borderStyle System.Web.UI.WebControls.BorderStyle
Returns
Telerik.Web.UI.ExcelBiff.BorderStyle
ConvertExcelCellIndexToPoint
Converts a given Excel-style string index to Point value
Parameters
index System.String
Index string
Returns
System.Drawing.Point
Point value
ConvertExcelColumnIndexToInt
Converts a given column index (Excel-style) to integer
Parameters
col System.String
Column index (Excel-style)
Returns
System.Int32
Integer column index
ConvertHorizontalAlign
BIFF: Convert from HorizontalAlign to HorizontalAlignment enumerations
Returns
Telerik.Web.UI.ExcelBiff.HorizontalAlignment
ConvertPointToExcelCellIndex
Converts a Point value to Excel-style cell index
Parameters
point System.Drawing.Point
Cell index (Point)
Returns
System.String
Excel-style cell index
ConvertToGuid
Converts a string value to Guid
Returns
System.Guid
Parsed Guid value. If parsing fails for some reason, the ConvertToGuid method will return Guid.Empty
ConvertToTimeSpan
Converts an object value to TimeSpan
Returns
System.TimeSpan
Parsed TimeSpan value. If parsing fails for some reason, the ConvertToTimeSpan method will return TimeSpan.Zero
ConvertVerticalAlign
BIFF: Convert from VerticalAlign to VerticalAlignment enumerations
Returns
Telerik.Web.UI.ExcelBiff.VerticalAlignment
ConvertXlsxBorderStyle
Converts the ASP.NET BorderStyle enumeration values to Excel BorderStyle enumeration values
Parameters
borderStyle System.Web.UI.WebControls.BorderStyle
Returns
Telerik.Windows.Documents.Spreadsheet.Model.CellBorderStyle
ConvertXlsxHorizontalAlign
XLSX: Convert from HorizontalAlign to HorizontalAlignment enumerations
Returns
Telerik.Windows.Documents.Spreadsheet.Model.RadHorizontalAlignment
ConvertXlsxVerticalAlign
XLSX: Convert from VerticalAlign to VerticalAlignment enumerations
Returns
Telerik.Windows.Documents.Spreadsheet.Model.RadVerticalAlignment
FontSizeToPoints
Converts strongly typed relative FontSize unit to points (double)
Parameters
fs System.Web.UI.WebControls.FontSize
FontSize value
Returns
System.Double
Size in points
GetCellRange
Returns a list of cells that correspond to a given range
Parameters
startPoint System.Drawing.Point
Start cell index
endPoint System.Drawing.Point
End cell index
Returns
System.Collections.Generic.List
1` List of cells
GetExcelCharactersPerUnit
Converts the given Unit value to "Excel Characters" unit value
Parameters
unit System.Web.UI.WebControls.Unit
Input value
defaultFont System.Drawing.Font
Default font used to calculate the Excel character width value
Returns
System.Double
Value converted in "Excel Characters"
GetInchesPerUnit
Returns the inches (in) per given Unit value
Returns
System.Double
GetPixelsPerUnit
Returns the pixels (px) per given Unit value
Returns
System.Double
GetPointsPerUnit
Returns the points (pt) per given Unit value
Returns
System.Double
IsValidExcelCellIndex
Checks if the provided Excel-style index is valid
Parameters
index System.String
Excel-style string index
Returns
System.Boolean
True if valid, false if not.
ReverseString
Reverses a string
Parameters
str System.String
String to be reversed
Returns
System.String
Reversed string
SanitizeCellText
Remove the recurring whitespaces; Remove the CR/LF chars, if any; Replace the HTML newline characters with CR/LFs; To put it simply, CR/LF has no meaning in HTML context so only line break characters should be taken into consideration. On the other hand, the HTML line break char is meaningless in the context of the BIFF file. This is to maintain the compatiblity and pertain the expected behavaior.
Parameters
cellText System.String
Returns
System.String