public void Genereted_PCRaport()
{
System.Data.DataTable ActionList = new System.Data.DataTable();
System.Data.DataTable NewActionPozitive;
System.Data.DataTable NewActionNegative;
System.Data.DataTable NewActionPozitiveFinish;
System.Data.DataTable NewActionNegativeFinish;
string Link;
Worksheet worksheet;
Link = data_Import.Load_Link("Action");
data_Import.Load_TxtToDataTable(ref ActionList, Link);
NewActionPozitive = Load_Table(ActionList, "2019", "Pozytywna");
NewActionNegative = Load_Table(ActionList, "2019", "Negatywna");
NewActionPozitiveFinish = Prepare_Table(NewActionPozitive);
NewActionNegativeFinish = Prepare_Table(NewActionNegative);
Microsoft.Office.Interop.Excel.Application excel;
Workbook workbook;
Create_Excel_Application Application = new Create_Excel_Application();
excel = Application.Create_Application();
Create_Excel_WorkBooks Workbooks = new Create_Excel_WorkBooks();
workbook = Workbooks.Create_WorkBooks(excel);
Create_Excel_WorkSheet Excel_worksheet = new Create_Excel_WorkSheet();
worksheet = Excel_worksheet.Create_WorkSheet(workbook, "DM 2019");
worksheet.Application.ActiveWindow.Zoom = 85;
Action_WorkSheet(worksheet, NewActionPozitiveFinish, 10);
Action_WorkSheet(worksheet, NewActionNegativeFinish, 14 + NewActionPozitiveFinish.Rows.Count);
Save_Excel_WorkBook Save = new Save_Excel_WorkBook();
Save.Save_WorkBook(excel, workbook);
}
public void Genereted_Level1()
{
Microsoft.Office.Interop.Excel.Application excel;
Workbook workbook;
decimal YearGenereted;
YearGenereted = ((NumericUpDown)mainProgram.TabControl.Controls.Find("num_SummaryDetailYear", true).First()).Value;
Create_Excel_Application Application = new Create_Excel_Application();
excel = Application.Create_Application();
Create_Excel_WorkBooks Workbooks = new Create_Excel_WorkBooks();
workbook = Workbooks.Create_WorkBooks(excel);
Sum(workbook, YearGenereted);
Remove_Empty_Sheets(excel, workbook);
Save_Excel_WorkBook Save = new Save_Excel_WorkBook();
Save.Save_WorkBook(excel, workbook);
}