Hi, love your videos, thank you. Just wondering is it possible to replace letters and number with variables i.e. $spreadsheet->getActiveSheet()->getStyle('A3:P14') to $spreadsheet->getActiveSheet()->getStyle($letter1 . $letter2:$topcell . $bottom_cell) thank you for any help
How can i sort the numerical data after fetching? which code and where i have to use the sort function? I want to sort the xlsx data after fetching by numerically. But the test.xlsx file should be same. it shows the sorted data in the browser. How can i do that?
Good afternoon, today I have a query because I am using the columns from the A6 to bf6 and I am registering 1400 rows the system shows me an error regarding the cache to enlarge the size of the file from 1MB to 64MB and also the time of the cache it Pass from 600 to 2000, but still making mistakes. I would appreciate your valuable collaboration.
can you upload tutorial how to merge the cell in hmtl view ? ex: i had table in excel that already had merged, but when i am try to fetch the data from excel data file to html view, the merge was missing, the row seems appear but with blank row that not merged. and sorry for my bad english
yes, i have checked that thread, and i found it usefull, it's return "cel merged", but what i must do is how to include that or inside my looping data ?
![Ice On My Teeth - ATEEZ エイティーズ 에이티즈 [Music Bank] | KBS WORLD TV 241115](http://i.ytimg.com/vi/c-n92OgbbwA/mqdefault.jpg)
Hi, love your videos, thank you. Just wondering is it possible to replace letters and number with variables i.e.
$spreadsheet->getActiveSheet()->getStyle('A3:P14') to
$spreadsheet->getActiveSheet()->getStyle($letter1 . $letter2:$topcell . $bottom_cell)
thank you for any help
Superb..! Thank you Very Much..!!
Its So informative And Please pull video of encrypted file video
how can i get row count() of excel file ...? any inbuild function..which will omit empty rows and only count rows having data?
can we obtain data from specific row and column only in an excel?
There is any chance to download the code if I want use it in my form? I am using already phpexcel class to download data from mssql, thanks
Thank you for it!
Hi, can i use it to import questions, in a online exam syatem
How can i sort the numerical data after fetching? which code and where i have to use the sort function? I want to sort the xlsx data after fetching by numerically. But the test.xlsx file should be same. it shows the sorted data in the browser. How can i do that?
So informative. Thank you very much.
Where I can find source of your "datafetch.php" file?
Good afternoon, today I
have a query because I am using the columns from the A6 to bf6 and I am
registering 1400 rows the system shows me an error regarding the cache
to enlarge the size of the file from 1MB to 64MB and also the time of
the cache it Pass from 600 to 2000, but still making mistakes. I would appreciate your valuable collaboration.
If you have images in the spreadsheet can you load those as well?
D
helped a lot.. thank you so much
how to fetch different sheets using phpexcel library
And also how can i pull data from different sheet in 1 xlsx file?
can you upload tutorial how to merge the cell in hmtl view ?
ex: i had table in excel that already had merged, but when i am try to fetch the data from excel data file to html view, the merge was missing, the row seems appear but with blank row that not merged.
and sorry for my bad english
yes, i have checked that thread, and i found it usefull, it's return "cel merged", but what i must do is how to include that
or inside my looping data ?
it's merge, the result was like the data between (ex A3:A6) was missing but in my html view the td element not merged
Can i create spreadsheet in php?? Exemple like google sheets??
Gemul Channel thanks for ur answer mate
Btw ur video so helpful
Hey,i want to load an xls file and then modify it.How i can make this.Thanks a lot
Fatal error: Out of memory
ОК