C#读取Excel转换为List集合

//读取Excel文件

public static DataTable ReadExcelToTable(string path)//excel存放的路径
{
   
	try
	{
   
	
		//连接字符串
		string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";
		
		using (OleDbConnection conn = new OleDbConnection(connstring))
		{
   
			conn.Open();
			//读取sheetName
			DataTable sheetsName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object