Ejemplos de Microsoft.Office.Interop.Microsoft.Office.Interop.Excel.Constants en C# (CSharp)

Ejemplo n.º 1

Archivo: MyExcel.cs Proyecto: dehuasux/TFS-Test-Manager

 public void SetCellProperty(Microsoft.Office.Interop.Excel.Worksheet ws, int Startx, int Starty, int Endx,
                             int Endy, int size, string name, Microsoft.Office.Interop.Excel.Constants color,
                             Microsoft.Office.Interop.Excel.Constants HorizontalAlignment)
 {
     ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).Font.Name           = name;
     ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).Font.Size           = size;
     ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).Font.Color          = color;
     ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).HorizontalAlignment = HorizontalAlignment;
 }

Ejemplo n.º 2

        public void SetCellProperty(string wsn, int Startx, int Starty, int Endx, int Endy, int size, string name, Microsoft.Office.Interop.Excel.Constants color, Microsoft.Office.Interop.Excel.Constants HorizontalAlignment)
        {
            //name = "宋体";
            //size = 12;
            //color = Microsoft.Office.Interop.Excel.Constants.xlAutomatic;
            //HorizontalAlignment = Microsoft.Office.Interop.Excel.Constants.xlRight;

            Microsoft.Office.Interop.Excel.Worksheet ws = GetSheet(wsn);
            ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).Font.Name  = name;
            ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).Font.Size  = size;
            ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).Font.Color = color;

            ws.get_Range(ws.Cells[Startx, Starty], ws.Cells[Endx, Endy]).HorizontalAlignment = HorizontalAlignment;
        }