Click here to Skip to main content
12,947,902 members (81,244 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
how can display a excel file in datagridview OR how can export a excel file to DataGridView in C#
Posted 19-Jan-13 2:34am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
f_gharavi 19-Jan-13 23:49pm
   
Thank you very much for your help
Please Help Me About This Problem in WPF( Export Excel File to DataGridView in WPF)
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

Hi, you can use this .net excel component and easily import and export DataGridView to Excel.
Here is a C# excel sample code:
// Export active worksheet to DataGridView.
DataGridViewConverter.ExportToDataGridView(
     excelFile.Worksheets.ActiveWorksheet, 
     dataGridView, 
     new ExportToDataGridViewOptions());
 
// Import DataGridView back to active worksheet.
DataGridViewConverter.ImportFromDataGridView(
     excelFile.Worksheets.ActiveWorksheet, 
     dataGridView, 
     new ImportFromDataGridViewOptions());
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,344
CHill60 3,275
Maciej Los 2,628
Jochen Arndt 1,935
ppolymorphe 1,795


Advertise | Privacy | Mobile
Web02 | 2.8.170518.1 | Last Updated 13 May 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100