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 to import values (not formula) from excel into gridcontrol

Thread ID:





127929 Dec 20,2016 06:40 AM UTC Dec 21,2016 03:00 PM UTC WinForms 1
Tags: GridControl
Rem Aza
Asked On December 20, 2016 06:40 AM UTC

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 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. 


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.

Please sign in to access our forum

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