如何将数据从excel复制到网页表单？ [英] how to copy data from excel to webpage form?

问题描述

有谁知道以下是否可能？


我有一个excel电子表格，其值必须转移到某个网站的表格。例如，我在excel电子表格xyz中有一个值，我想转移到同时打开的网页上的数据输入框。基本上我想让它变得简单，只需按一下按钮，我就可以将我的所有数据复制/粘贴到另一个表单中。


或者，我想可以在我的本地硬盘上保存一个网页，其中包含脚本以方便这个过程吗？


目的这个想法是试图通过数据输入节省时间。我可以快速有效地将原始数据输入到Excel中，并且可以将excel文件用于其他内部数据分析。我无法访问相关网页，因为它是由第三方供应商设计的。因此我的问题。


我是这个东西的超级业余爱好者，所以我知道我的想法很可能太麻烦了，而且可能有办法更有效地完成这一切。


i会很感激帮助。

解决方案

我认为你这样做会有很多麻烦（事实上我认为这可能是不可能的。


我在我的某个网站上做了类似的事情，但它控制了网站，Excel电子表格保存为CSV文件，然后上传到CGI脚本（在这种情况下是PHP），这个脚本加载数据并执行所需的操作（将其保存在数据库中）。


但我无法想办法在没有网站控制的情况下这样做。

是的，.csv'似乎只是我能找到的解决这个问题的解决方案。我想我真正想要完成的是访问带有数据输入字段的网页，并使用保存在我的硬盘上的文件中的值自动填充这些字段。啊搞砸了。也许我会尝试自学PHP或其他东西。 ：P thx求助。

我也需要同样的问题。我有一个页面，其中有N个字段用于输入数据...用户必须输入该页面中的所有详细信息才能导航到下一页。因为所有字段都是强制性的。但是我不能保留字段也可选。我需要所有的信息。我想进行自动化，即从Excel工作表数据更新表单。因此，数据输入对用户来说会更容易。

在这方面帮助我。


提前付款

Devu

Hi does anyone know if the following is possible?

I have an excel spreadsheet with values that i need transferred to a certain website''s form. for instance, i have a value in excel spreadsheet xyz that i wanted to transfer to a data entry box on a webpage that is concurrently open. basically i want to make it simple enough that at a push of a button, i can copy/paste all my data into another form.

alternatively, i guess could have a webpage saved on my local harddrive, that would contain script to facilitate this process?

the purpose of this idea is to try to save time with data entry. i could enter raw data onto excel quickly and efficiently, and the excel file could be put to use for other internal data analysis. i don''t have access to the webpage in question, as it was desgined by a third party vendor. hence my question.

i''m SUPER amateur at this stuff, so i know my idea will most likely be too cumbersome and there is probably a way to do all this alot more efficiently.

i would appreciate the help.

解决方案

I think you will have a lot of trouble doing this (in fact I think it is probably impossible).

I do something similar on one of my sites but it envolves having control of the site, the Excel spreadsheet is saved as a CSV file which is then uploaded to a CGI script (PHP in this case) and this script loads the data and performs the required action (saves it in a database).

However I can not think of a way to do this without control of the website.

yea, .csv''s seem to be only solution i can find that comes close to solving this problem. i guess what i''m really trying to accomplish is to access a web page with data entry fields and autopopulate those fields with values from a file saved on my hard drive. ah screw it. maybe i''ll try teaching myself php or something. :P thx for ur help.

I am also in need of the same issue. I have a page which has N number of fields to enter data...and the user has to enter all the details in that page to navigate to the next page.since all the fields are made as mandatory.But i cant keep the field as optional also. I need all the information. I want to make automate, ie updating the form from the excel sheet data. So that the data entry will be easier to the user.
Help me in this regard.

Thanks in Advance
Devu

这篇关于如何将数据从excel复制到网页表单？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！