c#操作EXCEL(读取sheet名，不排序)

来源：互联网发布：网络直播唱痒的女的编辑：程序博客网时间：2024/05/22 00:47

private const long BUFFER_SIZE = 4096;
private string m_ZipFilePath;

      public string ZipFilePath
      {
          get { return m_ZipFilePath; }
          set { m_ZipFilePath = value; }
      }

      private string m_OutZipFilePath;
      public string OutZipFilePath
      {
          get { return m_OutZipFilePath; }
          set { m_OutZipFilePath = value; }
      }
      private FileInfo fileInfo;
      private string zipFilePath;
      public List<string> GetExcelSheetName(string filePath)
      {
          GetZipFilePath(filePath);
          //将excel文件,复制成.zip文件
          FileInfo newFileInfo = fileInfo.CopyTo(m_ZipFilePath, true);
          Decompress(m_ZipFilePath, m_OutZipFilePath);//解压zip
          List<string> ExcelSheetNameList = GetSheetNameByXml(m_OutZipFilePath);
          //获取文件名后删除解压后的文件及.zip文件
          DeleteFile();
          return ExcelSheetNameList;
      }

      /// <summary>
      /// 获取生成的zip文件的路径及解压后的路径
      /// </summary>
      /// <param name="filePath">Excel文件路径</param>
      public void GetZipFilePath(string filePath)
      {
          fileInfo = new FileInfo(filePath);
          zipFilePath = ProjectFileManager.Instance().CurrentProjectLossPath;//zip文件及解压后的文件存放的路径
          string fileName = Path.GetFileNameWithoutExtension(filePath) + ".zip";
          m_ZipFilePath = zipFilePath + "\\" + fileName;
          m_OutZipFilePath = Path.Combine(zipFilePath, fileInfo.Name.Substring(0, fileInfo.Name.Length - 4));
      }