Por cierto gracias al comentario de José Renteira que me ayudó a encontrar una solución. https://plus.google.com/114583721646550413124/posts/DkCnhC65wJ2
By the way, thanks to José Renteira's comment that helped me find a solution . https://plus.google.com/114583721646550413124/posts/DkCnhC65wJ2
@MassiPi Look for "Encryption" on https://phpspreadsheet.readthedocs.io/en/latest/references/features-cross-reference/
Am looking to use PHPPresentation and PHPWord in my Laravel 5.6 app, any pointers?
@xenothanhojem Try your luck in their Gitter rooms, not here
@PowerKiKi this my code
$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;
$cacheSettings = array('memoryCacheSize' => '8MB');
PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);
i dont understand correlation between cachedobjectstoragefactory and cellsfactory.
please help me
@tputraa you are using PHPExcel, but this is a Gitter room for PhpSpreadsheet. You are in the wrong place, and more importantly you are using the wrong library, see: https://github.com/PHPOffice/PHPExcel#phpexcel---dead
i dont see correlation between cachedobjectstoragefactory and cellsfactory
@tputraa see https://phpspreadsheet.readthedocs.io/en/latest/topics/migration-from-PHPExcel/, there is a section dedicated to caching
I'm sorry if this has been asked before, but I didn't see it when I searched. Are there any plans to implement Excel's document password encryption feature where you have to enter a password to open the file? For my purposes, it doesn't have to be compatible with Excel's encryption algorithm. I just need to create a file and encrypt it with a password, so the user is prompted for the password to open the file. Thanks
@lovealan try
\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet::getMergeCells() and read https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#mergeunmerge-cells
What I want is - If I have date (A2:A5) for example 1.4.2019 and I want that day's expenses (B2:B5) in format of B2+B3+B4... and so on
And if they are paid with credit card (C2:C5), I want them in same format also C2+C4+C5.. they might not have been paid with card so that needs to be left out
I want business expenses + paid with card to same row where the is already put date when they were made to another Excel file without making a new excel, just updating existing one. Is this possible with phpspreadsheet?
And if they are paid with credit card (C2:C5), I want them in same format also C2+C4+C5.. they might not have been paid with card so that needs to be left out
I want business expenses + paid with card to same row where the is already put date when they were made to another Excel file without making a new excel, just updating existing one. Is this possible with phpspreadsheet?
I'm just trying to use the PhpOffice/PhpSpreadsheet with ZF3. I installed by composer and when I used then : $inputFileType = 'Xls';
$reader = IOFactory::createReader($inputFileType);my application show the following error: Class 'PhpOffice\PhpSpreadsheet\IOFactory' not found
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
private function readExcelFile( $inputFileName )
{
$inputFileType = 'Xls';
{
$inputFileType = 'Xls';
$reader = IOFactory::createReader($inputFileType);
$reader->setReadDataOnly( true );
$spreadsheet = $reader->load($inputFileName);
$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
return $sheetData;
}
there is nothing specific with ZF3
oh, and of course triple-check that you
require_once 'vendor/autoload.php'; somewhere in your project, but that must be already the case if you use ZF3
on a final note, use triple backticks (`) blocks to properly format code in this chat
Returns NULL Whats wrong?