Man, thanks so much for this series, it is going to make my life so much easier. I just got tapped for a project at work that this completely fits into.
Great Tutorial - touched on the basics of formatting just perfectly - The only thing that would make it better would have been to have the code either in the description for download, or a url for download....Thanks
Hi, I have a question is there a possibility to search an excel file for a specific value if the column is known. Something like '$excel->getActiveSheet()->getCell('B'.'this_one')->getRow() !=""' rather than $excel->getActiveSheet()->getCell('B'.'120')->getValue() !="" Thank you!
@Gemul Channel, what might be the problem with my code, , the error is "excel cannot open the file "enforce.xlsx" because the file format is not valid..... check code :codeshare.io/aJpoWE
sorry master. im confuse cz its my first time create PHPExcel.. can u show me with ur code in that video. cz im follow full ur code and its succes for me.
thanx sir. but what i want is how to apply ur loop for odd/even to datarender file. i just try like this. but its not work. for($rows = 4; $rows getActiveSheet()->getStyle('A4:I' .($row++%2))->applyFromArray( array( 'fill' => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'ccff99') ) ) ); //$colorState='even'; } };
Do you have documentation of your classes, objects? I have searched and the truth has been difficult to find phpspreadsheet documentation something clear. Well, I'm new to this. I already have it installed on my machine.
Hi, I have a question is there a possibility to search an excel file for a specific value if the column is known. Something like '$excel->getActiveSheet()->getCell('B'.'this_one')->getRow() !=""' rather than $excel->getActiveSheet()->getCell('B'.'120')->getValue() !="" Thank you!
Man, thanks so much for this series, it is going to make my life so much easier. I just got tapped for a project at work that this completely fits into.
Everything that I needed is in this video. Loved it!
Great Tutorial - touched on the basics of formatting just perfectly - The only thing that would make it better would have been to have the code either in the description for download, or a url for download....Thanks
Excellent guidance. Thanks. What plugin in need to download to make it work on wamp.
Very helpful. You saved my time.. Thank you very much.
I have a question, how could I do if need to create a table in a specific cell?
Thanks for the video! I need to just edit the file. That is, altering only the specified columns and keeping the data that was previously there
Hi, I have a question is there a possibility to search an excel file for a specific value if the column is known. Something like '$excel->getActiveSheet()->getCell('B'.'this_one')->getRow() !=""' rather than $excel->getActiveSheet()->getCell('B'.'120')->getValue() !="" Thank you!
Very good and well explained , thank you so much
@Gemul Channel, what might be the problem with my code, , the error is "excel cannot open the file "enforce.xlsx" because the file format is not valid.....
check code :codeshare.io/aJpoWE
even after doing that, same error, I have included the variables $date1 and $date2
Thank you very much.
HI, thx for the video, can we add images with PHPExcel?
thank you very much
Big thanks!
hello sir.. can i ask u again.. about how to make format %. example 10%. thank you sir.
how export excel table structure like table in side table in php
how about not losing macro vba using a Template with Macro?
Great tutorial, thank you very much! Will you be uploading the next video soon?
Thank you very much :)
Hi i am on symfony3 and i need to upload excel file and insert data on my database how can i do it
Many Thanks, God bless you.
How do i attach this file in email
helpful, thanks!
Thanks a lot man!
how to make alternating color on that data rows.
sorry master. im confuse cz its my first time create PHPExcel.. can u show me with ur code in that video. cz im follow full ur code and its succes for me.
thanx sir. but what i want is how to apply ur loop for odd/even to datarender file.
i just try like this. but its not work.
for($rows = 4; $rows getActiveSheet()->getStyle('A4:I' .($row++%2))->applyFromArray(
array(
'fill' => array(
'type' => PHPExcel_Style_Fill::FILL_SOLID,
'color' => array('rgb' => 'ccff99')
)
)
);
//$colorState='even';
}
};
i didnt see it sir
its work sir.. thank you for ur help.. keep it up, ill watching :D
can u share this code pls
hey hii gemul i have use your code on live server not working after hosting
phpexcel working perfect on localhost not working after hosting it seems to say page 500 error
This page isn’t working
currently unable to handle this request
HTTP ERROR 500
getting this error
codeshare.io/aJpoWE
PHPExcel is deprecated...
Does this mean it will no longer work in Excel eventually? Wondering if this will still work for my purposes. Thanks!
Do you have documentation of your classes, objects? I have searched and the truth has been difficult to find phpspreadsheet documentation something clear. Well, I'm new to this. I already have it installed on my machine.
Hi, I have a question is there a possibility to search an excel file for a specific value if the column is known. Something like '$excel->getActiveSheet()->getCell('B'.'this_one')->getRow() !=""' rather than $excel->getActiveSheet()->getCell('B'.'120')->getValue() !="" Thank you!
Thanks a lot for this !!