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. Image for the cookie policy date

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

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 ?

1 Reply

MG Mohanraj Gunasekaran Syncfusion Team December 21, 2016 03:00 PM UTC

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. 

Live Chat Icon For mobile
Up arrow icon