blocks|key|1602640|text|为什么不创建OleDbConnection呢？互联网上有很多可用的资源。下面是一个例子|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1602641|OleDbConnection+con+=+new+OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data+Source="%2Bfilename%2B";Extended+Properties=Excel+8.0");
con.Open();
try
{
+++++//Create+Dataset+and+fill+with+imformation+from+the+Excel+Spreadsheet+for+easier+reference
+++++DataSet+myDataSet+=+new+DataSet();
+++++OleDbDataAdapter+myCommand+=+new+OleDbDataAdapter("+SELECT+*+FROM+["%2Blistname%2B"$]"+,+con);
+++++myCommand.Fill(myDataSet);
+++++con.Close();
+++++richTextBox1.AppendText("\nDataSet+Filled");

+++++//Travers+through+each+row+in+the+dataset
+++++foreach+(DataRow+myDataRow+in+myDataSet.Tables[0].Rows)
+++++{
++++++++++//Stores+info+in+Datarow+into+an+array
++++++++++Object[]+cells+=+myDataRow.ItemArray;
++++++++++//Traverse+through+each+array+and+put+into+object+cellContent+as+type+Object
++++++++++//Using+Object+as+for+some+reason+the+Dataset+reads+some+blank+value+which
++++++++++//causes+a+hissy+fit+when+trying+to+read.+By+using+object+I+can+convert+to
++++++++++//String+at+a+later+point.
++++++++++foreach+(object+cellContent+in+cells)
++++++++++{
+++++++++++++++//Convert+object+cellContect+into+String+to+read+whilst+replacing+Line+Breaks+with+a+defined+character
+++++++++++++++string+cellText+=+cellContent.ToString();
+++++++++++++++cellText+=+cellText.Replace("\n",+"%7C");
+++++++++++++++//Read+the+string+and+put+into+Array+of+characters+chars
+++++++++++++++richTextBox1.AppendText("\n"%2BcellText);
++++++++++}
+++++}
+++++//Thread.Sleep(15000);
}
catch+(Exception+ex)
{
+++++MessageBox.Show(ex.ToString());
+++++//Thread.Sleep(15000);
}
finally
{
+++++con.Close();
}|code-block|syntax|javascript|1602642|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Why don't you create OleDbConnection? There are a lot of available resources in the Internet. Here is an example

<pre><code>OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+filename+";Extended Properties=Excel 8.0");
con.Open();
try
{
 //Create Dataset and fill with imformation from the Excel Spreadsheet for easier reference
 DataSet myDataSet = new DataSet();
 OleDbDataAdapter myCommand = new OleDbDataAdapter(" SELECT * FROM ["+listname+"$]" , con);
 myCommand.Fill(myDataSet);
 con.Close();
 richTextBox1.AppendText("\nDataSet Filled");

 //Travers through each row in the dataset
 foreach (DataRow myDataRow in myDataSet.Tables[0].Rows)
 {
 //Stores info in Datarow into an array
 Object[] cells = myDataRow.ItemArray;
 //Traverse through each array and put into object cellContent as type Object
 //Using Object as for some reason the Dataset reads some blank value which
 //causes a hissy fit when trying to read. By using object I can convert to
 //String at a later point.
 foreach (object cellContent in cells)
 {
 //Convert object cellContect into String to read whilst replacing Line Breaks with a defined character
 string cellText = cellContent.ToString();
 cellText = cellText.Replace("\n", "|");
 //Read the string and put into Array of characters chars
 richTextBox1.AppendText("\n"+cellText);
 }
 }
 //Thread.Sleep(15000);
}
catch (Exception ex)
{
 MessageBox.Show(ex.ToString());
 //Thread.Sleep(15000);
}
finally
{
 con.Close();
}
</code></pre>

blocks|key|1387808|text|使用OLEDB连接与excel文件通信。它提供了更好的结果|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387809|using+System.Data.OleDb;



++++++++++++++++string+physicalPath+=+"Your+Excel+file+physical+path";
++++++++++++++++OleDbCommand+cmd+=+new+OleDbCommand();
++++++++++++++++OleDbDataAdapter+da+=+new+OleDbDataAdapter();
++++++++++++++++DataSet+ds+=+new+DataSet();
++++++++++++++++String+strNewPath+=+physicalPath;
++++++++++++++++String+connString+=+"Provider=Microsoft.ACE.OLEDB.12.0;Data+Source="+%2B+strNewPath+%2B+";Extended+Properties=\"Excel+12.0;HDR=Yes;IMEX=2\"";
++++++++++++++++String+query+=+"SELECT+*+FROM+[Sheet1$]";+//+You+can+use+any+different+queries+to+get+the+data+from+the+excel+sheet
++++++++++++++++OleDbConnection+conn+=+new+OleDbConnection(connString);
++++++++++++++++if+(conn.State+==+ConnectionState.Closed)+conn.Open();
++++++++++++++++try
++++++++++++++++{
++++++++++++++++++++cmd+=+new+OleDbCommand(query,+conn);
++++++++++++++++++++da+=+new+OleDbDataAdapter(cmd);
++++++++++++++++++++da.Fill(ds);

++++++++++++++++}
++++++++++++++++catch
++++++++++++++++{
++++++++++++++++++++//+Exception+Msg+

++++++++++++++++}
++++++++++++++++finally
++++++++++++++++{
++++++++++++++++++++da.Dispose();
++++++++++++++++++++conn.Close();
++++++++++++++++}|code-block|syntax|javascript|1387810|输出数据将存储在dataset中，使用dataset对象可以方便地访问数据。希望这能对你有所帮助|1387811|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Use OLEDB Connection to communicate with excel files. it gives better result

