Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); // Create string lookup table $this->stringTable = []; for ($i = 0; $i < $this->spreadSheet->getSheetCount(); ++$i) { $this->stringTable = $this->getWriterPart('StringTable')->createStringTable($this->spreadSheet->getSheet($i), $this->stringTable); } // Create styles dictionaries $this->styleHashTable->addFromSource($this->getWriterPart('Style')->allStyles($this->spreadSheet)); $this->stylesConditionalHashTable->addFromSource($this->getWriterPart('Style')->allConditionalStyles($this->spreadSheet)); $this->fillHashTable->addFromSource($this->getWriterPart('Style')->allFills($this->spreadSheet)); $this->fontHashTable->addFromSource($this->getWriterPart('Style')->allFonts($this->spreadSheet)); $this->bordersHashTable->addFromSource($this->getWriterPart('Style')->allBorders($this->spreadSheet)); $this->numFmtHashTable->addFromSource($this->getWriterPart('Style')->allNumberFormats($this->spreadSheet)); // Create drawing dictionary $this->drawingHashTable->addFromSource($this->getWriterPart('Drawing')->allDrawings($this->spreadSheet)); $zip = new ZipArchive(); if (file_exists($pFilename)) { unlink($pFilename); } // Try opening the ZIP file if ($zip->open($pFilename, ZipArchive::OVERWRITE) !== true) { if ($zip->open($pFilename, ZipArchive::CREATE) !== true) { throw new WriterException('Could not open ' . $pFilename . ' for writing.'); } } // Add [Content_Types].xml to ZIP file $zip->addFromString('[Content_Types].xml', $this->getWriterPart('ContentTypes')->writeContentTypes($this->spreadSheet, $this->includeCharts)); //if hasMacros, add the vbaProject.bin file, Certificate file(if exists) if ($this->spreadSheet->hasMacros()) { $macrosCode = $this->spreadSheet->getMacrosCode(); if ($macrosCode !== null) { // we have the code ? $zip->addFromString('xl/vbaProject.bin', $macrosCode); //allways in 'xl', allways named vbaProject.bin
"Class 'ZipArchive' not found"
Key | Value |
PHPRC | "/home/humanrights/fcgi-bin/../etc/php7.2"
|
SCRIPT_FILENAME | "/home/humanrights/public_html/public/index.php"
|
PATH | "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin"
|
PWD | "/home/humanrights/fcgi-bin"
|
SHLVL | "0"
|
PHP_FCGI_MAX_REQUESTS | "99999"
|
SCRIPT_NAME | "/index.php"
|
REQUEST_URI | "/export/category/94"
|
QUERY_STRING | "" |
REQUEST_METHOD | "GET"
|
SERVER_PROTOCOL | "HTTP/1.1"
|
GATEWAY_INTERFACE | "CGI/1.1"
|
REDIRECT_URL | "/export/category/94"
|
REMOTE_PORT | "15986"
|
SERVER_ADMIN | "root@localhost"
|
CONTEXT_DOCUMENT_ROOT | "/home/humanrights/public_html/public"
|
CONTEXT_PREFIX | "" |
REQUEST_SCHEME | "https"
|
DOCUMENT_ROOT | "/home/humanrights/public_html/public"
|
REMOTE_ADDR | "172.17.76.142"
|
SERVER_PORT | "443"
|
SERVER_ADDR | "10.153.224.34"
|
SERVER_NAME | "humanrights.oik-rks.org"
|
SERVER_SOFTWARE | "Apache/2.4.6"
|
SERVER_SIGNATURE | "" |
HTTP_CF_IPCOUNTRY | "US"
|
HTTP_CDN_LOOP | "cloudflare"
|
HTTP_CF_CONNECTING_IP | "3.81.72.247"
|
HTTP_USER_AGENT | "claudebot"
|
HTTP_ACCEPT | "*/*"
|
HTTP_CF_VISITOR | "{"scheme":"https"}"
|
HTTP_X_FORWARDED_PROTO | "https"
|
HTTP_CF_RAY | "86bfdcc71b5c2d06-IAD"
|
HTTP_X_FORWARDED_FOR | "3.81.72.247"
|
HTTP_ACCEPT_ENCODING | "gzip, br"
|
HTTP_CONNECTION | "close"
|
HTTP_HOST | "humanrights.oik-rks.org"
|
SSL_TLS_SNI | "humanrights.oik-rks.org"
|
HTTPS | "on"
|
SCRIPT_URI | "https://humanrights.oik-rks.org/export/category/94"
|
SCRIPT_URL | "/export/category/94"
|
UNIQUE_ID | "Zga0BtY9CuC6tJZ9cJawCgAAAAc"
|
REDIRECT_STATUS | "200"
|
REDIRECT_SSL_TLS_SNI | "humanrights.oik-rks.org"
|
REDIRECT_HTTPS | "on"
|
REDIRECT_SCRIPT_URI | "https://humanrights.oik-rks.org/export/category/94"
|
REDIRECT_SCRIPT_URL | "/export/category/94"
|
REDIRECT_UNIQUE_ID | "Zga0BtY9CuC6tJZ9cJawCgAAAAc"
|
FCGI_ROLE | "RESPONDER"
|
PHP_SELF | "/index.php"
|
REQUEST_TIME_FLOAT | 1711715334.0723
|
REQUEST_TIME | 1711715334
|
APP_NAME | "Laravel"
|
APP_ENV | "local"
|
APP_KEY | "base64:DxlbcO6Z2WaVXJqnrAd6dKiZx7EzG9jLaHCxyb8aT/k="
|
APP_DEBUG | "true"
|
APP_URL | "http://localhost"
|
LOG_CHANNEL | "stack"
|
DB_CONNECTION | "mysql"
|
DB_HOST | "127.0.0.1"
|
DB_PORT | "3306"
|
DB_DATABASE | "humanrights"
|
DB_USERNAME | "humanrights"
|
DB_PASSWORD | "u|uU<5)R(0b*"
|
BROADCAST_DRIVER | "log"
|
CACHE_DRIVER | "file"
|
QUEUE_CONNECTION | "sync"
|
SESSION_DRIVER | "file"
|
SESSION_LIFETIME | "360"
|
REDIS_HOST | "127.0.0.1"
|
REDIS_PASSWORD | "null"
|
REDIS_PORT | "6379"
|
MAIL_DRIVER | "smtp"
|
MAIL_HOST | "smtp.mailtrap.io"
|
MAIL_PORT | "2525"
|
MAIL_USERNAME | "null"
|
MAIL_PASSWORD | "null"
|
MAIL_ENCRYPTION | "null"
|
AWS_ACCESS_KEY_ID | "" |
AWS_SECRET_ACCESS_KEY | "" |
AWS_DEFAULT_REGION | "us-east-1"
|
AWS_BUCKET | "" |
PUSHER_APP_ID | "" |
PUSHER_APP_KEY | "" |
PUSHER_APP_SECRET | "" |
PUSHER_APP_CLUSTER | "mt1"
|
MIX_PUSHER_APP_KEY | "" |
MIX_PUSHER_APP_CLUSTER | "mt1"
|
Key | Value |
APP_NAME | "Laravel"
|
APP_ENV | "local"
|
APP_KEY | "base64:DxlbcO6Z2WaVXJqnrAd6dKiZx7EzG9jLaHCxyb8aT/k="
|
APP_DEBUG | "true"
|
APP_URL | "http://localhost"
|
LOG_CHANNEL | "stack"
|
DB_CONNECTION | "mysql"
|
DB_HOST | "127.0.0.1"
|
DB_PORT | "3306"
|
DB_DATABASE | "humanrights"
|
DB_USERNAME | "humanrights"
|
DB_PASSWORD | "u|uU<5)R(0b*"
|
BROADCAST_DRIVER | "log"
|
CACHE_DRIVER | "file"
|
QUEUE_CONNECTION | "sync"
|
SESSION_DRIVER | "file"
|
SESSION_LIFETIME | "360"
|
REDIS_HOST | "127.0.0.1"
|
REDIS_PASSWORD | "null"
|
REDIS_PORT | "6379"
|
MAIL_DRIVER | "smtp"
|
MAIL_HOST | "smtp.mailtrap.io"
|
MAIL_PORT | "2525"
|
MAIL_USERNAME | "null"
|
MAIL_PASSWORD | "null"
|
MAIL_ENCRYPTION | "null"
|
AWS_ACCESS_KEY_ID | "" |
AWS_SECRET_ACCESS_KEY | "" |
AWS_DEFAULT_REGION | "us-east-1"
|
AWS_BUCKET | "" |
PUSHER_APP_ID | "" |
PUSHER_APP_KEY | "" |
PUSHER_APP_SECRET | "" |
PUSHER_APP_CLUSTER | "mt1"
|
MIX_PUSHER_APP_KEY | "" |
MIX_PUSHER_APP_CLUSTER | "mt1"
|