c# 读写excel文件

最新推荐文章于 2024-08-14 11:34:36 发布

homehome...

最新推荐文章于 2024-08-14 11:34:36 发布

阅读量526

点赞数

分类专栏：基础知识 Winform

本文链接：https://blog.csdn.net/segclliwf/article/details/116484776

版权

基础知识同时被 2 个专栏收录

47 篇文章 0 订阅

订阅专栏

Winform

32 篇文章 0 订阅

订阅专栏

这段代码展示了如何使用C#和Microsoft.Office.Interop.Excel库来读取Excel文件中指定工作表上的数据。它首先检查文件是否存在，然后打开工作簿，读取指定范围内的单元格数据，并将它们添加到列表中。在读取完成后，确保正确关闭和释放所有使用的对象。

摘要由CSDN通过智能技术生成

**首先项目要引用excel.dll:Microsoft.Office.Interop.Excel

  /// <remarks></remarks>
            public string[] Excel_Read(string filePath, string[] cellAddress,string workSheetName)
            {
             if (!File.Exists(fileFullName))
            {
                return null;    
            }
                List<string> listExcelVal = new List<string>();
                Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
                Microsoft.Office.Interop.Excel.Workbooks wbooks = xlApp.Workbooks;
               // string fileCopyTemp = FileCopy(filePath); 
                Microsoft.Office.Interop.Excel.Workbook wbook = wbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                Microsoft.Office.Interop.Excel.Worksheet worksheet = wbook.Worksheets[workSheetName];   //"Inf" sheetname
               try
                {   
      // Write  the data
      //for (int j = 0; j <= cellAddress.Length - 1; j++)
         //           {
      //  worksheet.Range(cellAddress(i).ToString()).Value2 = "test test test";
      //  }
                    // read the data   ,support address range ,eg: [B8:B49]                        
                  for (int j = 0; j <= cellAddress.Length - 1; j++)
                {
                    switch (cellAddress[j].ToString())
                    {
                        case "":
                            listExcelVal.Add("");
                            break;                          
                        default:
                            object obj;                           
                               Microsoft .Office .Interop.Excel .Range range = worksheet.Range[cellAddress[j].ToString()];
                                foreach (Microsoft.Office.Interop.Excel.Range cell in range)
                                {
                                    obj = cell.Text;
                                    listExcelVal.Add(obj.ToString());
                                }
                                //obj = worksheet.Range[cellAddress[j].ToString()].Value2;     // obj is a Object[,] value
                                //foreach (var item in (object[,])obj)
                                //{
                                //    // foreach (var item in  (object[])items)    
                                //    //  {
                                //    listExcelVal.Add(Convert.ToString(item));
                                //    listExcelVal.Add(item.GetType().Name.ToUpper() == "DOUBLE" ? (Convert.ToDouble(Convert.ToString(item)).ToString("f2")) : Convert.ToString(item));
                                //    //}
                                //}                                               
                            break;
                    }                  
                  }
                }
                catch (Exception e)
                {
                // throw e;
                  listExcelVal.Clear();
                  listExcelVal.Add("Error in getting excel data.");
                }
                finally
                {
                    wbook.Close(false, filePath, false); //不會彈出＂是否保存＂框
                    xlApp.Quit();
                    ReleaseObj(xlApp);
                    ReleaseObj(wbook);
                    ReleaseObj(worksheet);                                    
                }
                 return listExcelVal.ToArray();
        }

        //释放资源
        private void ReleaseObj(Object o)
        {
            try
            {
                //使用此方法，来释放引用某些资源的基础 COM 对象。 这里的o就是要释放的对象
                System.Runtime.InteropServices.Marshal.ReleaseComObject(o);
            }
            catch { }
            finally
            {
                o = null; GC.Collect();
            }
        }