<pre><code>using System.Data.OleDb;



 string physicalPath = "Your Excel file physical path";
 OleDbCommand cmd = new OleDbCommand();
 OleDbDataAdapter da = new OleDbDataAdapter();
 DataSet ds = new DataSet();
 String strNewPath = physicalPath;
 String connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
 String query = "SELECT * FROM [Sheet1$]"; // You can use any different queries to get the data from the excel sheet
 OleDbConnection conn = new OleDbConnection(connString);
 if (conn.State == ConnectionState.Closed) conn.Open();
 try
 {
 cmd = new OleDbCommand(query, conn);
 da = new OleDbDataAdapter(cmd);
 da.Fill(ds);

 }
 catch
 {
 // Exception Msg 

 }
 finally
 {
 da.Dispose();
 conn.Close();
 }
</code></pre>

The Output data will be stored in dataset, using the dataset object you can easily access the datas.
Hope this may helpful

blocks|key|1387847|text|在服务器端应用程序上读取Excel文件的推荐方式是Open+XML。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387848|分享几个链接-|1387849|https://msdn.microsoft.com/en-us/library/office/hh298534.aspx|offset|length|1387850|https://msdn.microsoft.com/en-us/library/office/ff478410.aspx|1387851|https://msdn.microsoft.com/en-us/library/office/cc823095.aspx|1387852|entityMap|0|LINK|mutability|MUTABLE|url|1|2^0|0|0|0|1P|0|0|0|1P|1|0|0|1P|2|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@$F|X|G|Y|1|Z]]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@$F|11|G|12|1|13]]|A|$]]|$1|J|3|K|5|6|7|14|8|@]|9|@$F|15|G|16|1|17]]|A|$]]|$1|L|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|E]]|S|$5|O|P|Q|A|$R|I]]|T|$5|O|P|Q|A|$R|K]]]]

The recommended way to read Excel files on server side app is Open XML. 

Sharing few links -

<a href="https://msdn.microsoft.com/en-us/library/office/hh298534.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/office/hh298534.aspx</a>

<a href="https://msdn.microsoft.com/en-us/library/office/ff478410.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/office/ff478410.aspx</a>

<a href="https://msdn.microsoft.com/en-us/library/office/cc823095.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/office/cc823095.aspx</a>

blocks|key|1602731|text|public+void+excelRead(string+sheetName)
++++++++{
++++++++++++Excel.Application+appExl+=+new+Excel.Application();
++++++++++++Excel.Workbook+workbook+=+null;
++++++++++++try
++++++++++++{
++++++++++++++++string+methodName+=+"";


++++++++++++++++Excel.Worksheet+NwSheet;
++++++++++++++++Excel.Range+ShtRange;

++++++++++++++++//Opening+Excel+file(myData.xlsx)
++++++++++++++++appExl+=+new+Excel.Application();


++++++++++++++++workbook+=+appExl.Workbooks.Open(sheetName,+Missing.Value,+ReadOnly:+false);
++++++++++++++++NwSheet+=+(Excel.Worksheet)workbook.Sheets.get_Item(1);
++++++++++++++++ShtRange+=+NwSheet.UsedRange;+//gives+the+used+cells+in+sheet


++++++++++++++++int+rCnt1+=+0;
++++++++++++++++int+cCnt1+=+0;

++++++++++++++++for+(rCnt1+=+1;+rCnt1+<=+ShtRange.Rows.Count;+rCnt1%2B%2B)
++++++++++++++++{
++++++++++++++++++++for+(cCnt1+=+1;+cCnt1+<=+ShtRange.Columns.Count;+cCnt1%2B%2B)
++++++++++++++++++++{
++++++++++++++++++++++++if+(Convert.ToString(NwSheet.Cells[rCnt1,+cCnt1].Value2)+==+"Y")
++++++++++++++++++++++++{

++++++++++++++++++++++++++++methodName+=+NwSheet.Cells[rCnt1,+cCnt1+-+2].Value2;
++++++++++++++++++++++++++++Type+metdType+=+this.GetType();
++++++++++++++++++++++++++++MethodInfo+mthInfo+=+metdType.GetMethod(methodName);

++++++++++++++++++++++++++++if+(Convert.ToString(NwSheet.Cells[rCnt1,+cCnt1+-+2].Value2)+==+"fn_AddNum"+%7C%7C+Convert.ToString(NwSheet.Cells[rCnt1,+cCnt1+-+2].Value2)+==+"fn_SubNum")
++++++++++++++++++++++++++++{
++++++++++++++++++++++++++++++++StaticVariable.intParam1+=+Convert.ToInt32(NwSheet.Cells[rCnt1,+cCnt1+%2B+3].Value2);
++++++++++++++++++++++++++++++++StaticVariable.intParam2+=+Convert.ToInt32(NwSheet.Cells[rCnt1,+cCnt1+%2B+4].Value2);
++++++++++++++++++++++++++++++++object[]+mParam1+=+new+object[]+{+StaticVariable.intParam1,+StaticVariable.intParam2+};
++++++++++++++++++++++++++++++++object+result+=+mthInfo.Invoke(this,+mParam1);
++++++++++++++++++++++++++++++++StaticVariable.intOutParam1+=+Convert.ToInt32(result);
++++++++++++++++++++++++++++++++NwSheet.Cells[rCnt1,+cCnt1+%2B+5].Value2+=+Convert.ToString(StaticVariable.intOutParam1)+!=+""+?+Convert.ToString(StaticVariable.intOutParam1)+:+String.Empty;
++++++++++++++++++++++++++++}

++++++++++++++++++++++++++++else
++++++++++++++++++++++++++++{
++++++++++++++++++++++++++++++++object[]+mParam+=+new+object[]+{+};
++++++++++++++++++++++++++++++++mthInfo.Invoke(this,+mParam);

++++++++++++++++++++++++++++++++NwSheet.Cells[rCnt1,+cCnt1+%2B+5].Value2+=+StaticVariable.outParam1+!=+""+?+StaticVariable.outParam1+:+String.Empty;
++++++++++++++++++++++++++++++++NwSheet.Cells[rCnt1,+cCnt1+%2B+6].Value2+=+StaticVariable.outParam2+!=+""+?+StaticVariable.outParam2+:+String.Empty;
++++++++++++++++++++++++++++}
++++++++++++++++++++++++++++NwSheet.Cells[rCnt1,+cCnt1+%2B+1].Value2+=+StaticVariable.resultOut;
++++++++++++++++++++++++++++NwSheet.Cells[rCnt1,+cCnt1+%2B+2].Value2+=+StaticVariable.resultDescription;
++++++++++++++++++++++++}

++++++++++++++++++++++++else+if+(Convert.ToString(NwSheet.Cells[rCnt1,+cCnt1].Value2)+==+"N")
++++++++++++++++++++++++{
++++++++++++++++++++++++++++MessageBox.Show("Result+is+No");
++++++++++++++++++++++++}
++++++++++++++++++++++++else+if+(Convert.ToString(NwSheet.Cells[rCnt1,+cCnt1].Value2)+==+"EOF")
++++++++++++++++++++++++{
++++++++++++++++++++++++++++MessageBox.Show("End+of+File");
++++++++++++++++++++++++}

++++++++++++++++++++}
++++++++++++++++}

++++++++++++++++workbook.Save();
++++++++++++++++workbook.Close(true,+Missing.Value,+Missing.Value);
++++++++++++++++appExl.Quit();
++++++++++++++++System.Runtime.InteropServices.Marshal.FinalReleaseComObject(ShtRange);
++++++++++++++++System.Runtime.InteropServices.Marshal.FinalReleaseComObject(NwSheet);
++++++++++++++++System.Runtime.InteropServices.Marshal.FinalReleaseComObject(workbook);
++++++++++++++++System.Runtime.InteropServices.Marshal.FinalReleaseComObject(appExl);
++++++++++++}
++++++++++++catch+(Exception)
++++++++++++{
++++++++++++++++workbook.Close(true,+Missing.Value,+Missing.Value);
++++++++++++}
++++++++++++finally
++++++++++++{
++++++++++++++++GC.Collect();
++++++++++++++++GC.WaitForPendingFinalizers();
++++++++++++++++System.Runtime.InteropServices.Marshal.CleanupUnusedObjectsInCurrentContext();
++++++++++++}
++++++++}

