使用excel / CSV中的数据自动填充第三方网站 [英] Auto fill a third party web site with the data from excel /CSV

问题描述

伙计



我有一个要求。



我们必须填写一个网站（例如名称，地址，年龄一次）来自Excel数据源，其中列出了约100名学生的姓名，地址和年龄。目前我们正在逐一完成这项工作，例如查看Excel工作表中的第一个学生并填写网站，然后单击保存按钮，然后转到Excel工作表的下一行。





这是非常耗时的，并且已成为我们必须做一些事情来实现自动化的问题。我已经在网上（谷歌）寻找没有太多运气的任何提示，如果有人可以解决一些问题会很棒吗？



提前感谢您的帮助，每个提示/帮助都会非常感激。

Guys

I have a requirement.

We have to fill a web site (Eg Name,Address,age one at a time) from an excel data source where the name,address,age of about 100 students are listed. Currently we are doing this one by one like looking at the first student in the excel sheet and fill in the web site then click on the save button and then go on to the next row in the excel sheet.


This is very time consuming and has became an issue where we have to do some thing to automate. I have looked online (google) for any tip without much luck and will be great, if some one could shed some light ?

thanks in advance for your great help, each and every tip / help will be very much apprecited.

推荐答案

您可以将您的Excel导入到Datagrid，在提交时，您可以将数据从Datagrid转换为xml和使用存储过程保存在数据库中。



要将Excel导入Datagrid示例代码，有许多链接可用



http：//www.c -sharpcorner.com/uploadfile/ankurmee/import-data-from-excel-to-datagridview-in-C-Sharp/ [ ^ ]



http://csharp.net-informations.com/datagridview/csharp-datagridview-load-excel.htm [ ^ ]

You can import your excel to Datagrid and on submit, you can convert the data from Datagrid to xml and save in Database using Stored Procedures.

For importing Excel to Datagrid sample code, there are many links available

http://www.c-sharpcorner.com/uploadfile/ankurmee/import-data-from-excel-to-datagridview-in-C-Sharp/[^]

http://csharp.net-informations.com/datagridview/csharp-datagridview-load-excel.htm[^]

这篇关于使用excel / CSV中的数据自动填充第三方网站的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！