Welcome Guest, Not a member yet? Register   Sign In
Install Library Phpspreadsheet via Composoer Autoload not working?
#4

(This post was last modified: 09-30-2020, 07:52 PM by John_Betong.)

@mrardiyansyah,

I have been using a plain PHP application and PHP Spreadsheet for quite a few years.

I have PhpSpreadsheet installed in /var/www/ci2/vendor and use the following script to create a new instance:

PHP Code:
require '/var/www/ci2/vendor/autoload.php';  
    
use PhpOffice\PhpSpreadsheet\Spreadsheet;
    use PhpOffice\PhpSpreadsheet\Writer\Xlsx;


//==============================================
PRIVATE function _convertXlsToCsv
(
  
string $xls
  
string $csv
)
:
bool
{
  
$result FALSE;

  try {
    
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($xls);
    
$writer = new  \PhpOffice\PhpSpreadsheet\Writer\Csv($spreadsheet);
    
$writer->setUseBOM(true);
    
$writer->save($csv);
  }catch (
Exception $e){
    
print_r($e->message(), '$e->message()''red');
  }
  
$result file_exists($csv);

  return 
$result;
}
// 
Reply


Messages In This Thread
RE: Install Library Phpspreadsheet via Composoer Autoload not working? - by John_Betong - 09-30-2020, 07:46 PM



Theme © iAndrew 2016 - Forum software by © MyBB