//code+for+reading+excel+data+in+datatable
public+void+testExcel(string+sheetName)
++++++++{
++++++++++++try
++++++++++++{
++++++++++++++++MessageBox.Show(sheetName);

++++++++++++++++foreach(Process+p+in+Process.GetProcessesByName("EXCEL"))
++++++++++++++++{
++++++++++++++++++++p.Kill();
++++++++++++++++}
++++++++++++++++//string+fileName+=+"E:\\inputSheet";
++++++++++++++++Excel.Application+oXL;
++++++++++++++++Workbook+oWB;
++++++++++++++++Worksheet+oSheet;
++++++++++++++++Range+oRng;


++++++++++++++++//++creat+a+Application+object
++++++++++++++++oXL+=+new+Excel.Application();




++++++++++++++++//+++get+++WorkBook++object
++++++++++++++++oWB+=+oXL.Workbooks.Open(sheetName);


++++++++++++++++//+++get+++WorkSheet+object
++++++++++++++++oSheet+=+(Microsoft.Office.Interop.Excel.Worksheet)oWB.Sheets[1];
++++++++++++++++System.Data.DataTable+dt+=+new+System.Data.DataTable();
++++++++++++++++//DataSet+ds+=+new+DataSet();
++++++++++++++++//ds.Tables.Add(dt);
++++++++++++++++DataRow+dr;


++++++++++++++++StringBuilder+sb+=+new+StringBuilder();
++++++++++++++++int+jValue+=+oSheet.UsedRange.Cells.Columns.Count;
++++++++++++++++int+iValue+=+oSheet.UsedRange.Cells.Rows.Count;


++++++++++++++++//++get+data+columns
++++++++++++++++for+(int+j+=+1;+j+<=+jValue;+j%2B%2B)
++++++++++++++++{
++++++++++++++++++++oRng+=+(Microsoft.Office.Interop.Excel.Range)oSheet.Cells[1,+j];
++++++++++++++++++++string+strValue+=+oRng.Text.ToString();
++++++++++++++++++++dt.Columns.Add(strValue,+System.Type.GetType("System.String"));
++++++++++++++++}


++++++++++++++++//string+colString+=+sb.ToString().Trim();
++++++++++++++++//string[]+colArray+=+colString.Split(':');


++++++++++++++++//++get+data+in+cell
++++++++++++++++for+(int+i+=+2;+i+<=+iValue;+i%2B%2B)
++++++++++++++++{
++++++++++++++++++++dr+=+dt.NewRow();
++++++++++++++++++++for+(int+j+=+1;+j+<=+jValue;+j%2B%2B)
++++++++++++++++++++{
++++++++++++++++++++++++oRng+=+(Microsoft.Office.Interop.Excel.Range)oSheet.Cells[i,+j];
++++++++++++++++++++++++string+strValue+=+oRng.Text.ToString();
++++++++++++++++++++++++dr[j+-+1]+=+strValue;


++++++++++++++++++++}
++++++++++++++++++++dt.Rows.Add(dr);
++++++++++++++++}
++++++++++++++++if(StaticVariable.dtExcel+!=+null)
++++++++++++++++{
++++++++++++++++++++StaticVariable.dtExcel.Clear();
++++++++++++++++++++StaticVariable.dtExcel+=+dt.Copy();
++++++++++++++++}
++++++++++++++++else
++++++++++++++++StaticVariable.dtExcel+=+dt.Copy();

++++++++++++++++oWB.Close(true,+Missing.Value,+Missing.Value);
++++++++++++++++oXL.Quit();
++++++++++++++++MessageBox.Show(sheetName);

++++++++++++}

++++++++++++catch+(Exception+ex)
++++++++++++{
++++++++++++++++MessageBox.Show(ex.Message);
++++++++++++}
++++++++++++finally
++++++++++++{

++++++++++++}
++++++++}

