ansaurus

Question

Help interpret/implement "Copy/Paste from Excel to a web page" answer?

Answer 1

A:

Given that you're referring to my original answer, perhaps I can give you some insight on how it should work.

I had to make few changes to my original answer (textarea instead of input), but the full HTML required for that code to work is as follows:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
<html>
<head>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"&gt;&lt;/script&gt;
    <script type="text/javascript">
    $(function() {
        $('textarea[name=excel_data]').keyup(function() {
            var data = $(this).val();
            var rows = data.split("\n");
            var table = $('<table />');    
            for(var y in rows) {
                var cells = rows[y].split("\t");
                var row = $('<tr />');
                for(var x in cells) {
                    row.append('<td>'+cells[x]+'</td>');
                }
                table.append(row);
            }
            $('#excel_table').html(table);
        });
    });
    </script>
</head>
<body>
    <textarea name="excel_data" /></textarea>
    <div id="excel_table"></div>
</body>
</html>

That code will generate a HTML table of whatever excel data you paste into the textarea.

Note that this does not require any PHP to work as it is. If you want to save the data, you must create a form that submits the data to a PHP script which will do similar parsing on the data inside excel_data field.

Now, when you paste something in the excel_data field from excel, the resulting table should appear in the excel_table div.

Tatu Ulmanen 2010-01-30 18:32:08

Thank you Tatu, very much!

KingsKid360 2010-01-30 19:30:03

ansaurus

tags:

views:

answers:

Help interpret/implement "Copy/Paste from Excel to a web page" answer?

related questions