JavaScript xlsx file upload

Question

How can i do xlsx file upload from web page to server ? I have issue about read Excel file. I have a php code but i need upload file from web page to my server . Because if i dont upload it, I cannot read file.

this is my php code. In this code i need upload the File.

header('Content-Type: text/plain');

    if (isset($argv[1]))
    {
        $Filepath = $argv[1];
    }
    elseif (isset($_POST['File']))
    {
        $Filepath = $_POST['File'];
    }
    else
    {
        if (php_sapi_name() == 'cli')
        {
            echo 'Please specify filename as the first argument'.PHP_EOL;
        }
        else
        {
            echo 'Please specify filename as a HTTP GET parameter "File", e.g., "/test.php?File=test.xlsx"';
        }
        exit;
    }

    // Excel reader from http://code.google.com/p/php-excel-reader/
    require('php-excel-reader/excel_reader2.php');
    require('SpreadsheetReader.php');

    date_default_timezone_set('UTC');

    $StartMem = memory_get_usage();


    try
    {
        $Spreadsheet = new SpreadsheetReader($Filepath);
        $BaseMem = memory_get_usage();

        $Sheets = $Spreadsheet -> Sheets();


        //print_r($Sheets);
        $TabloArray=array();
        $Satir=array();

        foreach ($Sheets as $Index => $Name)
        {


            $Time = microtime(true);

            $Spreadsheet -> ChangeSheet($Index);

            foreach ($Spreadsheet as $Key => $Row)
            {
                //echo $Key.': ';
                if($Key==0)
                {


                    continue;
                }
                if ($Row)
                {
                    $Satir['Isim']=$Row[0];
                    $Satir['SoyIsim']=$Row[1];
                    $Satir['Yas']=$Row[2];
                    $TabloArray[]=$Satir;
                }
                else
                {
                    var_dump($Row);
                }
                $CurrentMem = memory_get_usage();
            }



        }
        print_r(json_encode($TabloArray));

    }
    catch (Exception $E)
    {
        echo $E -> getMessage();
    }

And JavaScript code for read

json_obj = $.parseJSON(veri);//parse JSON
for(var i in json_obj)
    {
        Isimler[i]=json_obj.Isim;
        SoyIsim[i]=json_obj.SoyIsim;
        Yas[i]=json_obj.Yas;
        var Table=document.getElementById("tablo_icin2");
        var td = document.createElement("td");
        var tr=document.createElement("tr");
td.appendChild(document.createTextNode(json_obj[i].Isim));
                tr.setAttribute("id","element"+i);
                tr.appendChild(td);
                td = document.createElement("td");
td.appendChild(document.createTextNode(json_obj[i].SoyIsim));
                tr.appendChild(td);
                td = document.createElement("td");
td.appendChild(document.createTextNode(json_obj[i].Yas));
                tr.appendChild(td);
                Table.appendChild(tr);
}

Vitalii Andrusishyn · Accepted Answer · 2016-08-19 09:08:23Z

1

Use parser: If you want read file by JavaScript you can use https://github.com/SheetJS/js-xlsx for it. It you want read file by php you can use https://github.com/PHPOffice/PHPExcel/tree/develop/Documentation after upload you file as simple file.

answered Aug 19, 2016 at 9:08

Vitalii Andrusishyn

4,2121 gold badge28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Somomo1q Over a year ago

I dont need NodeJs i need JavaScript so i am using this code in my page not server

user5336527 · Accepted Answer · 2016-08-19 08:56:28Z

1

Why not just upload the file to the server and save its path to the database. And then when you want to read it, fetch the path from database relative to the upload folder of the excel file.

answered Aug 19, 2016 at 8:56

user5336527

6 Comments

Somomo1q Over a year ago

How can i do upload excel file to the server ?

user5336527 Over a year ago

Take a look at this link

Somomo1q Over a year ago

there is nothing about upload excel file from web page to server

user5336527 Over a year ago

Are you sure? the upload script is included in his post.

user5336527 Over a year ago

Get the filename and the path where to save the excel file and then save filename + filepath to your database.

|

Collectives™ on Stack Overflow

JavaScript xlsx file upload

2 Answers 2

1 Comment

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related