//code+for+class+initialize
+public+static+void+startTesting(TestContext+context)
++++++++{

++++++++++++Playback.Initialize();
++++++++++++ReadExcel+myClassObj+=+new+ReadExcel();
++++++++++++string+sheetName="";
++++++++++++StreamReader+sr+=+new+StreamReader(@"E:\SaveSheetName.txt");
++++++++++++sheetName+=+sr.ReadLine();
++++++++++++sr.Close();
++++++++++++myClassObj.excelRead(sheetName);
++++++++++++myClassObj.testExcel(sheetName);
++++++++}

//code+for+test+initalize
public++void+runValidatonTest()
++++++++{

++++++++++++DataTable+dtFinal+=+StaticVariable.dtExcel.Copy();
++++++++++++for+(int+i+=+0;+i+<+dtFinal.Rows.Count;+i%2B%2B)
++++++++++++{
++++++++++++++++if+(TestContext.TestName+==+dtFinal.Rows[i][2].ToString()+&&+dtFinal.Rows[i][3].ToString()+==+"Y"+&&+dtFinal.Rows[i][4].ToString()+==+"TRUE")
++++++++++++++++{
++++++++++++++++++++MessageBox.Show(TestContext.TestName);
++++++++++++++++++++MessageBox.Show(dtFinal.Rows[i][2].ToString());
++++++++++++++++++++StaticVariable.runValidateResult+=+"true";
++++++++++++++++++++break;
++++++++++++++++}
++++++++++++}
++++++++++++//StaticVariable.dtExcel+=+dtFinal.Copy();
++++++++}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1602732|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>public void excelRead(string sheetName)
 {
 Excel.Application appExl = new Excel.Application();
 Excel.Workbook workbook = null;
 try
 {
 string methodName = "";


 Excel.Worksheet NwSheet;
 Excel.Range ShtRange;

 //Opening Excel file(myData.xlsx)
 appExl = new Excel.Application();


 workbook = appExl.Workbooks.Open(sheetName, Missing.Value, ReadOnly: false);
 NwSheet = (Excel.Worksheet)workbook.Sheets.get_Item(1);
 ShtRange = NwSheet.UsedRange; //gives the used cells in sheet


 int rCnt1 = 0;
 int cCnt1 = 0;

 for (rCnt1 = 1; rCnt1 &lt;= ShtRange.Rows.Count; rCnt1++)
 {
 for (cCnt1 = 1; cCnt1 &lt;= ShtRange.Columns.Count; cCnt1++)
 {
 if (Convert.ToString(NwSheet.Cells[rCnt1, cCnt1].Value2) == "Y")
 {

 methodName = NwSheet.Cells[rCnt1, cCnt1 - 2].Value2;
 Type metdType = this.GetType();
 MethodInfo mthInfo = metdType.GetMethod(methodName);

 if (Convert.ToString(NwSheet.Cells[rCnt1, cCnt1 - 2].Value2) == "fn_AddNum" || Convert.ToString(NwSheet.Cells[rCnt1, cCnt1 - 2].Value2) == "fn_SubNum")
 {
 StaticVariable.intParam1 = Convert.ToInt32(NwSheet.Cells[rCnt1, cCnt1 + 3].Value2);
 StaticVariable.intParam2 = Convert.ToInt32(NwSheet.Cells[rCnt1, cCnt1 + 4].Value2);
 object[] mParam1 = new object[] { StaticVariable.intParam1, StaticVariable.intParam2 };
 object result = mthInfo.Invoke(this, mParam1);
 StaticVariable.intOutParam1 = Convert.ToInt32(result);
 NwSheet.Cells[rCnt1, cCnt1 + 5].Value2 = Convert.ToString(StaticVariable.intOutParam1) != "" ? Convert.ToString(StaticVariable.intOutParam1) : String.Empty;
 }

 else
 {
 object[] mParam = new object[] { };
 mthInfo.Invoke(this, mParam);

 NwSheet.Cells[rCnt1, cCnt1 + 5].Value2 = StaticVariable.outParam1 != "" ? StaticVariable.outParam1 : String.Empty;
 NwSheet.Cells[rCnt1, cCnt1 + 6].Value2 = StaticVariable.outParam2 != "" ? StaticVariable.outParam2 : String.Empty;
 }
 NwSheet.Cells[rCnt1, cCnt1 + 1].Value2 = StaticVariable.resultOut;
 NwSheet.Cells[rCnt1, cCnt1 + 2].Value2 = StaticVariable.resultDescription;
 }

 else if (Convert.ToString(NwSheet.Cells[rCnt1, cCnt1].Value2) == "N")
 {
 MessageBox.Show("Result is No");
 }
 else if (Convert.ToString(NwSheet.Cells[rCnt1, cCnt1].Value2) == "EOF")
 {
 MessageBox.Show("End of File");
 }

 }
 }

 workbook.Save();
 workbook.Close(true, Missing.Value, Missing.Value);
 appExl.Quit();
 System.Runtime.InteropServices.Marshal.FinalReleaseComObject(ShtRange);
 System.Runtime.InteropServices.Marshal.FinalReleaseComObject(NwSheet);
 System.Runtime.InteropServices.Marshal.FinalReleaseComObject(workbook);
 System.Runtime.InteropServices.Marshal.FinalReleaseComObject(appExl);
 }
 catch (Exception)
 {
 workbook.Close(true, Missing.Value, Missing.Value);
 }
 finally
 {
 GC.Collect();
 GC.WaitForPendingFinalizers();
 System.Runtime.InteropServices.Marshal.CleanupUnusedObjectsInCurrentContext();
 }
 }

