帮助解释/实施“从Excel复制/粘贴到网页”回答？ [英] Help interpret/implement "Copy/Paste from Excel to a web page" answer?
问题描述
我可以通过以下方式获得解释/实现答案的一些帮助：
从Excel复制/粘贴到网页？
这是Google为将Excel粘贴到网页 / form - 似乎完美，但我无法上班。
（要求是给用户一个在Excel中预先填充信息的选项，当准备好将请求粘贴到我们服务器上的表单中。）
我继承了一个服务器在工作中与
WAMP 2.0
Apache 2.2.11
PHP 5.2.9
我对Excel中的VBA很公平。新手在PHP。教程和基本形式工作正常，使用Eclipse IDE。
在答案中尝试代码 - d / l'd jquery并设置代码中的路径。 jquery的教程示例似乎有效。
Tatu Ulmanen的答案给了我一个解析错误
var data = $（'input [ name = excel_data]'）val（）;
相关的
/ insert into DOM ？
$（'＃excel_table'）。html（table）;
不知道这是什么意思。 >
Mic的答案没有发生错误，但转换按钮不做任何事情。
想法/方向？
鉴于您是指我的原始答案，也许我可以给您一些关于如何工作的见解
我不得不对原来的答案进行一些修改（textarea而不是输入），但该代码工作所需的完整HTML如下所示：
<！DOCTYPE html PUBLIC - // W3C // DTD XHTML 1.0 Transitional // EN
http：/ /www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
< html>
< head>
< script type =text / javascriptsrc =http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js>< / script>
< script type =text / javascript>
$（function（）{
$（'textarea [name = excel_data]'）。keyup（function（）{
var data = $（this）.val（）;
var rows = data.split（\\\
）;
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>
该代码将生成您粘贴到textarea中的任何excel数据的HTML表。
请注意，这不需要任何PHP正常工作。如果要保存数据，则必须创建一个将数据提交到PHP脚本的表单，该脚本将对 excel_data 字段中的数据进行类似的解析。
现在，当您从Excel中的 excel_data 字段中粘贴某些内容时，生成的表应显示在 excel_table div。
Can I get some help interpreting / implementing the answers at: Copy/Paste from Excel to a web page please?
This was the most useful answer Google found for "Paste Excel to Web Page/Form" -- seems perfect but I can't get to work.
(Requirement is to give users an option to pre-populate information in Excel, and when ready to submit a request paste into a form on our server.)
I "inherited" a server at work with
WAMP 2.0 Apache 2.2.11 PHP 5.2.9
I'm fair with VBA in Excel. Newbie at PHP. Tutorial and basic forms working okay, using Eclipse IDE.
Tried code in answers -- d/l'd jquery and set the path in the code. Tutorial examples for jquery seem to work.
Tatu Ulmanen's answer gives me a Parse error on "var data = $('input[name=excel_data]').val();"
Related to
// Insert into DOM ?
$('#excel_table').html(table);
Don't know what that means.
Mic's answer gives no error, but the convert button doesn't do anything.
Ideas / direction? Please?
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">
<html>
<head>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<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.
这篇关于帮助解释/实施“从Excel复制/粘贴到网页”回答？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
