I am generating CSV File using phpexcel and i am able to download and save the csv file but i am unable to upload csv file generated by phpexcel to ftp server directly without saving please guide me to upload csv file generated by phpexcel without saving locally my code is below
error_reporting(E_ALL);
include 'PHPExcel.php';
include PHPExcel/Writer/CSV.php';
require_once "PHPExcel/IOFactory.php";
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1',"1");
$objPHPExcel->getActiveSheet()->setCellValue('B1',"2");
$objPHPExcel->getActiveSheet()->setCellValue('A2',"3");
$filename='gs.csv'; //just some random filename
header('Content-Type: text/CSV');
header('Content-Disposition: attachment;filename="'.$filename.'"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');
$objWriter->save('php://output');
$ftp_server='ftp.exc.in';
$ftp_user_name='user';
$ftp_user_pass='pass';
$local_file=fopen('php://temp', 'r+');
$remote_file="/test/gs.csv";
rewind($local_file);
$ftp_conn=ftp_connect($ftp_server);
@$login_result=ftp_login($ftp_conn, $ftp_user_name, $ftp_user_pass);
if($login_result) $upload_result=ftp_fput($ftp_conn, $remote_file, $local_file, FTP_ASCII);
ftp_close($ftp_conn);
fclose($local_file);
The above code generate the csv file but it is asking to download but i need only upload the csv file without saving locally