//code for reading excel data in datatable
public void testExcel(string sheetName)
 {
 try
 {
 MessageBox.Show(sheetName);

 foreach(Process p in Process.GetProcessesByName("EXCEL"))
 {
 p.Kill();
 }
 //string fileName = "E:\\inputSheet";
 Excel.Application oXL;
 Workbook oWB;
 Worksheet oSheet;
 Range oRng;


 // creat a Application object
 oXL = new Excel.Application();




 // get WorkBook object
 oWB = oXL.Workbooks.Open(sheetName);


 // get WorkSheet object
 oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oWB.Sheets[1];
 System.Data.DataTable dt = new System.Data.DataTable();
 //DataSet ds = new DataSet();
 //ds.Tables.Add(dt);
 DataRow dr;


 StringBuilder sb = new StringBuilder();
 int jValue = oSheet.UsedRange.Cells.Columns.Count;
 int iValue = oSheet.UsedRange.Cells.Rows.Count;


 // get data columns
 for (int j = 1; j &lt;= jValue; j++)
 {
 oRng = (Microsoft.Office.Interop.Excel.Range)oSheet.Cells[1, j];
 string strValue = oRng.Text.ToString();
 dt.Columns.Add(strValue, System.Type.GetType("System.String"));
 }


 //string colString = sb.ToString().Trim();
 //string[] colArray = colString.Split(':');


 // get data in cell
 for (int i = 2; i &lt;= iValue; i++)
 {
 dr = dt.NewRow();
 for (int j = 1; j &lt;= jValue; j++)
 {
 oRng = (Microsoft.Office.Interop.Excel.Range)oSheet.Cells[i, j];
 string strValue = oRng.Text.ToString();
 dr[j - 1] = strValue;


 }
 dt.Rows.Add(dr);
 }
 if(StaticVariable.dtExcel != null)
 {
 StaticVariable.dtExcel.Clear();
 StaticVariable.dtExcel = dt.Copy();
 }
 else
 StaticVariable.dtExcel = dt.Copy();

 oWB.Close(true, Missing.Value, Missing.Value);
 oXL.Quit();
 MessageBox.Show(sheetName);

 }

 catch (Exception ex)
 {
 MessageBox.Show(ex.Message);
 }
 finally
 {

 }
 }

//code for class initialize
 public static void startTesting(TestContext context)
 {

 Playback.Initialize();
 ReadExcel myClassObj = new ReadExcel();
 string sheetName="";
 StreamReader sr = new StreamReader(@"E:\SaveSheetName.txt");
 sheetName = sr.ReadLine();
 sr.Close();
 myClassObj.excelRead(sheetName);
 myClassObj.testExcel(sheetName);
 }

//code for test initalize
public void runValidatonTest()
 {

 DataTable dtFinal = StaticVariable.dtExcel.Copy();
 for (int i = 0; i &lt; dtFinal.Rows.Count; i++)
 {
 if (TestContext.TestName == dtFinal.Rows[i][2].ToString() &amp;&amp; dtFinal.Rows[i][3].ToString() == "Y" &amp;&amp; dtFinal.Rows[i][4].ToString() == "TRUE")
 {
 MessageBox.Show(TestContext.TestName);
 MessageBox.Show(dtFinal.Rows[i][2].ToString());
 StaticVariable.runValidateResult = "true";
 break;
 }
 }
 //StaticVariable.dtExcel = dtFinal.Copy();
 }
</code></pre>

blocks|key|1387890|text|try
++++++++{
++++++++++++DataTable+sheet1+=+new+DataTable("Excel+Sheet");
++++++++++++OleDbConnectionStringBuilder+csbuilder+=+new+OleDbConnectionStringBuilder();
++++++++++++csbuilder.Provider+=+"Microsoft.ACE.OLEDB.12.0";
++++++++++++csbuilder.DataSource+=+fileLocation;
++++++++++++csbuilder.Add("Extended+Properties",+"Excel+12.0+Xml;HDR=YES");
++++++++++++string+selectSql+=+@"SELECT+*+FROM+[Sheet1$]";
++++++++++++using+(OleDbConnection+connection+=+new+OleDbConnection(csbuilder.ConnectionString))
++++++++++++using+(OleDbDataAdapter+adapter+=+new+OleDbDataAdapter(selectSql,+connection))
++++++++++++{
++++++++++++++++connection.Open();
++++++++++++++++adapter.Fill(sheet1);
++++++++++++}
++++++++}
++++++++catch+(Exception+e)
++++++++{
++++++++++++Console.WriteLine(e.Message);
++++++++}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1387891|这对我很有效。请试一试，并让我知道查询。|unstyled|1387892|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>try
 {
 DataTable sheet1 = new DataTable("Excel Sheet");
 OleDbConnectionStringBuilder csbuilder = new OleDbConnectionStringBuilder();
 csbuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
 csbuilder.DataSource = fileLocation;
 csbuilder.Add("Extended Properties", "Excel 12.0 Xml;HDR=YES");
 string selectSql = @"SELECT * FROM [Sheet1$]";
 using (OleDbConnection connection = new OleDbConnection(csbuilder.ConnectionString))
 using (OleDbDataAdapter adapter = new OleDbDataAdapter(selectSql, connection))
 {
 connection.Open();
 adapter.Fill(sheet1);
 }
 }
 catch (Exception e)
 {
 Console.WriteLine(e.Message);
 }
