We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How do I change font styles while importing an Excel file to Grid?

Platform: WinForms |
Control: GridControl |
Published Date: March 19, 2015 |
Last Revised Date: March 19, 2015

By default, the font styles of the Excel Cells are imported from Excel to Grid, as it is. The font styles of the Excel Cells can be changed while importing them to Grid by handling the QueryImportExportCellInfo event. Using this event, the font style can be set, by using the Font.Facename property and other styles can also be changed when e.Action is set as GridConverterAction.Import.

C#

VB

Screenshots:

Figure 1: Font type in Excel

 

Figure 2: Font type in Grid after importing the above Excel sheet

Sample:

C#: Changing_Font_Style_while_importing_CS

VB: Changing_Font_Style_while_importing_VB

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon