Questions tagged as 'phpexcel'

Tagged questions
5
answers

Import worksheet in text format using PHPExcel

How to import an excel file as the cells in TEXT format code $file_tmp = $_FILES['arquivo']['tmp_name']; try { $FileType = PHPExcel_IOFactory::identify( $file_tmp ); $objReader = PHPExcel_IOFactory::createReader( $FileType );...
asked by 13.11.2014 / 16:25
1
answer

Error with conditional formatting if document opened in Microsoft Office

When applying conditional formatting to a% spreadsheet generated with PHPExcel , it works without problems when the document is open at LibreOffice : $objConditional = new PHPExcel_Style_Conditional(); $objConditional->setConditionType(P...
asked by 07.01.2014 / 23:17
1
answer

Excel spreadsheet with unreadable cells while filtering

I'm creating a spreadsheet of Excel using phpExcel() . When placing filters, the result of cell C3 and C4 where subtotal SUBTOTAL() is found looks like this: No filter WithFIltro Does anyone know why...
asked by 22.02.2017 / 18:57
2
answers

PHPExcel generates broken worksheet [closed]

I'm using the PHPExcel class to export a DB table. But I'm having trouble downloading the spreadsheet. To test, insert values manually without doing any select in the DB. But when it generates the spreadsheet and downloads it, the spreadsheet op...
asked by 03.12.2015 / 19:46
1
answer

How to calculate value of one cell only what exceeds the other

What formula would you use to calculate a value above a given number? Example: Area to calculate above 2.00M ². The multiplication value gave 2.75. How do I register in the cell only the 0.75 - and in the same formula there is a value less...
asked by 18.08.2015 / 06:21
2
answers

Export data to Excel using PHP Excel

I'm using the library PHPExcel to export some data from the bank. My problem is for some data types that it places a single quotation mark at the beginning of the number and / or dates ' . In case of date coming from the database w...
asked by 10.03.2015 / 16:56
1
answer

How could I merge the loops below?

This is the spreadsheet: Thisisthecode:publicfunctionloadExcel($file,$dir){$objReader=PHPExcel_IOFactory::createReader('Excel2007');$filterValidation=newApplication_Model_Filter_FilterValidation();if(file_exists($dir.DS.$file)){$objPHPExcel=...
asked by 24.02.2017 / 20:52
1
answer

Export tabbed text in Excel

Hello I need to generate a text file based on this layout to be imported into a system. I'm trying to use Excel, I create the cells with the appropriate sizes as the layout asks. In Excel I go to "save as" and I choose: "Formatted text (se...
asked by 08.06.2017 / 12:12
0
answers

Opening excel in php on different servers

I have an excel file that stays on a server, for example: \192.168.0.1\arquivos\teste.csv And I have an Apache server on another server, for example: \192.168.0.2\www\index.php I want the apache server to put a button to open the file...
asked by 06.12.2018 / 19:12
0
answers

Corrupted File in PHPExcel

When generating the PhpExcel database file, the .xls file is coming corrupted, following image Whatwouldbethemistake,ItriedtofindbutIdonotseeanythingwrong.Followcodes.  ThefollowingPHPcodereceivesdatafromanotherpageofacompletedform.Wheretheuser...
asked by 18.12.2017 / 15:39