Upload Excel in MySQL using Phpspreadsheet in CodeIgniter

Поделиться
HTML-код
  • Опубликовано: 16 ноя 2024

Комментарии • 29

  • @narheben
    @narheben 3 года назад +2

    You help me so much, I really love this. I suffered from several libraries but you just saved me. Thanks again

  • @aymenlejmi1087
    @aymenlejmi1087 Год назад

    thank you for the video, in fact i want to apply some security check in my columns, how can i proceed ?

  • @NoniGopalChandro
    @NoniGopalChandro Год назад

    where is the "PhpSpreadsheet"? i don't found "PhpSpreadsheet" into your source code. can you please let me know where i have to upload "PhpSpreadsheet"? thanks.

  • @ibrahimkhan7867
    @ibrahimkhan7867 3 года назад

    Very very useful video thank you for so much for sharing an amazing video

  • @mert7349
    @mert7349 2 года назад

    Very very very very useful video thank you for so much 💗

  • @vivekjalankar6647
    @vivekjalankar6647 2 года назад

    Thank you so much for tutorial finally my bug solved

  • @ashishnath9121
    @ashishnath9121 2 года назад

    Can you please tell me how to upload xlsx file as json in mysql with the help of phpspreadsheet in core php. I am not familiar with codeignitor🙏🙏🙏🙏

  • @PratikBhuva
    @PratikBhuva 3 года назад +1

    I tried the step metioned in your tutorial and works fine on localhost but when uploaded on webserver it doesn't work. why? anyidea?

    • @Shumi_Desu
      @Shumi_Desu 2 года назад

      Same, I tried it to a centos server and $_Post was empty. Did you able to fixed it?

  • @Aflover1st
    @Aflover1st 2 года назад

    Thank you so much for your tutorial, it really helps me!

  • @belajarcoding6657
    @belajarcoding6657 Год назад

    thank you, your really help me

  • @rizkyfadillah3928
    @rizkyfadillah3928 Год назад

    truly helpfull, thanks

  • @SunilKumar-lf2nd
    @SunilKumar-lf2nd 9 месяцев назад

    Gracias

  • @ekamelndsr
    @ekamelndsr Год назад

    thank you so muchhh

  • @ainunnafil6331
    @ainunnafil6331 2 года назад

    thank you so much for this video!

  • @bangretz6450
    @bangretz6450 2 года назад

    thank you so much for video!

  • @BSVCREATION45
    @BSVCREATION45 3 года назад

    Hello mam i am using phpexcel library not phpspreadsheet bu i am faceing issue in reading my file can you please help me

  • @proxygulshan
    @proxygulshan 3 года назад

    getting error ,
    Severity: Notice
    Message: Trying to access array offset on value of type int
    Filename: Cell/DefaultValueBinder.php
    Line Number: 56

  • @anandgupta8375
    @anandgupta8375 3 года назад

    how to import excel file with images into database ??

  • @pradeepkushwaha788
    @pradeepkushwaha788 3 года назад

    Please cashfree payment gateway intigration in laravel i m useing api but token issue please make a vedio..

  • @tanwiralam1813
    @tanwiralam1813 3 года назад

    how to filter duplicate data..?

  • @reynaldiarytumanan1199
    @reynaldiarytumanan1199 2 года назад

    my problem is :The requested URL was not found on this server. when i click submit after choose file. please help me

    • @knowledgethrusters
      @knowledgethrusters  2 года назад

      @Reynaldi Please Check that you have defined route properly and that same function is present in your controller.

    • @reynaldiarytumanan1199
      @reynaldiarytumanan1199 2 года назад

      @@knowledgethrusters thank u, my problem is fixed, but my new problem is I don't know how to import data that has been connected to the database in the form of an integer, for example i have field id_B in table A related id_B in table B. I want to import data to table A, how to make usb data in the form of integers can be read and imported to the database, where the id_B data in excel is in the form of varchar? thank you in advance 🙌

    • @knowledgethrusters
      @knowledgethrusters  2 года назад

      @Reynaldi Ary Tumanan Please try this if you want to convert to integar
      $int = (int)$num;

    • @reynaldiarytumanan1199
      @reynaldiarytumanan1199 2 года назад

      @@knowledgethrusters oh yeah, i will try it

    • @reynaldiarytumanan1199
      @reynaldiarytumanan1199 2 года назад

      @@knowledgethrusters i'm sorry, i don't know how to code this

  • @खुफियापुलिस-ढ3ह

    girl will be girl. she's excel sheet has such stuff that always shuffling in their mind. LOL😃😃

  • @abdallahhussein5997
    @abdallahhussein5997 2 года назад

    How to
    1.protect worksheets and restrict user actions like row and column insertion, deletion, and resizing using php spreadsheet
    2.Protect cells using a lock cell feature to restrict user editing action in selected cells using php spreadsheet
    3.hide formula and set invisible using php spreadsheet