本文介绍了合并数据集中的单元格Excel问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用Visual Studio 2008创建Windows窗体应用程序.
我正在像这样阅读excel
I am creating a Windows Forms Application using Visual Studio 2008.
I am reading excel like this
string strQuery = "Select * from [{0}]";
OleDbCommand cmd = new OleDbCommand(string.Format(strQuery, strSheetName));
cmd.Connection = connection;
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
adapter.Fill(dataSet, (string)strSheetName);
但是合并单元格未显示数据.像cell [5,4]具有"x",并且在这种情况下与cell [6,4]合并,因此cell [6,4]为空白,我希望重复数据.任何人都遇到了这个问题,请帮忙.
But merge cells are not showing the data. like cell[5,4] has "x" and which is merged with cell[6,4] in this condition cell[6,4] is blank where i want the data to be repeated. anyone got this problem please help.
推荐答案
这篇关于合并数据集中的单元格Excel问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!