public static void InitiExcel(string[] name)
{
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
Spire.Xls.Worksheet newSheet1 = workbook.CreateEmptySheet("Crashes");
workbook.Worksheets.Remove("Sheet1");
workbook.Worksheets.Remove("Sheet2");
workbook.Worksheets.Remove("Sheet3");
newSheet1.Range["A1:M1"].ColumnWidth = 17;
newSheet1.Range.HorizontalAlignment = HorizontalAlignType.Center;
newSheet1.Range["B6"].Value = "Date";
for (int i = 1; i <= name.Length; i++)
{
newSheet1.Range[Convert.ToChar('B' + i).ToString() + "6"].Value = name[i - 1];
}
newSheet1.Range[Convert.ToChar('B' + (name.Length + 1)).ToString() + "6"].Value = "All Crashes";
newSheet1.Range[Convert.ToChar('B' + (name.Length + 2)).ToString() + "6"].Value = "Percent Impacted";
newSheet1.Range[Convert.ToChar('B' + (name.Length + 3)).ToString() + "6"].Value = "Crashes/OS";
newSheet1.Range[Convert.ToChar('B' + (name.Length + 4)).ToString() + "6"].Value = "OS";
newSheet1.Range["B6:" + Convert.ToChar('B' + (name.Length + 4)).ToString() + "6"].BorderInside(LineStyleType.Thin, Color.LightBlue);
newSheet1.Range["B6:" + Convert.ToChar('B' + (name.Length + 4)).ToString() + "6"].BorderAround(LineStyleType.Medium, Color.LightBlue);
workbook.SaveToFile(System.Environment.CurrentDirectory + "\\RecentData.xlsx", ExcelVersion.Version2013);
}
public static void GenerateChart(string[] name)
{
try
{
if (File.Exists(System.Environment.CurrentDirectory + "\\Trend Analysis.xlsx"))
{
File.Delete(System.Environment.CurrentDirectory + "\\Trend Analysis.xlsx");
}
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
Spire.Xls.Worksheet newSheet = workbook.CreateEmptySheet("Crashes");
workbook.Worksheets.Remove("Sheet1");
workbook.Worksheets.Remove("Sheet2");
workbook.Worksheets.Remove("Sheet3");
newSheet.Range["A1:M1"].ColumnWidth = 15;
//newSheet.Range.HorizontalAlignment = HorizontalAlignType.Center;
Spire.Xls.Workbook workbook1 = new Spire.Xls.Workbook();
workbook1.LoadFromFile(System.Environment.CurrentDirectory + "\\RecentData.xlsx");
//int lastRow = workbook1.Worksheets["Crashes"].LastRow;
int lastRow = workbook1.Worksheets["Crashes"].LastRow;
//workbook1.Worksheets["Crashes"].Range["B6:I6"].Copy(workbook.Worksheets["Crashes"].Range["A6:H6"]);
//workbook1.Worksheets["Crashes"].Range["B" + (lastRow - 29) + ":I" + lastRow].Copy(workbook.Worksheets["Crashes"].Range["A7:H36"]);
workbook1.Worksheets["Crashes"].Range["B6:" + Convert.ToChar('B' + (name.Length + 4)).ToString() + "6"].Copy(workbook.Worksheets["Crashes"].Range["A41:" + Convert.ToChar('A' + (name.Length + 4)).ToString() + "41"]);
if (lastRow < 37)
{
workbook1.Worksheets["Crashes"].Range["B7" + ":" + Convert.ToChar('B' + (name.Length + 4)).ToString() + lastRow].Copy(workbook.Worksheets["Crashes"].Range["A42:" + Convert.ToChar('A' + (name.Length + 4)).ToString() + (lastRow + 25)]);
}
else
{
workbook1.Worksheets["Crashes"].Range["B" + (lastRow - 29) + ":" + Convert.ToChar('B' + (name.Length + 4)).ToString() + lastRow].Copy(workbook.Worksheets["Crashes"].Range["A42:" + Convert.ToChar('A' + (name.Length + 4)).ToString() + "71"]);
}
workbook.Worksheets["Crashes"].Range["A41:" + Convert.ToChar('A' + (name.Length + 4)).ToString() + (lastRow + 25)].HorizontalAlignment = HorizontalAlignType.Center;
workbook.SaveToFile(System.Environment.CurrentDirectory + "\\Trend Analysis.xlsx", ExcelVersion.Version2013);
}
catch (Exception)
{
throw;
}
}