Questions tagged as 'phpexcel'

Tagged questions
0
answers

PHPExcel - 'Invalid cell coordinate o1'

I'm generating a code that can read both ".xls" (Excel5) and ".xlsx" files (Excel2007) and it's funny, because the process I've generated gets the data from the ".xls" file correctly, but without However, if I try to read the data of the same do...
asked by 01.09.2017 / 08:53
2
answers

Loop using PHPExcel

Good I attach my doubt, in an image, since I believe that it will be better. Greetings EDIT: The order of the Client's Actions will not always be like that, I mean It may be that the client Pedro Sell, then Buy, then Sell ... etc...
asked by 07.09.2017 / 17:08
0
answers

PHPExcel gives me error when adding include / require to other files

Based on the following example of codedrinks to create an excel file with data that I bring from BD I can get everything right, the excel is created and I can open it without problems, the sample code has a unique require_once 'lib/PHPExcel/...
asked by 23.08.2017 / 18:14
0
answers

Separate text by the pipe character: | in PHPExcel

I need a PHPExcel function to separate my text into columns delimited by the pipe character | , I've been looking for a lot, and since I'm new using PHPExcel, it's hard for me to find the answer. Thank you for your attention.     
asked by 18.07.2017 / 20:50
1
answer

Problems with PHPExcel

I'm trying to modify a excel with php, once I change what I need I'm supposed to save it, once I save it, then the problem arises that when I download it and open it, it tells me what next: Being that I do not make any change I o...
asked by 22.05.2017 / 22:52
0
answers

Error saving an excel with PHP excel

I'm trying to modify an excel template using php and when I try to save the file it sends me this error:    Fatal error: Uncaught PHPExcel_Exception: Invalid cell coordinate   CHUY1 in   C: \ xampp \ htdocs \ SiGGa \ lib \ PHPExcel \ Classes...
asked by 11.05.2017 / 16:44
1
answer

Change path to save a file created with PHPExcel

I use the PHPExcel library to create an excel file with data from a DB, the problem is that it saves the excel generated in the server path where the php file that generated it is, the following code is a fragment of what I use, I would like to...
asked by 09.05.2017 / 22:52
1
answer

PHPExcel Report with subtotal and total

It happens that I execute this query to export to Excel the information: SELECT IFNULL(s.id_servicio,'Total') AS id_servicio, IFNULL(s.fecha_servicio,'General') AS fecha_servicio, c.nombre_conductor,c.apellido_conductor,...
asked by 12.01.2018 / 05:25
1
answer

Import an excel document to mysql using php

I'm looking at how to upload a CSV file and xlsx to a MySQL database from PHP strong>. I've already researched Google and I've taken the examples they give but they do not work for me. What happens is that I'm in charge of the form...
asked by 11.01.2017 / 19:14