c# 读取excel 单元格内容被截断

[wangjiaping1126]

代码
string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\\303-171.xlsx;Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1;\"";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();
OleDbDataAdapter myCommand1 = new OleDbDataAdapter(strCom, myConn);
ds1 = new DataSet();
myCommand1.Fill(ds1, "[HcmServlet5419475b_LCC 2nd sour$]");
myConn.Close();

问题如题，
excel中某个单元格内容如下
C10; C11; C12; C13; C14; C144; C15; C150; C151; C153; C154; C155; C158; C159; C16; C161; C162; C164; C165; C167; C168; C17; C170; C18; C190; C191; C193; C194; C195; C196; C197; C198; C199; C200; C201; C204; C205; C207; C208; C209; C21; C210; C211; C212; C213; C214; C218; C219; C22; C221; C222; C223; C224; C225; C226; C227; C234; C235; C237; C238; C239; C24; C240; C241; C242; C246; C248; C249; C25; C250; C251; C252; C253; C256; C257; C258; C259; C26; C260; C27; C28; C29; C30; C31; C327; C333; C334; C336; C337; C338; C341; C342; C344; C345; C347; C348; C35; C350; C351; C353; C36; C38; C39; C40; C41; C42; C43; C44; C506; C507; C508; C509; C51; C510; C52; C522; C523; C54; C55; C56; C57; C58; C588; C589; C59; C590; C591; C63; C65; C66; C67; C68; C69; C7; C70; C73; C74; C75; C76; C77; C8; C84; C865; C866; C867; C868; C869; C870; C871; C874; C882; C883; C884; C885; C886; C887; C888; C889; C890; C891; C892; C893; C894; C895; C896; C897; C898; C899; C900; C901; CATE4
从datatable中查看，被截断成
C10; C11; C12; C13; C14; C144; C15; C150; C151; C153; C154; C155; C158; C159; C16; C161; C162; C164; C165; C167; C168; C17; C170; C18; C190; C191; C193; C194; C195; C196; C197; C198; C199; C200; C201; C204; C205; C207; C208; C209; C21; C210; C211; C212; C

[yalan]

我测试的没问题


附程序源码：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace testcheckbox
{
    public partial class excel : Form
    {
        public excel()
        {
            InitializeComponent();
        }

        private string xlsname = string.Empty;
        DataSet ds = new DataSet();
        private void toolStripLabel1_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "EXCEL文件(*.xls)|*.xls";
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                xlsname = ofd.FileName;
            }
            toolStripStatusLabel1.Text = xlsname;
            readxls(xlsname);
        }

        private void readxls(string args_xlsname)
        {
            string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + args_xlsname + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\";";
            toolStripStatusLabel1.Text = connstr;
            using (OleDbConnection conn = new OleDbConnection(connstr))
            {
                using (OleDbDataAdapter da = new OleDbDataAdapter("Select * from [Sheet1$]", conn))
                {
                    da.Fill(ds,"excel");
                }
            }
            dataGridView1.DataSource = ds.Tables["excel"];
        }
    }
}

[yalan]

为了使DataGridView显示全你的数据，我将DataGridView的样式设置为：

在设计模式选中DataGridView1，选择属性，设置DefaultCellStyle属性里的WrapMode属性,默认为false，设置为true。
设置AutoSizeRowsMode属性为：DisplayedCellsExceptHeaders。

这样就能完全显示你的数据了
其中拖了2个空间，打开选择excel文件的ToolStripLabel1供打开选择文件
toolStripStatusLabel1显示构造的链接字符串是否正确

测试通过，你看看你的代码是否有问题？

[yalan]

请参考：
http://blog.csdn.net/driftboat/archive/2010/03/05/5349945.aspx

[qldsrx]

你已经添加了IMEX=1，所以不会出现截断现象了。
我测试过，的确没有截断，只不过用表格控件显示的时候会截断显示，显示不全，但是原始数据没有问题，DataTable中式正常的。

[打酱油的]

没遇到过这个问题.