<?php
	require 'spreadsheet/vendor/autoload.php';

    //include the classes needed to create and write .xlsx file
    use PhpOffice\PhpSpreadsheet\Spreadsheet;
    use PhpOffice\PhpSpreadsheet\Writer\Xlsx;


    $inputFileTypeA= 'Xlsx';
    $inputFileNameA = './A1_data_input/Try2.xlsx';
    $sheetnameA = 'Try_sheet';


    /**  Create a new Reader of the type defined in $inputFileType  **/
    $readerA = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileTypeA);

    /**  Advise the Reader of which WorkSheets we want to load  **/
	$readerA->setLoadSheetsOnly($sheetnameA);

	//$readerA->setReadDataOnly(true);   //mute this for this application

    /**  Load $inputFileName to a Spreadsheet Object  **/
	$spreadsheetA = $readerA->load($inputFileNameA);

    $writerA = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheetA,'Html');

    $messageA = $writerA -> save ('C04_5_years_Plan_output.htm');

    echo $messageA;




    



    
?>




        <div align="center" >
            <span class="sub-page_Title">Keys of Department</span>
            <div class="empty_div_10"></div>
        </div>
 
        <div align="center">
            <table class="tb_C10_01">
                <tr>
                    <td class="cell_C10_01">
                        AAA
                    </td> 
                </tr>
                <tr>                    
                    <td class="cell_C10_01">
                        <?php include 'C04_5_years_Plan_output.htm'; ?>
                    </td>                         
                </tr>
            </table>
        </div>

        <div align="center" >
            <div class="empty_div_40"></div>
        </div>