</code></pre>

This worked for me. Please try it and let me know for queries.

blocks|key|1387921|text|我建议你使用Bytescout电子表格。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387922|https://bytescout.com/products/developer/spreadsheetsdk/bytescoutspreadsheetsdk.html|offset|length|1387923|我在Unity3D中用Monodevelop尝试过，它非常简单。查看以下示例代码，了解库是如何工作的：|1387924|https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html|1387925|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|2C|0|0|0|0|25|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]|Q|$5|M|N|O|A|$P|I]]]]

I'd recommend you to use Bytescout Spreadsheet.

<a href="https://bytescout.com/products/developer/spreadsheetsdk/bytescoutspreadsheetsdk.html" rel="nofollow">https://bytescout.com/products/developer/spreadsheetsdk/bytescoutspreadsheetsdk.html</a>

I tried it with Monodevelop in Unity3D and it is pretty straight forward. Check this sample code to see how the library works:

<a href="https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html" rel="nofollow">https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html</a>

blocks|key|1387964|text|使用Open+XML。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1387965|下面是一些代码，用于处理具有特定选项卡或工作表名称的电子表格，并将其转储到CSV之类的文件中。(我选择了竖线而不是逗号)。|1387966|我希望从单元格中获取值更容易，但我认为这就是我们所坚持的。您可以看到，我引用了MSDN文档，大部分代码都是在这些文档中获得的。这就是微软的建议。|1387967|++++///+<summary>
++++///+Got+code+from:+https://msdn.microsoft.com/en-us/library/office/gg575571.aspx
++++///+</summary>
++++[Test]
++++public+void+WriteOutExcelFile()
++++{
++++++++var+fileName+=+"ExcelFiles\\File_With_Many_Tabs.xlsx";
++++++++var+sheetName+=+"Submission+Form";+//+Existing+tab+name.
++++++++using+(var+document+=+SpreadsheetDocument.Open(fileName,+isEditable:+false))
++++++++{
++++++++++++var+workbookPart+=+document.WorkbookPart;
++++++++++++var+sheet+=+workbookPart.Workbook.Descendants<Sheet>().FirstOrDefault(s+=>+s.Name+==+sheetName);
++++++++++++var+worksheetPart+=+(WorksheetPart)(workbookPart.GetPartById(sheet.Id));
++++++++++++var+sheetData+=+worksheetPart.Worksheet.Elements<SheetData>().First();

++++++++++++foreach+(var+row+in+sheetData.Elements<Row>())
++++++++++++{
++++++++++++++++foreach+(var+cell+in+row.Elements<Cell>())
++++++++++++++++{
++++++++++++++++++++Console.Write("%7C"+%2B+GetCellValue(cell,+workbookPart));
++++++++++++++++}
++++++++++++++++Console.Write("\n");
++++++++++++}
++++++++}
++++}

++++///+<summary>
++++///+Got+code+from:+https://msdn.microsoft.com/en-us/library/office/hh298534.aspx
++++///+</summary>
++++///+<param+name="cell"></param>
++++///+<param+name="workbookPart"></param>
++++///+<returns></returns>
++++private+string+GetCellValue(Cell+cell,+WorkbookPart+workbookPart)
++++{
++++++++if+(cell+==+null)
++++++++{
++++++++++++return+null;
++++++++}

++++++++var+value+=+cell.CellFormula+!=+null
++++++++++++?+cell.CellValue.InnerText+
++++++++++++:+cell.InnerText.Trim();

++++++++//+If+the+cell+represents+an+integer+number,+you+are+done.+
++++++++//+For+dates,+this+code+returns+the+serialized+value+that+
++++++++//+represents+the+date.+The+code+handles+strings+and+
++++++++//+Booleans+individually.+For+shared+strings,+the+code+
++++++++//+looks+up+the+corresponding+value+in+the+shared+string+
++++++++//+table.+For+Booleans,+the+code+converts+the+value+into+
++++++++//+the+words+TRUE+or+FALSE.
++++++++if+(cell.DataType+==+null)
++++++++{
++++++++++++return+value;
++++++++}
++++++++switch+(cell.DataType.Value)
++++++++{
++++++++++++case+CellValues.SharedString:

++++++++++++++++//+For+shared+strings,+look+up+the+value+in+the
++++++++++++++++//+shared+strings+table.
++++++++++++++++var+stringTable+=
++++++++++++++++++++workbookPart.GetPartsOfType<SharedStringTablePart>()
++++++++++++++++++++++++.FirstOrDefault();

++++++++++++++++//+If+the+shared+string+table+is+missing,+something+
++++++++++++++++//+is+wrong.+Return+the+index+that+is+in
++++++++++++++++//+the+cell.+Otherwise,+look+up+the+correct+text+in+
++++++++++++++++//+the+table.
++++++++++++++++if+(stringTable+!=+null)
++++++++++++++++{
++++++++++++++++++++value+=
++++++++++++++++++++++++stringTable.SharedStringTable
++++++++++++++++++++++++++++.ElementAt(int.Parse(value)).InnerText;
++++++++++++++++}
++++++++++++++++break;

++++++++++++case+CellValues.Boolean:
++++++++++++++++switch+(value)
++++++++++++++++{
++++++++++++++++++++case+"0":
++++++++++++++++++++++++value+=+"FALSE";
++++++++++++++++++++++++break;
++++++++++++++++++++default:
++++++++++++++++++++++++value+=+"TRUE";
++++++++++++++++++++++++break;
++++++++++++++++}
++++++++++++++++break;
++++++++}
++++++++return+value;
++++}|code-block|syntax|javascript|1387968|entityMap|0|LINK|mutability|MUTABLE|url|https://www.nuget.org/packages/DocumentFormat.OpenXml/^0|2|8|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|C|$K|L]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

