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
|
Excel._Application xlApp;
Excel._Workbook xlClasseur;
xlApp = new Excel.Application();
try
{
object Missing = System.Reflection.Missing.Value;
//Instanciation de l'appli
Excel._Worksheet xlFeuill1;
xlApp.Visible = false;
xlClasseur = xlApp.Workbooks.Add(Missing);
Excel.Sheets xlFeuilles = xlClasseur.Sheets;
xlFeuill1 = (Excel._Worksheet)xlFeuilles["Feuil1"];
string todaySheet = DateTime.Now.ToShortDateString().Replace('/', ' ');
xlFeuill1.Name = "Roi_des_rois_" + todaySheet;
string plage = "E";
xlFeuill1.Cells.Font.Size = 11;
string plageSelected = plage + "1";
Excel.Range rg = xlFeuill1.get_Range("A1", plageSelected);
rg.Select();
rg.Font.Bold = true;
rg.WrapText = true;
rg.HorizontalAlignment = Excel.Constants.xlCenter;
rg.Interior.ColorIndex = 40;
rg.Borders.Weight = 3;
rg.Borders.LineStyle = Excel.Constants.xlSolid;
rg.Cells.RowHeight = 15;
rg.Cells.ColumnWidth = 12;
xlFeuill1.get_Range("A1", "A1").ColumnWidth = 20;
xlFeuill1.get_Range("B1", "B1").ColumnWidth = 20;
xlFeuill1.get_Range("C1", "C1").ColumnWidth = 20;
xlFeuill1.get_Range("D1", "D1").ColumnWidth = 30;
xlFeuill1.get_Range("E1", "E1").ColumnWidth = 20;
xlFeuill1.Cells[1, 1] = "Vendeur";
xlFeuill1.Cells[1, 2] = "Date";
xlFeuill1.Cells[1, 3] = "Désignation";
xlFeuill1.Cells[1, 4] = "Nb Vendu";
xlFeuill1.Cells[1, 5] = "Prix Total";
int i = 2; |
Partager