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();
}
