需求实现:点击浏览按钮选择(*.xlsx)文件将图1Excle内容导入图2C1FlexGrid页面中。成功后,选择自己需要的每条数据前选中√,点击导入按钮保存到Oracle数据库中。各种查找只有一个例子但是不能代入:代码及运行如下
void _btnLoadSheet_Click(object sender, System.EventArgs e)
{
// choose file
OpenFileDialog dlg = new OpenFileDialog();
dlg.DefaultExt = "xls";
dlg.FileName = "*.xls";
if (dlg.ShowDialog() != DialogResult.OK)
return;
// clear data source, if any
_flex.DataSource = null;
string[] sheets = _flex.LoadExcelSheetNames(dlg.FileName);
Console.WriteLine("Found {0} sheets in this book.", sheets.Length);
foreach (string sheet in sheets)
{
Console.WriteLine(" - {0}", sheet);
}
// load the first sheet in the book
FileFlags flags = (_chkFixed.Checked)? FileFlags.IncludeFixedCells: FileFlags.None;
_flex.LoadGrid(dlg.FileName, FileFormatEnum.Excel, flags);
}
,其他的都是C1FlexGrid导出到Excel中。各位大神们帮帮忙啦,怎么才能实现我的需求呢!
|