如何将数据从Excel添加到Mysql数据库（没有EXCEL tabel标题） [英] How to add data from Excel to Mysql Database (without EXCEL tabel header)

问题描述

大家好......



我正在做我的项目员工详细信息的模块之一。在那个模块中我有一个问题。

i希望使用c＃将数据从excel添加到MySQL数据库 - Windows Application--（没有Excel列标题），我的Excel结构如下。

Hi all...

i am doing one of the module of my project Employee Details. In that module i have one problem.
i want add the Data from excel to MySQL database using c#--Windows Application-- (without Excel Column Header), my Excel structure is below.

---------------------------------------
name   |  age   |   address |  phone
---------------------------------------
xxx    |  45    |    kkk    | 258
uuu    |  41    |     58    | 852
---------------------------------------

i只添加Excel数据，忽略所有列标题，我正在尝试多种方式但不是得到正确的解决方案。



请帮助我...

i am only add the Excel Data,ignore all Column Header's, i am trying many way's but not getting the correct solution.

please help me...

推荐答案

虽然不是确切的事情您正在寻找但仍然可以看看这个



import-from-excel-header-is-not-on-row-1 [ ^ ]

<同时我会尝试为此找到更准确的答案。

并告诉我上述链接是否适用于你...

Although it's not the exact thing which you are looking for but still you can have a look at this

importing-from-excel-header-is-not-on-row-1[^]

meanwhile i will try to find more accurate answer for this.
and let me know if the above link works for u...

这篇关于如何将数据从Excel添加到Mysql数据库（没有EXCEL tabel标题）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！