1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
public static void ExporterDataGridVersExcel(GridView dgView, String unFichier, string strEnteteDeFichier)
{
int i = 0;
int j = 1;
try
{
// initialisation du fichier excel
ExcelApplication excel = new ExcelApplication();
Workbook exbook = (Workbook)excel.Workbooks.Add(Missing.Value);
Worksheet exsheet = (Worksheet)excel.ActiveSheet;
//Mise en forme de l'en-tête de la feuille Excel
exsheet.Cells[1, 1] = strEnteteDeFichier;
Range r = exsheet.get_Range(Convert.ToChar(65 + i).ToString() + "1", Missing.Value);
r.Interior.ColorIndex = XlColorIndex.xlColorIndexAutomatic;
r.Font.Bold = true;
r.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic, Missing.Value);
r.EntireColumn.AutoFit();
//Fin de la mise en forme de l'en-tête.
if (dgView.Rows.Count > 0)
{
// initialisation colonnes
foreach (TableCell ch in dgView.Rows[0].Cells )
{
r = exsheet.get_Range(Convert.ToChar(65 + i).ToString() + "1", Missing.Value);
exsheet.Cells[j, i + 1] = ((System.Web.UI.WebControls.DataControlFieldCell)(ch)).ContainingField.HeaderText;
r.Interior.ColorIndex = XlColorIndex.xlColorIndexAutomatic;
r.Font.Bold = true;
r.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic, Missing.Value);
r.EntireColumn.AutoFit();
i++;
}
j++;
foreach (GridViewRow uneLigne in dgView.Rows)
{
//foreach (DataControlField uneColonne in dgView.Columns
for (int nocolonne = 0; nocolonne < i ; nocolonne++)
{
r = exsheet.get_Range(Convert.ToChar(65 + nocolonne).ToString() + j.ToString(), Missing.Value);
exsheet.Cells[j, nocolonne + 1] = "'" +
uneLigne.Cells[nocolonne].Text.ToString().Trim();
//r.BorderAround(XlLineStyle.xlContinuous, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic, Missing.Value);
//r.EntireColumn.AutoFit();
}
//exsheet.Columns.AutoFit();
j++;
}
}
exsheet.Columns.AutoFit();
exsheet.SaveAs(unFichier, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
excel.Quit();
}
catch (Exception ex)
{
throw (ex);
}
} |
