public static void ExportExcel(string dateipfad, DataGridView dgw)
{
if (dateipfad == null)
throw new ArgumentNullException("dateipfad");
var excelApp = new ApplicationClass();
excelApp.Application.Workbooks.Add(Type.Missing);
excelApp.Columns.ColumnWidth = 30;
int counter = 0;
//Kopfzeilen erzeugen
foreach (DataGridViewColumn column in dgw.Columns)
{
excelApp.Cells[1, counter + 1] = column.HeaderText.ToString();
counter++;
}
for (int i = 2; i < dgw.Rows.Count; i++)
{
DataGridViewRow row = dgw.Rows;
for (int j = 0; j < row.Cells.Count; j++)
{
excelApp.Cells[i + 1, j + 1] = row.Cells[j].FormattedValue.ToString();
}//FOR J
}//FOR I
excelApp.ActiveWorkbook.SaveCopyAs(dateipfad);
excelApp.ActiveWorkbook.Saved = true;
excelApp.Quit();
}
[/code]
|
|
|
|
|
|
|
|
|
public static void ExportExcel(string dateipfad, DataGridView dgw)
{
if (dateipfad == null)
throw new ArgumentNullException("dateipfad");
if (dgw == null)
throw new ArgumentNullException("dgw");
var excelApp = new ApplicationClass();
excelApp.Application.Workbooks.Add(Type.Missing);
excelApp.Columns.ColumnWidth = 30;
//Kopfzeilen erzeugen
for (int k = 1; k < dgw.Columns.Count - 1; k++ )
{
excelApp.Cells[1, k] = dgw.Columns[k].HeaderText.ToString(); //column.HeaderText.ToString();
}
for (int i = 1; i <= dgw.Rows.Count; i++)
{
DataGridViewRow row = dgw.Rows[i-1];
for (int j = 1; j < row.Cells.Count-1; j++)
{
excelApp.Cells[i + 1, j] = row.Cells[j].FormattedValue.ToString();
}//FOR J
}//FOR I
excelApp.ActiveWorkbook.SaveCopyAs(dateipfad);
excelApp.ActiveWorkbook.Saved = true;
excelApp.Quit();
}
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using Excel = Microsoft.Office.Interop.Excel;
|
|
|
