using NPOI.POIFS.FileSystem;using NPOI.SS.UserModel;using NPOI.XSSF.UserModel;using NPOI.XWPF.UserModel;using System;using System.Collections.Generic;using System.Configuration;using System.IO;using System.Text;namespace eyuan{  public static class NOPIHandler  {    /// <summary>    ///     /// </summary>    /// <param name="fileName"></param>    /// <returns></returns>    public static List<List<List<string>>> ReadExcel(string fileName)    {      //打開Excel工作簿      XSSFWorkbook hssfworkbook = null;      try      {        using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read))        {          hssfworkbook = new XSSFWorkbook(file);        }      }      catch (Exception e)      {        LogHandler.LogWrite(string.Format("文件{0}打開失敗，錯誤：{1}", new string[] { fileName, e.ToString() }));      }      //循環(huán)Sheet頁      int sheetsCount = hssfworkbook.NumberOfSheets;      List<List<List<string>>> workBookContent = new List<List<List<string>>>();      for (int i = 0; i < sheetsCount; i++)      {        //Sheet索引從0開始        ISheet sheet = hssfworkbook.GetSheetAt(i);        //循環(huán)行        List<List<string>> sheetContent = new List<List<string>>();        int rowCount = sheet.PhysicalNumberOfRows;        for (int j = 0; j < rowCount; j++)        {          //Row（邏輯行）的索引從0開始          IRow row = sheet.GetRow(j);          //循環(huán)列（各行的列數(shù)可能不同）          List<string> rowContent = new List<string>();          int cellCount = row.PhysicalNumberOfCells;          for (int k = 0; k < cellCount; k++)          {            //ICell cell = row.GetCell(k);            ICell cell = row.Cells[k];            if (cell == null)            {              rowContent.Add("NIL");            }            else            {              rowContent.Add(cell.ToString());              //rowContent.Add(cell.StringCellValue);            }          }          //添加行到集合中          sheetContent.Add(rowContent);        }        //添加Sheet到集合中        workBookContent.Add(sheetContent);      }      return workBookContent;    }    /// <summary>    ///     /// </summary>    /// <param name="fileName"></param>    /// <returns></returns>    public static string ReadExcelText(string fileName)    {      string ExcelCellSeparator = ConfigurationManager.AppSettings["ExcelCellSeparator"];      string ExcelRowSeparator = ConfigurationManager.AppSettings["ExcelRowSeparator"];      string ExcelSheetSeparator = ConfigurationManager.AppSettings["ExcelSheetSeparator"];      //      List<List<List<string>>> excelContent = ReadExcel(fileName);      string fileText = string.Empty;      StringBuilder sbFileText = new StringBuilder();      //循環(huán)處理WorkBook中的各Sheet頁      List<List<List<string>>>.Enumerator enumeratorWorkBook = excelContent.GetEnumerator();      while (enumeratorWorkBook.MoveNext())      {        //循環(huán)處理當(dāng)期Sheet頁中的各行        List<List<string>>.Enumerator enumeratorSheet = enumeratorWorkBook.Current.GetEnumerator();        while (enumeratorSheet.MoveNext())        {          string[] rowContent = enumeratorSheet.Current.ToArray();          sbFileText.Append(string.Join(ExcelCellSeparator, rowContent));          sbFileText.Append(ExcelRowSeparator);        }        sbFileText.Append(ExcelSheetSeparator);      }      //      fileText = sbFileText.ToString();      return fileText;    }    /// <summary>    /// 讀取Word內(nèi)容    /// </summary>    /// <param name="fileName"></param>    /// <returns></returns>    public static string ReadWordText(string fileName)    {      string WordTableCellSeparator = ConfigurationManager.AppSettings["WordTableCellSeparator"];      string WordTableRowSeparator = ConfigurationManager.AppSettings["WordTableRowSeparator"];      string WordTableSeparator = ConfigurationManager.AppSettings["WordTableSeparator"];      //      string CaptureWordHeader = ConfigurationManager.AppSettings["CaptureWordHeader"];      string CaptureWordFooter = ConfigurationManager.AppSettings["CaptureWordFooter"];      string CaptureWordTable = ConfigurationManager.AppSettings["CaptureWordTable"];      string CaptureWordImage = ConfigurationManager.AppSettings["CaptureWordImage"];      //      string CaptureWordImageFileName = ConfigurationManager.AppSettings["CaptureWordImageFileName"];      //      string fileText = string.Empty;      StringBuilder sbFileText = new StringBuilder();      #region 打開文檔      XWPFDocument document = null;      try      {        using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read))        {          document = new XWPFDocument(file);        }      }      catch (Exception e)      {        LogHandler.LogWrite(string.Format("文件{0}打開失敗，錯誤：{1}", new string[] { fileName, e.ToString() }));      }      #endregion      #region 頁眉、頁腳      //頁眉      if (CaptureWordHeader == "true")      {        sbFileText.AppendLine("Capture Header Begin");        foreach (XWPFHeader xwpfHeader in document.HeaderList)        {          sbFileText.AppendLine(string.Format("{0}", new string[] { xwpfHeader.Text }));        }        sbFileText.AppendLine("Capture Header End");      }      //頁腳      if (CaptureWordFooter == "true")      {        sbFileText.AppendLine("Capture Footer Begin");        foreach (XWPFFooter xwpfFooter in document.FooterList)        {          sbFileText.AppendLine(string.Format("{0}", new string[] { xwpfFooter.Text }));        }        sbFileText.AppendLine("Capture Footer End");      }      #endregion      #region 表格      if (CaptureWordTable == "true")      {        sbFileText.AppendLine("Capture Table Begin");        foreach (XWPFTable table in document.Tables)        {          //循環(huán)表格行          foreach (XWPFTableRow row in table.Rows)          {            foreach (XWPFTableCell cell in row.GetTableCells())            {              sbFileText.Append(cell.GetText());              //              sbFileText.Append(WordTableCellSeparator);            }            sbFileText.Append(WordTableRowSeparator);          }          sbFileText.Append(WordTableSeparator);        }        sbFileText.AppendLine("Capture Table End");      }      #endregion      #region 圖片      if (CaptureWordImage == "true")      {        sbFileText.AppendLine("Capture Image Begin");        foreach (XWPFPictureData pictureData in document.AllPictures)        {          string picExtName = pictureData.suggestFileExtension();          string picFileName = pictureData.GetFileName();          byte[] picFileContent = pictureData.GetData();          //          string picTempName = string.Format(CaptureWordImageFileName, new string[] { Guid.NewGuid().ToString() + "_" + picFileName + "." + picExtName });          //          using (FileStream fs = new FileStream(picTempName, FileMode.Create, FileAccess.Write))          {            fs.Write(picFileContent, 0, picFileContent.Length);            fs.Close();          }          //          sbFileText.AppendLine(picTempName);        }        sbFileText.AppendLine("Capture Image End");      }      #endregion      //正文段落      sbFileText.AppendLine("Capture Paragraph Begin");      foreach (XWPFParagraph paragraph in document.Paragraphs)      {        sbFileText.AppendLine(paragraph.ParagraphText);      }      sbFileText.AppendLine("Capture Paragraph End");      //      //      fileText = sbFileText.ToString();      return fileText;    }  }}