Please enter Aspose SID and Key on plugin settings page.

'; // return; } /* * Assign Base Product URL */ Product::$baseProductUri = 'http://api.aspose.com/v1.1'; AsposeApp::$appSID = $ape_sid; AsposeApp::$appKey = $ape_key; $post_params = $_POST; //echo "

"; print_r($post_params); exit;
$excel_file = $post_params['excel_file_name'];
if(!isset($post_params['sheet_name']) || empty($post_params['sheet_name']) ) {
    $sheet_name = 'Sheet1';
}

$excel_file = $post_params['filename'];

$ext = pathinfo($excel_file, PATHINFO_EXTENSION);


if($ext == 'xls' || $ext == 'xlsx') {

    $func = new Worksheet($excel_file,$sheet_name);
   // $total_cols = $func->setCellValue('','',);
    if(isset($post_params['col']) && is_array($post_params['col'])){
        $total_rows = $func->getRowsCount(0,10000);
        $next_row = $total_rows + 1;
        foreach($post_params['col'] as $key=>$value){
            $cell = generateAlphabet($key) . $next_row;
            $func->setCellValue($cell,'string',$value);
        }
        echo 'Record has been updated!';
    }
} else {
    echo "Wrong File was selected!";
}