Posts tagged with 'excel'
This article on C1DataGrid for Silverlight is a utility blog to cater to the requirement of the developers who would like to show Translated text for cell values in DataGridTemplateColumn and along with that, export these translated Text to an excel sheet.
One of our customers asked us how to paste copied records from Excel in Wijmo Grid using Ctrl + v key. In this blog, we'll discuss a very simple approach to do the same.
C1Flexgrid for WinForms is hugely popular for being a flexible control and provides us with almost total control over rendering of its elements. In this blog article, I am going to discuss following customizations in C1Flexgrid :
You can easily filter columns in C1FlexGrid for Silverlight by using the C1FlexGridFilterService. This blog explains how you can implement Excel-like filtering in C1FlexGrid i.e show only those values in the Filter which are currently visible.
Wijmo GridView does not provide a method to export excel file. This blog explains a simple approach to save Wijmo GridView in a excel file. You can use the same approach for C1WebUI GridView as well.
When loading Excel files in Windows applications, the most commonly used option is to use Streams to read/write the files. Another easier method would be dragging the excel file directly from the explorer onto the grid.