public Excel.XlHAlign HorizontalAlignment(ExAlign exalign) { Excel.XlHAlign EX = new Microsoft.Office.Interop.Excel.XlHAlign(); switch (exalign) { case ExAlign.Left: EX = Excel.XlHAlign.xlHAlignLeft; break; case ExAlign.Right: EX = Excel.XlHAlign.xlHAlignRight; break; case ExAlign.Justify: EX = Excel.XlHAlign.xlHAlignJustify; break; case ExAlign.Center: EX = Excel.XlHAlign.xlHAlignCenter; break; case ExAlign.Distributed: EX = Excel.XlHAlign.xlHAlignDistributed; break; case ExAlign.General: EX = Excel.XlHAlign.xlHAlignGeneral; break; case ExAlign.Fill: EX = Excel.XlHAlign.xlHAlignFill; break; case ExAlign.CenterAcrossSelection: EX = Excel.XlHAlign.xlHAlignCenterAcrossSelection; break; } return(EX); }
public void addData(int row, int col, string data, string cell1, string cell2, string format, int ctype, ExAlign HAlignment, bool font, string FontName, int FontSize) { worksheet.Cells[row, col] = data; workSheet_range = (Excel.Range)worksheet.Cells[row, col];// worksheet.get_Range(cell1, cell2); workSheet_range.Borders.Color = System.Drawing.Color.Black.ToArgb(); workSheet_range.NumberFormat = format; if (format == Format.DDMMMYYYY) { workSheet_range.Columns.AutoFit(); } workSheet_range.HorizontalAlignment = HorizontalAlignment(HAlignment); if (ctype == 1) { workSheet_range.Interior.Color = System.Drawing.Color.PeachPuff.ToArgb(); } workSheet_range.Font.Bold = font; workSheet_range.Font.Name = FontName; workSheet_range.Font.Size = FontSize; }
public void createHeaders(string data, int Srow, int Scol, int Erow, int Ecol, System.Drawing.Color backcolor, bool fontbold, int size, System.Drawing.Color fcolor, int fontsize, ExAlign HAlignment) { worksheet.Cells[Srow, Scol] = data; workSheet_range = worksheet.get_Range(worksheet.Cells[Srow, Scol], worksheet.Cells[Erow, Ecol]);// (Excel.Range)worksheet.Cells[row, col]; // worksheet.get_Range(cell1, cell2); workSheet_range.MergeCells = true; workSheet_range.Merge(false); workSheet_range.HorizontalAlignment = HorizontalAlignment(HAlignment); workSheet_range.Interior.Color = backcolor.ToArgb(); workSheet_range.Font.Bold = fontbold; workSheet_range.Font.Size = fontsize; workSheet_range.ColumnWidth = size; workSheet_range.Font.Color = fcolor.ToArgb(); //workSheet_range.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlThin, Excel.XlColorIndex.xlColorIndexNone, 0); //workSheet_range.WrapText = false; }
public void createSubHeadersWB(string data, int Srow, int Scol, int Erow, int Ecol, System.Drawing.Color backcolor, bool fontbold, int size, System.Drawing.Color fcolor, int fontsize, ExAlign HAlignment) { worksheet.Cells[Srow, Scol] = data; workSheet_range = worksheet.get_Range(worksheet.Cells[Srow, Scol], worksheet.Cells[Erow, Ecol]);// (Excel.Range)worksheet.Cells[row, col]; // worksheet.get_Range(cell1, cell2); workSheet_range.MergeCells = true; workSheet_range.Merge(false); workSheet_range.HorizontalAlignment = HorizontalAlignment(HAlignment); workSheet_range.Interior.Color = backcolor.ToArgb(); workSheet_range.Font.Bold = fontbold; workSheet_range.Font.Size = fontsize; if (size != 0) { workSheet_range.ColumnWidth = size; } workSheet_range.Font.Color = fcolor.ToArgb(); //workSheet_range.WrapText = false; }
public void createHeaders(int row, int col, string htext, string cell1, string cell2, int mergeColumns, System.Drawing.Color backcolor, bool fontbold, int size, System.Drawing.Color fcolor, int fontsize, ExAlign HAlignment) { workSheet_range = worksheet.get_Range(cell1, cell2);// (Excel.Range)worksheet.Cells[row, col]; // worksheet.get_Range(cell1, cell2); workSheet_range.NumberFormat = "@"; worksheet.Cells[row, col] = htext; workSheet_range.Merge(mergeColumns); workSheet_range.Interior.Color = backcolor.ToArgb(); workSheet_range.Borders.Color = System.Drawing.Color.Black.ToArgb(); workSheet_range.Font.Bold = fontbold; workSheet_range.Font.Size = fontsize; workSheet_range.ColumnWidth = size; workSheet_range.HorizontalAlignment = HorizontalAlignment(HAlignment); //workSheet_range.Columns.AutoFit(); workSheet_range.Font.Color = fcolor.ToArgb(); }