Luan da Silva Santos luan122
luan122
/ dataGridExcelExport.cs
Created
January 14, 2016 18:30
Exemplo pratico para exportar dados de uma datagridview para um arquivo .xls em C#
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| internal bool exportaExcel2(DataGridView dGv, string filename) | |
| { | |
| bool retorno = false; | |
| // Cria o Excel. | |
| Excel.Application Ex = new Excel.Application(); | |
| Excel.Workbook Wb = Ex.Workbooks.Add(Type.Missing); | |
| Excel.Worksheet Ws = null; | |
| //Este DataTable está aqui para absorver os dados do DataGrid e ser tratado dentro do Excel | |
| DataTable dt = new DataTable(); | |
| //Lista usada para gerar as colunas |