Question

如何读取CSV文件到DataTable中,然后存到数据库

Answer 1

/// <summary>
        /// 读取Excel文件为DataTable，使用Aspose.Cells.dll
        /// </summary>
        /// <param name="filepath"> Excel文件的全路径 </param>
        /// <returns> DataTable</returns>
        public static DataTable ExcelToDataTable(string filepath)
        {
            DataTable dt = new DataTable();
            try
            {
                if (!File .Exists(filepath))
                {
                    MessageBox.Show(@"文件不存在！" ,@"提示");
                    return null ;
                }
                Aspose.Cells. Workbook workbook = new Aspose.Cells.Workbook();
                workbook.Open(filepath);
                Aspose.Cells. Worksheet worksheet = workbook.Worksheets[0];
                dt = worksheet.Cells.ExportDataTable(0, 0, worksheet.Cells.MaxDataRow + 1, worksheet.Cells.MaxColumn + 1, true );//showTitle  
                return dt;
            }
            catch (System.Exception e)
            {
                return null ;
            }
        }

存数据库就自己写吧，数据都有了