SharpZipLib 提取压缩包文件并转换为NPOI中的Excel文件

　　自己没有找到相关API,建个随笔记录一下

　　在Asp.net MVC模式下,使用CSharpZipLib读取前台上传的压缩包,然后解压,利用MemoryStream存储到内存中.再封装到Xssfworkbook对象中 .

 

public ActionResult Update()
        {
            //压缩包中的文件
            ZipEntry zipEntry;
            //上传的压缩包
            HttpPostedFileBase uploadFile = Request.Files["txt_file"];
            //流的转换
            DateTime startTime = DateTime.Now;
            using (ZipInputStream zipInputStream = new ZipInputStream(uploadFile.InputStream))
            {
                //遍历压缩包中的文件,历史ZipInputStream流可以读取每个文件,
                while ((zipEntry = zipInputStream.GetNextEntry()) != null)
                {
                    Stream decompressedStream = new MemoryStream();
                    XSSFWorkbook xSSFWorkbook = null;
                    //缓存
                    Byte[] buf = new byte[1024];
                    //读取标志位
                    int count;
                    try
                    {
                        if (!zipEntry.IsFile) continue;
                        while ((count = zipInputStream.Read(buf, 0, buf.Length)) > 0)
                        {
                            //写入内存
                            decompressedStream.Write(buf, 0, count);
                        }
                        //指针回位
                        decompressedStream.Position = 0;
                        xSSFWorkbook = new XSSFWorkbook(decompressedStream);
                        String name = zipEntry.Name;
                        Debug.WriteLine(name);
                        Debug.WriteLine(xSSFWorkbook.GetSheetName(2));
                        Debug.WriteLine(xSSFWorkbook.Count);
                    }
                    finally
                    {
                        if (xSSFWorkbook != null) xSSFWorkbook.Close();
                        if (decompressedStream != null) decompressedStream.Close();

                    }
                }
            }

            DateTime endTime = DateTime.Now;
            Debug.WriteLine(endTime - startTime);
            return null;
        }

 

 

学习C#不久,之后再研究下NPOI和CSharpZipLib,还有IO读写的详细内容.