Use <a href="https://www.nuget.org/packages/DocumentFormat.OpenXml/" rel="nofollow">Open XML</a>.

Here is some code to process a spreadsheet with a specific tab or sheet name and dump it to something like CSV. (I chose a pipe instead of comma).

I wish it was easier to get the value from a cell, but I think this is what we are stuck with. You can see that I reference the MSDN documents where I got most of this code. That is what Microsoft recommends.

<pre><code> /// &lt;summary&gt;
 /// Got code from: https://msdn.microsoft.com/en-us/library/office/gg575571.aspx
 /// &lt;/summary&gt;
 [Test]
 public void WriteOutExcelFile()
 {
 var fileName = "ExcelFiles\\File_With_Many_Tabs.xlsx";
 var sheetName = "Submission Form"; // Existing tab name.
 using (var document = SpreadsheetDocument.Open(fileName, isEditable: false))
 {
 var workbookPart = document.WorkbookPart;
 var sheet = workbookPart.Workbook.Descendants&lt;Sheet&gt;().FirstOrDefault(s =&gt; s.Name == sheetName);
 var worksheetPart = (WorksheetPart)(workbookPart.GetPartById(sheet.Id));
 var sheetData = worksheetPart.Worksheet.Elements&lt;SheetData&gt;().First();

 foreach (var row in sheetData.Elements&lt;Row&gt;())
 {
 foreach (var cell in row.Elements&lt;Cell&gt;())
 {
 Console.Write("|" + GetCellValue(cell, workbookPart));
 }
 Console.Write("\n");
 }
 }
 }

 /// &lt;summary&gt;
 /// Got code from: https://msdn.microsoft.com/en-us/library/office/hh298534.aspx
 /// &lt;/summary&gt;
 /// &lt;param name="cell"&gt;&lt;/param&gt;
 /// &lt;param name="workbookPart"&gt;&lt;/param&gt;
 /// &lt;returns&gt;&lt;/returns&gt;
 private string GetCellValue(Cell cell, WorkbookPart workbookPart)
 {
 if (cell == null)
 {
 return null;
 }

 var value = cell.CellFormula != null
 ? cell.CellValue.InnerText 
 : cell.InnerText.Trim();

 // If the cell represents an integer number, you are done. 
 // For dates, this code returns the serialized value that 
 // represents the date. The code handles strings and 
 // Booleans individually. For shared strings, the code 
 // looks up the corresponding value in the shared string 
 // table. For Booleans, the code converts the value into 
 // the words TRUE or FALSE.
 if (cell.DataType == null)
 {
 return value;
 }
 switch (cell.DataType.Value)
 {
 case CellValues.SharedString:

 // For shared strings, look up the value in the
 // shared strings table.
 var stringTable =
 workbookPart.GetPartsOfType&lt;SharedStringTablePart&gt;()
 .FirstOrDefault();

 // If the shared string table is missing, something 
 // is wrong. Return the index that is in
 // the cell. Otherwise, look up the correct text in 
 // the table.
 if (stringTable != null)
 {
 value =
 stringTable.SharedStringTable
 .ElementAt(int.Parse(value)).InnerText;
 }
 break;

 case CellValues.Boolean:
 switch (value)
 {
 case "0":
 value = "FALSE";
 break;
 default:
 value = "TRUE";
 break;
 }
 break;
 }
 return value;
 }
</code></pre>

blocks|key|1387989|text|使用OlebDB可以很方便地在C#中读取excel文件，这是使用Web-Form时的代码，其中FileUpload1是文件上传工具|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1387990|+++string+path+=+Server.MapPath("~/Uploads/");
++if+(!Directory.Exists(path))
{
++++Directory.CreateDirectory(path);
}
//get+file+path
filePath+=+path+%2B+Path.GetFileName(FileUpload1.FileName);
//get+file+extenstion
string+extension+=+Path.GetExtension(FileUpload1.FileName);
//save+file+on+"Uploads"+folder+of+project
FileUpload1.SaveAs(filePath);

string+conString+=+string.Empty;
//check+file+extension
switch+(extension)
{
++++case+".xls":+//Excel+97-03.
++++++++conString+=+"Provider=Microsoft.Jet.OLEDB.4.0;Data+Source=Excel03ConString;Extended+Properties='Excel+8.0;HDR=YES'";
++++++++break;
++++case+".xlsx":+//Excel+07+and+above.
++++++++conString+=+"Provider=Microsoft.ACE.OLEDB.12.0;Data+Source=Excel07ConString;Extended+Properties='Excel+8.0;HDR=YES'";
++++++++break;
}

//create+datatable+object
DataTable+dt+=+new+DataTable();
conString+=+string.Format(conString,+filePath);

//Use+OldDb+to+read+excel
using+(OleDbConnection+connExcel+=+new+OleDbConnection(conString))
{
++++using+(OleDbCommand+cmdExcel+=+new+OleDbCommand())
++++{
++++++++using+(OleDbDataAdapter+odaExcel+=+new+OleDbDataAdapter())
++++++++{
++++++++++++cmdExcel.Connection+=+connExcel;

++++++++++++//Get+the+name+of+First+Sheet.
++++++++++++connExcel.Open();
++++++++++++DataTable+dtExcelSchema;
++++++++++++dtExcelSchema+=+connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,+null);
++++++++++++string+sheetName+=+dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
++++++++++++connExcel.Close();

++++++++++++//Read+Data+from+First+Sheet.
++++++++++++connExcel.Open();
++++++++++++cmdExcel.CommandText+=+"SELECT+*+From+["+%2B+sheetName+%2B+"]";
++++++++++++odaExcel.SelectCommand+=+cmdExcel;
++++++++++++odaExcel.Fill(dt);
++++++++++++connExcel.Close();
++++++++}
++++}
}

