C#读取Excel

利用C#读取Excel中的数据

 

由于特殊桥的脚手架形状并不完全规律,导致脚手杆的间距不统一无法顺利循环,所以决定利用Excel导入间距数据再进行布设

string path = @"D:\Text.xls";  //Excel目录, 

    //加载Excel
    Excel.Application app = new Excel.Application();  //获取权限
    Excel.Workbooks workbooks = app.Workbooks;   
    Excel.Workbook workbook = workbooks.Add(path);


    //获取sheet 
    Excel.Sheets sheet = workbook.Sheets;

    Excel.Worksheet worksheet = (Excel.Worksheet)sheet.get_Item(1);//获取sheet  (1)为第一个sheet

    double usedRows = app.WorksheetFunction.CountA(worksheet.Columns[3]); //第3列的行数

    string num = usedRows.ToString();

    object[,] twoDoubleList = worksheet.Range["A1:C" + num].Value2; //获取数组