Questions tagged as 'phpexcel'

Tagged questions
2
answers

Place an image in PHP excel With an external path

I have the following code to insert an excel image, which works correctly: $objDrawing = new PHPExcel_Worksheet_Drawing(); $objDrawing->setName('imgNotice'); $objDrawing->setDescription('Noticia');...
asked by 01.03.2017 / 17:46
1
answer

Read the .xlsx file with PHPExcel

I'm trying to read the cells in my xlsx file with PHPExcel but I can not get it. require_once('Classes/PHPExcel.php'); require_once('Classes/PHPExcel/Reader/Excel2007.php'); $objReader = new PHPExcel_Reader_Excel2007(); $objReader->setRe...
asked by 04.08.2016 / 17:01
1
answer

how to filter a download of a file by date?

   index.php <!DOCTYPE html> <meta charset="utf-8" /> <title>generando RIPS...</title> </head> <body> <div> <h1>Registros Individuales de Prestación de Servicios de...
asked by 25.07.2018 / 17:19
1
answer

PHP How to get the name of a variable file?

I am trying to import an excel book in PHP but the name of this file is changed every day. $nombreArchivo="/Carpeta/archivovariable.xlsx" Is there any code to add in the path such as "%%" or "*" so that the file is imported without importin...
asked by 30.01.2018 / 23:40
1
answer

Fatal error when generating excel with PHPExcel and SQL ... "Call to a member function query () on a non-object .."

My problem in particular is that I must generate an excel [.xlsx] (use PHPExcel) with data from SQL Server with PHP. The script that I edited already existed with MySQL statements and it worked perfectly, but when I change the sentences by SQ...
asked by 13.04.2018 / 15:53
0
answers

warning can not modify header information PhpExcel

When I download the excel I get this error.    Warning: Can not modify header information - headers already sent by (output started at C: \ xampp \ htdocs \ Unified \ view \ Load.php: 54) in C: \ xampp \ htdocs \ Unified \ model \ ProLoad.php...
asked by 21.01.2018 / 03:15
0
answers

Problems reading excel (xlsx)

I have a problem that I have never had when reading an xlsx file, I explain what I'm trying to do. I have a script placed in a cron that downloads the attachments of an email account and then reads the information from the files and saves them i...
asked by 27.10.2017 / 17:56
1
answer

Get the contents of an array or PHP object

I improvised a code that reads the XML files of a folder, one after another, and retrieves the information of some specific fields (title and summary), and I want to pass this information to a file CSV to one row per file (one column with ti...
asked by 27.01.2017 / 15:04
2
answers

PHPExcel error with Codeigniter

I am using PHPExcel with Codeigniter in a fairly simple way: $this->load->library('PHPExcel/Classes/PHPExcel'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("Gastos")->setDescriptio...
asked by 04.11.2016 / 21:39
1
answer

Filters excelphp

Hi, I'm using this library link and I want to add a date and time filter that looks like this: and in the BD the info is in the sgt structure: 2018-06-19 12:13:21 but when you put it in the cell it reads it as text and not a...
asked by 06.07.2018 / 19:00