Hi Using this code I am able to create a comment in an excel file. $comment = $data_sheet->getCommentByColumnAndRow($col, 1); $comment->setAuthor($table_name . '.' . $field_name); $comment->setWidth('200px'); $comment->setHeight('24px'); $comment->setVisible(false); # ActiveCell.Comment.Visible = True $objCommentRichText = $comm...
Hi Could you please guide me or provide me with some sample codes for performing CSV export and import using the PHPExcel library? Excel export and import is fine but I need csv export/import as well. I have other means of CSV export and import but can it be done via phpexcel also? Any kind of help is greatly appreciated. Thanks in ad...
Hi all, in my application i need to export to xls file in a predefined format. so I just integrated php_excel2007. i am using one template with a predefined format. The problem here is the cell data may change dynamically. if data is much bigger than cell height then data is collapsing. So is ther anyway to increase the height of cell b...
Hi, Is there any alternative for PHP_ecxel. Which can "Export ro Xlsx/xls" file in a customized format. ...
Hi, I am using PHP_excel to export to xlsx. where im using template which has each row with a fixed height of 48. But some times the text within the cell is increases, during which row height doesn't grow even if i use wraptext().So is there any possible way to grow the height of row only in case it has more text. ...
Hi all, i am using php_excel to export to xlsx. In my application im making use of template. When i download, the xlsx file gets downloaded fine, but when we open its showing the following warning: "Excel found unreadable content in 'project_report(3).xlsx'. Do you want to recover the contente of this workbook? If you trust the source o...
Looking for a PHP solution to create Excel files on the fly (Think dynamic reporting). Now I have seen PHP Excel and I know I can create a CSV file but are these by best options? I running this script on a Linux system using PHP Excel but it doesn't set all the options $objPHPExcel->getProperties()->setCreator("Phill"); $objPHPExcel...
Ok I'm dynamically generating the cell coordinates but I get this error, why? Error: Exception: Invalid cell coordinate. in /var/www/test/excel/pe/Classes/PHPExcel/Cell.php on line 490 Call Stack: 0.0003 81132 1. {main}() /var/www/test/excel/createExcelReport.php:0 0.0225 2691000 2. PHPExcel_Worksheet->setCellValue...