//加载excel表格

Stream stream = new FileStream(filePath, FileMode.OpenOrCreate);

 XSSFWorkbook NPOIWorkBook = new XSSFWorkbook(stream);

stream.Dispose();

                        //根据index加载带有图片的sheet

                        XSSFSheet iSheet = (XSSFSheet)NPOIWorkBook.GetSheetAt(index);

                        try

                        {

                            var documentPartList = iSheet.GetRelations();

                            foreach (var documentPart in documentPartList)

                            {

                                if (documentPart is XSSFDrawing)

                                {

                                    var drawing = (XSSFDrawing)documentPart;

                                    var shapeList = drawing.GetShapes();



                                    foreach (var shape in shapeList)

                                    {

                                        if (shape is XSSFPicture)

                                        {

                                            XSSFPicture picture = (XSSFPicture)shape;

                                            byte[] bytes = picture.PictureData.Data;

                                            using (MemoryStream ms = new MemoryStream(bytes))

                                            {

                                                using (Bitmap map = new Bitmap(ms))

                                                {

                                                    string path =  "/" + DateTime.Now.ToString("yyyyMMddHHmmssff") + ".jpg";

                                                    map.Save(Server.MapPath(path), System.Drawing.Imaging.ImageFormat.Jpeg);   

                                                }

                                            }



                                        }

                                    }

                                }

                            }



                        }

                        catch (Exception ex)

                        {

                            

                        }