c#鎬庝箞璇诲彇excel鏂囦欢鏁版嵁
鍦–#涓紝鍙互浣跨敤Microsoft.Office.Interop.Excel鍛藉悕绌洪棿鏉ヨ鍙朎xcel鏂囦欢鐨勬暟鎹€傞鍏堬紝闇€瑕佺‘淇濆凡缁忓畨瑁呬簡Microsoft Office鎴栬€呬娇鐢∟uGet瀹夎浜哅icrosoft.Office.Interop.Excel鍖呫€?/p>
涓嬮潰鏄竴涓鍙朎xcel鏂囦欢鏁版嵁鐨勭ず渚嬩唬鐮侊細
using Microsoft.Office.Interop.Excel;
public class ExcelReader
{
public static void Main()
{
// 鍒涘缓涓€涓狤xcel搴旂敤绋嬪簭瀵硅薄
Application excel = new Application();
// 鎵撳紑Excel鏂囦欢
Workbook workbook = excel.Workbooks.Open(@"C:\path\to\your\file.xlsx");
// 閫夋嫨绗竴涓伐浣滆〃
Worksheet worksheet = workbook.Sheets[1];
// 鑾峰彇宸ヤ綔琛ㄤ腑鐨勬暟鎹寖鍥?/span>
Range range = worksheet.UsedRange;
// 閬嶅巻姣忎釜鍗曞厓鏍煎苟璇诲彇鏁版嵁
for (int row = 1; row <= range.Rows.Count; row++)
{
for (int column = 1; column <= range.Columns.Count; column++)
{
// 璇诲彇鍗曞厓鏍肩殑鍊?/span>
string cellValue = range.Cells[row, column].Value2.ToString();
// 鍦ㄦ帶鍒跺彴杈撳嚭鍗曞厓鏍肩殑鍊?/span>
Console.WriteLine("Cell ({0}, {1}): {2}", row, column, cellValue);
}
}
// 鍏抽棴Excel搴旂敤绋嬪簭瀵硅薄
workbook.Close();
excel.Quit();
}
}
鍦ㄤ笂闈㈢殑绀轰緥涓紝棣栧厛鍒涘缓涓€涓狤xcel搴旂敤绋嬪簭瀵硅薄骞舵墦寮€Excel鏂囦欢銆傜劧鍚庨€夋嫨瑕佽鍙栫殑宸ヤ綔琛紝骞惰幏鍙栧伐浣滆〃涓殑鏁版嵁鑼冨洿銆傛帴涓嬫潵锛屼娇鐢ㄤ袱涓祵濂楀惊鐜亶鍘嗘瘡涓崟鍏冩牸骞惰鍙栧崟鍏冩牸鐨勫€笺€傛渶鍚庯紝鍏抽棴Excel搴旂敤绋嬪簭瀵硅薄銆?/p>