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.
Unfortunately, activation email could not send to your email. Please try again.

How to import values (not formula) from excel into gridcontrol

Thread ID:





127929 Dec 20,2016 01:40 AM Dec 21,2016 10:00 AM Windows Forms 1
Tags: GridControl
Rem Aza
Asked On December 20, 2016 01:40 AM

I am importing one excel file into a gridcontrol.
Some of the cells in the excel have formula.

When I import to gridcontrol I want to import the cell values but currently xlsio imports and shows formula in the grid cells.
How can I fix this ?

Mohanraj Gunasekaran [Syncfusion]
Replied On December 21, 2016 10:00 AM

Hi Remmie, 

Thanks for using Syncfusion products. 

In GridControl, following kind of importing are available. They are 
1.       VirtualImporting 
2.        NormalImporting 

By default, formula cells are exported to Grid as Formula cell in both kind of exporting. We have tested your scenario using normal importing and VirtualImporting. But we are unable to reproduce your scenario at our end. Here we have attached the simple sample for normal importing and imported excel file, also tried to import this excel file in Virtual importing sample, sample location was mentioned below, so can you please provide the details of your importing code part or modify the below attached sample to reproduce your scenario. It will be helpful to provide the solution at the earliest. 

Sample link: GridControl 
Virtual importing: <Installed location>/Syncfusion/EssentialStudio/[Version_number]/Windows/Grid.Windows/Samples/Importing/Virtual Importing/cs 
Mohanraj G. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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.