使用vb.net从Excel导出到Datatable

问题描述:

Hai to all,

我在将数据从excel导出到数据表时遇到问题。在我的Excel工作表中,我有3列,如1,2,3,这些列包含像12.30这样的分数。如果我从excel检索数据到数据表,它正确地显示数据,如12.30的1和3列,但它不会显示分数中的第二列数据,它显示第二列数据,如12.3。特定列2上缺少0。请给我任何建议。

Hai to all,
I have a problem on Export data from excel to a data table. In my excel sheet i have 3 columns like 1,2,3, these columns are contains the fraction numbers like 12.30. If i retrieve data from excel to data table it shows the data correctly like 12.30 for 1 and 3 columns but it wont show the 2 nd column data in fraction number it shows the 2nd column data like 12.3. the "0" is missing on a particular column "2". any suggestions please.

你需要从选择查询或数据表中将分数转换为字符串均值12.30到12.30。
U need to convert fraction to string mean 12.30 to "12.30" from select query or data table.