public void FormatErrorLog()
{
try
{
header_error_log_excel = new Application();
header_error_log_excel.DisplayAlerts = false;
header_error_log_wb = header_error_log_excel.Workbooks.Add(1);
header_error_log_ws = header_error_log_wb.Worksheets[1];
Range log_xlRange = header_error_log_ws.UsedRange;
int log_cols = log_xlRange.Columns.Count;
int log_rows = log_xlRange.Rows.Count;
string fileName = System.IO.Path.GetFileName(Program.sourcepath);
extension = Path.GetExtension(fileName);
fname = Path.GetFileNameWithoutExtension(fileName);
string error_folder = fname + DateTime.Now.ToString("yyyyMMddHHmmss");
destFile = Program.unsuccessful + @"\" + error_folder;
if (!System.IO.Directory.Exists(destFile))
{
System.IO.Directory.CreateDirectory(destFile);
}
var logstartCell = (Range)header_error_log_ws.Cells[1, 1];
var logendCell = (Range)header_error_log_ws.Cells[Source.headerformaterror_rownumber + 1, 3];
var logwriteRange = header_error_log_ws.Range[logstartCell, logendCell];
var columnHeadingsRangeHeader = header_error_log_ws.Range[header_error_log_ws.Cells[1, 1], header_error_log_ws.Cells[1, 3]];
columnHeadingsRangeHeader.Interior.Color = 0xD9D9D9;
columnHeadingsRangeHeader.Font.Color = XlRgbColor.rgbBlack;
columnHeadingsRangeHeader.Font.Size = 12;
columnHeadingsRangeHeader.EntireRow.Font.Bold = true;
columnHeadingsRangeHeader.Borders.Color = XlRgbColor.rgbBlack;
columnHeadingsRangeHeader.Cells.Style.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignTop;
var columnHeadingsRangeData = header_error_log_ws.Range[header_error_log_ws.Cells[2, 1], header_error_log_ws.Cells[Source.headerformaterror_rownumber, 3]];
columnHeadingsRangeData.Font.Color = XlRgbColor.rgbBlack;
columnHeadingsRangeData.Font.Size = 11;
columnHeadingsRangeData.Borders.Color = XlRgbColor.rgbBlack;
logwriteRange.Value2 = Source.headerformaterror;
savefilenameas = destFile + @"\" + "Format_Error_Log_File.xls";
header_error_log_wb.SaveAs(savefilenameas);
header_error_log_wb.Close(0);
}
catch (Exception e)
{
Console.WriteLine("File directory is too long, directory can't be more than 218 characters.");
Console.WriteLine("Can not Load or Create the Header Error log file.");
Program.CloseAllExcelAppication(header_error_log_ws, header_error_log_wb, header_error_log_excel);
}
finally
{
Program.CloseAllExcelAppication(header_error_log_ws, header_error_log_wb, header_error_log_excel);
}
// AutoFit Columns
AutoFitRowColumn fit = new AutoFitRowColumn();
fit.FittingRowColumn(savefilenameas);
//MoveExcelFiles
MoveExcelFiles move = new MoveExcelFiles();
move.MoveFiles(destFile, fname, extension);
}
public void ErrorLog()
{
ValidationCheck.errorlogfilearray[0, 0] = "Error Row Number";
ValidationCheck.errorlogfilearray[0, 1] = "Error Column Number";
ValidationCheck.errorlogfilearray[0, 2] = "Error Description";
error_log_excel = new Application();
error_log_excel.DisplayAlerts = false;
try
{
error_log_wb = error_log_excel.Workbooks.Add(1);
error_log_ws = error_log_wb.Worksheets[1];
Range log_xlRange = error_log_ws.UsedRange;
int log_cols = log_xlRange.Columns.Count;
int log_rows = log_xlRange.Rows.Count;
string fileName = System.IO.Path.GetFileName(Program.sourcepath);
extension = Path.GetExtension(fileName);
fname = Path.GetFileNameWithoutExtension(fileName);
string error_folder = fname + DateTime.Now.ToString("yyyyMMddHHmmss");
destFile = Program.unsuccessful + @"\" + error_folder;
if (!System.IO.Directory.Exists(destFile))
{
System.IO.Directory.CreateDirectory(destFile);
}
var logstartCell = (Range)error_log_ws.Cells[1, 1];
var logendCell = (Range)error_log_ws.Cells[ValidationCheck.logrows, 3];
var logwriteRange = error_log_ws.Range[logstartCell, logendCell];
var columnHeadingsRangeHeader = error_log_ws.Range[error_log_ws.Cells[1, 1], error_log_ws.Cells[1, 3]];
columnHeadingsRangeHeader.Interior.Color = 0xD9D9D9;
columnHeadingsRangeHeader.Font.Color = XlRgbColor.rgbBlack;
columnHeadingsRangeHeader.Font.Size = 12;
columnHeadingsRangeHeader.EntireRow.Font.Bold = true;
columnHeadingsRangeHeader.Borders.Color = XlRgbColor.rgbBlack;
columnHeadingsRangeHeader.Cells.Style.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignTop;
var columnHeadingsRangeData = error_log_ws.Range[error_log_ws.Cells[2, 1], error_log_ws.Cells[ValidationCheck.logrows, 3]];
columnHeadingsRangeData.Font.Color = XlRgbColor.rgbBlack;
columnHeadingsRangeData.Font.Size = 11;
columnHeadingsRangeData.Borders.Color = XlRgbColor.rgbBlack;
logwriteRange.Value2 = ValidationCheck.errorlogfilearray;
savefilenameas = destFile + @"\" + "Error_Log_File.xls";
error_log_wb.SaveAs(savefilenameas);
error_log_wb.Close(0);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine("Can not Load or Create the Error log file.");
Program.CloseAllExcelAppication(error_log_ws, error_log_wb, error_log_excel);
}
finally
{
Program.CloseAllExcelAppication(error_log_ws, error_log_wb, error_log_excel);
}
// AutoFit Columns
AutoFitRowColumn fit = new AutoFitRowColumn();
string fitfile = destFile + @"\" + "Format_Error_Log_File.xls";
fit.FittingRowColumn(savefilenameas);
//// move source file to error folder
MoveExcelFiles move = new MoveExcelFiles();
int notsuccessful = Source.source_total_rows - Program.successful_row - 3;
if (notsuccessful != 0)
{
move.MoveFiles(destFile, fname, extension);
}
}
