/// <summary>
/// 查看Excel文件并显示在界面上操作
/// </summary>
private void ViewData()
{
if (this.txtFilePath.Text == "")
{
MessageDxUtil.ShowTips("请选择指定的Excel文件");
return;
}
try
{
myDs.Tables.Clear();
myDs.Clear();
this.gridControl1.DataSource = null;
string error = "";
AsposeExcelTools.ExcelFileToDataSet(this.txtFilePath.Text, out myDs, out error);
this.gridControl1.DataSource = myDs.Tables[0];
this.gridView1.PopulateColumns();
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}