使用 OleDBDataReader 读取 Excel 未检索所有标题列单元格内容

发布于 2024-11-26 15:36:10 字数 610 浏览 2 评论 0原文

我有一个 Excel 工作表，用于填充数据库中的数据。看起来 OleDBDataReader 在截断其余字符之前实际上只从列标题中读取一定数量的字符。

有办法解决这个问题吗？

我如何检索列标题：

OleDbCommand oleDbCommand = new OleDbCommand("select * from [sheet1$]",
OleDbConnection);
OleDbDataReader reader = oleDbCommand.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(reader);

foreach (DataColumn column in dataTable.Columns)
{
string columnName = column.ColumnName;
}

预期结果：满足学生福利需求的有针对性的计划。例如早餐俱乐部

实际结果：有针对性的计划来满足学生的福利需求。例如 br

我也尝试使用 reader.GetName(i) 方法来检索具有相同结果的信息。

原文

I have an Excel sheet that I am using to populate data in a Database. It seems as though there is only a certain number of characters that the OleDBDataReader actually reads in from a column heading before truncating the rest.

Is there a way around this?

How I am retrieving the column headings:

OleDbCommand oleDbCommand = new OleDbCommand("select * from [sheet1$]",
OleDbConnection);
OleDbDataReader reader = oleDbCommand.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(reader);

foreach (DataColumn column in dataTable.Columns)
{
string columnName = column.ColumnName;
}

Expected result: Targeted programs to address the welfare needs of students. E.g breakfast clubs

Actual Result: Targeted programs to address the welfare needs of students. E.g br

I have also tried using the reader.GetName(i) method to retrieve the information with the same result.

分享到QQ

分享到微博