Advertisement

从Excel读取数据至DataSet中使用OleDb

阅读量:
复制代码
 public static DataSet ToDataTable()

    
     {
    
         string connStr = " ";
    
         OpenFileDialog openFile = new OpenFileDialog();
    
         openFile.Filter = "Excel(*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
    
         openFile.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
    
         openFile.Multiselect = false;
    
         if (openFile.ShowDialog() == DialogResult.Cancel) return null;
    
         var filePath = openFile.FileName;
    
         string fileType = System.IO.Path.GetExtension(filePath);
    
         if (string.IsNu

全部评论 (0)

还没有任何评论哟~