扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

c#鎬庝箞璇诲彇excel鏂囦欢鏁版嵁

扬州沐宇科技
2023-12-16 17:25:41
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>

扫码添加客服微信