C#读写Excel（2）

    
        
            
            
            
        
        
        
            
            
            
        

        
            读取数据
            取消
        
        
    

        private void Read_Click(object sender, RoutedEventArgs e)
        {
            // 创建Excel对象

            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();

            //打开文件路径
            String filePath = "C:/000/hx.xls";

            Workbook workbook = excel.Workbooks.Open(filePath);

            //服务器托管网 获取第一个工作表

    服务器托管网        Worksheet worksheet = workbook.Sheets[1];

            // 获取单元格值

            Range range = worksheet.UsedRange;

            name1.Content= (range.Cells[1, 1] as Range).Value.ToString();

            age1.Content= (range.Cells[1, 2] as Range).Value.ToString();

            height1.Content = (range.Cells[1, 3] as Range).Value.ToString();

            name2.Text=(range.Cells[2, 1] as Range).Value.ToString();

            age2.Text = (range.Cells[2, 2] as Range).Value.ToString();

            height2.Text= (range.Cells[2, 3] as Range).Value.ToString();

            // 关闭Excel对象

            workbook.Close();

            excel.Quit();
        }