PHPExcel : Working With Excel Spreadsheet in PHP #4 Fetching Data from Excel File + Upload

Поділитися
Вставка
  • Опубліковано 18 вер 2024

КОМЕНТАРІ • 41

  • @ChathuraLy
    @ChathuraLy 3 роки тому

    Superb..! Thank you Very Much..!!

  • @dhruvgohel2598
    @dhruvgohel2598 3 роки тому

    Its So informative And Please pull video of encrypted file video

  • @Curious_Crime_Files
    @Curious_Crime_Files 5 років тому

    So informative. Thank you very much.

  • @Tamilmoon_Vijay
    @Tamilmoon_Vijay 5 років тому

    helped a lot.. thank you so much

  • @paulsweet6474
    @paulsweet6474 11 місяців тому

    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

  • @pratikchavan3603
    @pratikchavan3603 4 роки тому

    how can i get row count() of excel file ...? any inbuild function..which will omit empty rows and only count rows having data?

  • @williamalvarez6342
    @williamalvarez6342 7 років тому

    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.

  • @amirhazwan2074
    @amirhazwan2074 5 років тому

    can we obtain data from specific row and column only in an excel?

  • @trikaal4105
    @trikaal4105 4 роки тому

    Hi, can i use it to import questions, in a online exam syatem

  • @Shadow-yv1vs
    @Shadow-yv1vs 6 років тому

    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?

  • @ervinbartha
    @ervinbartha 6 років тому +1

    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

  • @arkadiusz3618
    @arkadiusz3618 4 роки тому

    Where I can find source of your "datafetch.php" file?

  • @dmw4176
    @dmw4176 5 років тому

    If you have images in the spreadsheet can you load those as well?
    D

  • @tusharharel2890
    @tusharharel2890 5 років тому

    how to fetch different sheets using phpexcel library

  • @Shadow-yv1vs
    @Shadow-yv1vs 6 років тому

    And also how can i pull data from different sheet in 1 xlsx file?

  • @harryang2333
    @harryang2333 7 років тому

    Can i create spreadsheet in php?? Exemple like google sheets??

    • @harryang2333
      @harryang2333 7 років тому

      Gemul Channel thanks for ur answer mate
      Btw ur video so helpful

  • @gagantous
    @gagantous 7 років тому

    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

    • @gagantous
      @gagantous 7 років тому

      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 ?

    • @gagantous
      @gagantous 7 років тому

      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

  • @simoneji3245
    @simoneji3245 7 років тому

    Hey,i want to load an xls file and then modify it.How i can make this.Thanks a lot

  • @maksimpa200
    @maksimpa200 6 років тому

    Fatal error: Out of memory