//bind+datatable+with+GridView
GridView1.DataSource+=+dt;
GridView1.DataBind();|code-block|syntax|javascript|1387991|来源：https://qawithexperts.com/article/asp-net/read-excel-file-and-import-data-into-gridview-using-datatabl/209|offset|length|1387992|控制台应用程序类似的代码示例https://qawithexperts.com/article/c-sharp/read-excel-file-in-c-console-application-example-using-oledb/168|1387993|如果你不想使用OleDB，你可以试试https://github.com/ExcelDataReader/ExcelDataReader，它似乎能够同时处理两种格式(.xls和.xslx)|1387994|entityMap|0|LINK|mutability|MUTABLE|url|https://qawithexperts.com/article/asp-net/read-excel-file-and-import-data-into-gridview-using-datatabl/209|1|https://qawithexperts.com/article/c-sharp/read-excel-file-in-c-console-application-example-using-oledb/168|2|https://github.com/ExcelDataReader/ExcelDataReader^0|0|0|3|2Y|0|0|E|2Y|1|0|I|1E|2|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@$I|13|J|14|1|15]]|A|$]]|$1|K|3|L|5|6|7|16|8|@]|9|@$I|17|J|18|1|19]]|A|$]]|$1|M|3|N|5|6|7|1A|8|@]|9|@$I|1B|J|1C|1|1D]]|A|$]]|$1|O|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]|Y|$5|R|S|T|A|$U|Z]]]]

Using OlebDB, we can read excel file in C#, easily, here is the code while working with Web-Form, where FileUpload1 is file uploading tool

<pre><code> string path = Server.MapPath("~/Uploads/");
 if (!Directory.Exists(path))
{
 Directory.CreateDirectory(path);
}
//get file path
filePath = path + Path.GetFileName(FileUpload1.FileName);
//get file extenstion
string extension = Path.GetExtension(FileUpload1.FileName);
//save file on "Uploads" folder of project
FileUpload1.SaveAs(filePath);

string conString = string.Empty;
//check file extension
switch (extension)
{
 case ".xls": //Excel 97-03.
 conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Excel03ConString;Extended Properties='Excel 8.0;HDR=YES'";
 break;
 case ".xlsx": //Excel 07 and above.
 conString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Excel07ConString;Extended Properties='Excel 8.0;HDR=YES'";
 break;
}

//create datatable object
DataTable dt = new DataTable();
conString = string.Format(conString, filePath);

//Use OldDb to read excel
using (OleDbConnection connExcel = new OleDbConnection(conString))
{
 using (OleDbCommand cmdExcel = new OleDbCommand())
 {
 using (OleDbDataAdapter odaExcel = new OleDbDataAdapter())
 {
 cmdExcel.Connection = connExcel;

 //Get the name of First Sheet.
 connExcel.Open();
 DataTable dtExcelSchema;
 dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
 string sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
 connExcel.Close();

 //Read Data from First Sheet.
 connExcel.Open();
 cmdExcel.CommandText = "SELECT * From [" + sheetName + "]";
 odaExcel.SelectCommand = cmdExcel;
 odaExcel.Fill(dt);
 connExcel.Close();
 }
 }
}

//bind datatable with GridView
GridView1.DataSource = dt;
GridView1.DataBind();
</code></pre>

Source : <a href="https://qawithexperts.com/article/asp-net/read-excel-file-and-import-data-into-gridview-using-datatabl/209" rel="nofollow noreferrer">https://qawithexperts.com/article/asp-net/read-excel-file-and-import-data-into-gridview-using-datatabl/209</a>

Console application similar code example
<a href="https://qawithexperts.com/article/c-sharp/read-excel-file-in-c-console-application-example-using-oledb/168" rel="nofollow noreferrer">https://qawithexperts.com/article/c-sharp/read-excel-file-in-c-console-application-example-using-oledb/168</a>

If you need don't want to use OleDB, you can try <a href="https://github.com/ExcelDataReader/ExcelDataReader" rel="nofollow noreferrer">https://github.com/ExcelDataReader/ExcelDataReader</a>
 which seems to have the ability to handle both formats (.xls and .xslx)

How to read an Excel file using C#? I open an Excel file for reading and copy it to clipboard to search email format, but I don't know how to do it.

<pre><code>FileInfo finfo;
Excel.ApplicationClass ExcelObj = new Excel.ApplicationClass();
ExcelObj.Visible = false;

Excel.Workbook theWorkbook;
Excel.Worksheet worksheet;

if (listView1.Items.Count &gt; 0)
{
 foreach (ListViewItem s in listView1.Items)
 {
 finfo = new FileInfo(s.Text);
 if (finfo.Extension == ".xls" || finfo.Extension == ".xlsx" || finfo.Extension == ".xlt" || finfo.Extension == ".xlsm" || finfo.Extension == ".csv")
 {
 theWorkbook = ExcelObj.Workbooks.Open(s.Text, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, false, false);

 for (int count = 1; count &lt;= theWorkbook.Sheets.Count; count++)
 {
 worksheet = (Excel.Worksheet)theWorkbook.Worksheets.get_Item(count);
 worksheet.Activate();
 worksheet.Visible = false;
 worksheet.UsedRange.Cells.Select();
 }
 }
 }
}
</code></pre>

How to read data of an Excel file using C#?

服务器

如何使用C#读取Excel文件？我打开一个Excel文件阅读，并将其复制到剪贴板，以搜索电子邮件格式，但我不知道怎么做。FileInfo finfo;Excel.ApplicationClass ExcelObj = new Excel.ApplicationClass();ExcelObj.Visible = fal...

问如何用C#读取Excel文件中的数据
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用C#读取Excel文件中的数据EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用C#读取Excel文件中的数据
EN