static void ExcelOperations()
{
int spinnerInterval = 200;
var spinner = new Spinner(spinnerInterval);
spinner.Start();
Excel.Application excelApp = new Excel.Application();
Excel.Workbook excelBook = excelApp.Workbooks.Open(Environment.CurrentDirectory + @"\InputOutput_DailyStatus\" + InputExcelFileName);
Excel.Workbook excelBook2 = excelApp.Workbooks.Add(Type.Missing);
try
{
Excel._Worksheet excelSheet = excelBook.Sheets[1];
Excel.Range excelRange = excelSheet.Columns[1];
Excel.Range sourceHeader = excelSheet.Range["A1:I1"];
Excel.Range sourceBlankDataRow = excelSheet.Range["A10:I10"];
var currentTime = DateTime.Now.ToShortTimeString();
//For New Excel File
Excel._Worksheet excelSheetNew = excelBook2.Sheets[1];
excelSheetNew.Name = StatusDate.ToString("MM_dd_yyyy");
Excel.Range destHeader = excelSheetNew.Range["A1:I1"];
Excel.Range destFirstDataRow = excelSheetNew.Range["A2:I2"];
sourceHeader.Copy(destHeader);
excelSheetNew.Range["A1:I1"].RowHeight = 15;
for (int i = 0; i < dailyStatusModelList.Count; i++)
{
var excelRangeRow = i + 2;
string strDestRange = string.Format("A{0}:I{1}", excelRangeRow, excelRangeRow);
Excel.Range destDailyStatusRow = excelSheetNew.Range[strDestRange];
var dailyStatusModel = dailyStatusModelList[i];
sourceBlankDataRow.Copy(destDailyStatusRow);
excelSheetNew.Cells[excelRangeRow, 1] = dailyStatusModel.Id;
excelSheetNew.Cells[excelRangeRow, 2] = dailyStatusModel.Date;
excelSheetNew.Cells[excelRangeRow, 3] = dailyStatusModel.Track;
excelSheetNew.Cells[excelRangeRow, 4] = dailyStatusModel.Module;
excelSheetNew.Cells[excelRangeRow, 5] = dailyStatusModel.Practitioner;
excelSheetNew.Cells[excelRangeRow, 6] = dailyStatusModel.Activity;
excelSheetNew.Cells[excelRangeRow, 7] = dailyStatusModel.ActivityDetails;
excelSheetNew.Cells[excelRangeRow, 8] = dailyStatusModel.TFSID;
excelSheetNew.Cells[excelRangeRow, 9] = dailyStatusModel.Comments;
}
excelSheetNew.Columns[1].ColumnWidth = 18;
excelSheetNew.Columns[2].ColumnWidth = 18;
excelSheetNew.Columns[3].ColumnWidth = 18;
excelSheetNew.Columns[4].ColumnWidth = 30;
excelSheetNew.Columns[5].ColumnWidth = 20;
excelSheetNew.Columns[6].ColumnWidth = 20;
excelSheetNew.Columns[7].ColumnWidth = 18;
excelSheetNew.Columns[8].ColumnWidth = 18;
excelSheetNew.Columns[9].ColumnWidth = 25;
if (IsDev)
{
var currentDateTime = DateTime.Now.ToString("MMddyyyy-HHmmss");
var newFileName = "Dev_" + currentDateTime + ".xlsx";
GeneratedExcelFileNamePath = ExcelFilePathProdForSave + newFileName;
excelBook2.SaveAs2(GeneratedExcelFileNamePath);
}
else
{
var newFileName = "Status_SubhaDeb_" + StatusDate.ToString("MM_dd_yyyy") + ".xlsx";
GeneratedExcelFileNamePath = ExcelFilePathProdForSave + newFileName;
excelBook2.SaveAs2(GeneratedExcelFileNamePath);
}
Console.WriteLine();
Console.WriteLine("Excel File Created");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
excelBook.Save();
excelBook.Close();
//excelBook2.Save();
//excelBook2.Close();
excelApp.Quit();
spinner.Stop();
}
}