1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
$worksheet->write("A3","Archiving", $Datatype);
$worksheet->write("B3","$count_corp_nbb2{Archiving}", $Data);
$worksheet->write("C3","$count_corp_nbb4{Archiving}", $Data);
$worksheet->write("A4","Filer", $Datatype);
$worksheet->write("B4","$count_corp_nbb2{Filer}", $Data);
$worksheet->write("C4","$count_corp_nbb4{Filer}", $Data);
$worksheet->write("A5","NetBackup", $Datatype);
$worksheet->write("B5","$count_corp_nbb2{NetBackup}", $Data);
$worksheet->write("C5","$count_corp_nbb4{NetBackup}", $Data);
$worksheet->write("A6","Oracle", $Datatype);
$worksheet->write("B6","$count_corp_nbb2{Oracle}", $Data);
$worksheet->write("C6","$count_corp_nbb4{Oracle}", $Data);
$worksheet->write("A7","SQL", $Datatype);
$worksheet->write("B7","$count_corp_nbb2{SQL}", $Data);
$worksheet->write("C7","$count_corp_nbb4{SQL}", $Data);
$worksheet->write("A8","Solaris", $Datatype);
$worksheet->write("B8","$count_corp_nbb2{Solaris}", $Data);
$worksheet->write("C8","$count_corp_nbb4{Solaris}", $Data);
$worksheet->write("A9","VMware", $Datatype);
$worksheet->write("B9","$count_corp_nbb2{VMware}", $Data);
$worksheet->write("C9","$count_corp_nbb4{VMware}", $Data);
$worksheet->write("A10","Other", $Datatype);
$worksheet->write("B10","$count_corp_nbb2{Other}", $Data);
$worksheet->write("C10","$count_corp_nbb4{Other}", $Data);
$worksheet->write("A11","Total", $TypeBottom);
$worksheet->write("B11","=SUM(B3:B10)", $DataBottom);
$worksheet->write("C11","=SUM(C3:C10)", $DataBottom); |
Partager