private static Record EncodePictures(Dictionary <Pair <int, int>, Picture> pictures, SharedResource sharedResource, Worksheet worksheet)
        {
            MSODRAWING        mSODRAWING        = new MSODRAWING();
            MsofbtDgContainer msofbtDgContainer = new MsofbtDgContainer();

            mSODRAWING.EscherRecords.Add(msofbtDgContainer);
            MsofbtDg msofbtDg = new MsofbtDg();

            msofbtDg.Instance = 1;
            checked
            {
                msofbtDg.NumShapes   = pictures.Count + 1;
                msofbtDg.LastShapeID = 1024 + pictures.Count;
                msofbtDgContainer.EscherRecords.Add(msofbtDg);
                MsofbtSpgrContainer msofbtSpgrContainer = new MsofbtSpgrContainer();
                msofbtDgContainer.EscherRecords.Add(msofbtSpgrContainer);
                MsofbtSpContainer msofbtSpContainer = new MsofbtSpContainer();
                msofbtSpContainer.EscherRecords.Add(new MsofbtSpgr());
                MsofbtSp msofbtSp = new MsofbtSp();
                msofbtSp.ShapeId = 1024;
                msofbtSp.Flags   = 5;
                msofbtSp.Version = 2;
                msofbtSpContainer.EscherRecords.Add(msofbtSp);
                msofbtSpgrContainer.EscherRecords.Add(msofbtSpContainer);
                foreach (Picture current in pictures.Values)
                {
                    if (!sharedResource.Images.Contains(current.Image))
                    {
                        sharedResource.Images.Add(current.Image);
                    }
                    MsofbtSpContainer msofbtSpContainer2 = new MsofbtSpContainer();
                    MsofbtSp          msofbtSp2          = new MsofbtSp();
                    msofbtSp2.Version   = 2;
                    msofbtSp2.ShapeType = ShapeType.PictureFrame;
                    msofbtSp2.ShapeId   = 1024 + msofbtSpgrContainer.EscherRecords.Count;
                    msofbtSp2.Flags     = 2560;
                    msofbtSpContainer2.EscherRecords.Add(msofbtSp2);
                    MsofbtOPT msofbtOPT = new MsofbtOPT();
                    msofbtOPT.Add(PropertyIDs.LockAgainstGrouping, 33226880u);
                    msofbtOPT.Add(PropertyIDs.FitTextToShape, 262148u);
                    msofbtOPT.Add(PropertyIDs.BlipId, (uint)sharedResource.Images.IndexOf(current.Image) + 1u);
                    msofbtSpContainer2.EscherRecords.Add(msofbtOPT);
                    MsofbtClientAnchor msofbtClientAnchor = new MsofbtClientAnchor();
                    msofbtClientAnchor.Row1      = current.TopLeftCorner.RowIndex;
                    msofbtClientAnchor.Col1      = current.TopLeftCorner.ColIndex;
                    msofbtClientAnchor.DX1       = current.TopLeftCorner.DX;
                    msofbtClientAnchor.DY1       = current.TopLeftCorner.DY;
                    msofbtClientAnchor.Row2      = current.BottomRightCorner.RowIndex;
                    msofbtClientAnchor.Col2      = current.BottomRightCorner.ColIndex;
                    msofbtClientAnchor.DX2       = current.BottomRightCorner.DX;
                    msofbtClientAnchor.DY2       = current.BottomRightCorner.DY;
                    msofbtClientAnchor.ExtraData = new byte[0];
                    msofbtSpContainer2.EscherRecords.Add(msofbtClientAnchor);
                    msofbtSpContainer2.EscherRecords.Add(new MsofbtClientData());
                    msofbtSpgrContainer.EscherRecords.Add(msofbtSpContainer2);
                }
                return(mSODRAWING);
            }
        }
Exemple #2
0
        public void ExtractPictures()
        {
            if (Drawing != null)
            {
                MsofbtDgContainer dgContainer = Drawing.FindChild <MsofbtDgContainer>();
                if (dgContainer != null)
                {
                    MsofbtSpgrContainer spgrContainer = dgContainer.FindChild <MsofbtSpgrContainer>();

                    List <MsofbtSpContainer> spContainers = spgrContainer.FindChildren <MsofbtSpContainer>();

                    foreach (MsofbtSpContainer spContainer in spContainers)
                    {
                        MsofbtOPT          opt    = spContainer.FindChild <MsofbtOPT>();
                        MsofbtClientAnchor anchor = spContainer.FindChild <MsofbtClientAnchor>();

                        if (opt != null && anchor != null)
                        {
                            foreach (ShapeProperty prop in opt.Properties)
                            {
                                if (prop.PropertyID == PropertyIDs.BlipId)
                                {
                                    int     imageIndex = (int)prop.PropertyValue - 1;
                                    Picture pic        = new Picture();
                                    pic.TopLeftCorner.RowIndex     = anchor.Row1;
                                    pic.TopLeftCorner.ColIndex     = anchor.Col1;
                                    pic.TopLeftCorner.DX           = anchor.DX1;
                                    pic.TopLeftCorner.DY           = anchor.DY1;
                                    pic.BottomRightCorner.RowIndex = anchor.Row2;
                                    pic.BottomRightCorner.ColIndex = anchor.Col2;
                                    pic.BottomRightCorner.DX       = anchor.DX2;
                                    pic.BottomRightCorner.DY       = anchor.DY2;
                                    pic.Image             = Book.ExtractImage(imageIndex);
                                    pictures[pic.CellPos] = pic;
                                    break;
                                }
                            }
                        }
                    }
                }
            }
        }
Exemple #3
0
 public void ExtractPictures()
 {
     if (this.Drawing != null)
     {
         MsofbtDgContainer msofbtDgContainer = this.Drawing.FindChild <MsofbtDgContainer>();
         if (msofbtDgContainer != null)
         {
             MsofbtSpgrContainer      msofbtSpgrContainer = msofbtDgContainer.FindChild <MsofbtSpgrContainer>();
             List <MsofbtSpContainer> list = msofbtSpgrContainer.FindChildren <MsofbtSpContainer>();
             foreach (MsofbtSpContainer current in list)
             {
                 MsofbtOPT          msofbtOPT          = current.FindChild <MsofbtOPT>();
                 MsofbtClientAnchor msofbtClientAnchor = current.FindChild <MsofbtClientAnchor>();
                 if (msofbtOPT != null && msofbtClientAnchor != null)
                 {
                     foreach (ShapeProperty current2 in msofbtOPT.Properties)
                     {
                         if (current2.PropertyID == PropertyIDs.BlipId)
                         {
                             int     index   = checked ((int)current2.PropertyValue - 1);
                             Picture picture = new Picture();
                             picture.TopLeftCorner.RowIndex     = msofbtClientAnchor.Row1;
                             picture.TopLeftCorner.ColIndex     = msofbtClientAnchor.Col1;
                             picture.TopLeftCorner.DX           = msofbtClientAnchor.DX1;
                             picture.TopLeftCorner.DY           = msofbtClientAnchor.DY1;
                             picture.BottomRightCorner.RowIndex = msofbtClientAnchor.Row2;
                             picture.BottomRightCorner.ColIndex = msofbtClientAnchor.Col2;
                             picture.BottomRightCorner.DX       = msofbtClientAnchor.DX2;
                             picture.BottomRightCorner.DY       = msofbtClientAnchor.DY2;
                             picture.Image = this.Book.ExtractImage(index);
                             this.pictures[picture.CellPos] = picture;
                             break;
                         }
                     }
                 }
             }
         }
     }
 }
Exemple #4
0
        private static Record EncodePictures(Dictionary <Pair <int, int>, Picture> pictures, SharedResource sharedResource, Worksheet worksheet)
        {
            MSODRAWING        msoDrawing  = new MSODRAWING();
            MsofbtDgContainer dgContainer = new MsofbtDgContainer();

            msoDrawing.EscherRecords.Add(dgContainer);

            MsofbtDg dg = new MsofbtDg();

            dg.Instance    = 1;
            dg.NumShapes   = pictures.Count + 1;
            dg.LastShapeID = 1024 + pictures.Count;
            dgContainer.EscherRecords.Add(dg);

            MsofbtSpgrContainer spgrContainer = new MsofbtSpgrContainer();

            dgContainer.EscherRecords.Add(spgrContainer);

            MsofbtSpContainer spContainer0 = new MsofbtSpContainer();

            spContainer0.EscherRecords.Add(new MsofbtSpgr());
            MsofbtSp shape0 = new MsofbtSp();

            shape0.ShapeId = 1024;
            shape0.Flags   = ShapeFlag.Group | ShapeFlag.Patriarch;
            shape0.Version = 2;
            spContainer0.EscherRecords.Add(shape0);
            spgrContainer.EscherRecords.Add(spContainer0);

            foreach (Picture pic in pictures.Values)
            {
                if (!sharedResource.Images.Contains(pic.Image))
                {
                    sharedResource.Images.Add(pic.Image);
                }
                MsofbtSpContainer spContainer = new MsofbtSpContainer();
                MsofbtSp          shape       = new MsofbtSp();
                shape.Version   = 2;
                shape.ShapeType = ShapeType.PictureFrame;
                shape.ShapeId   = 1024 + spgrContainer.EscherRecords.Count;
                shape.Flags     = ShapeFlag.Haveanchor | ShapeFlag.Hasshapetype;
                spContainer.EscherRecords.Add(shape);

                MsofbtOPT opt = new MsofbtOPT();
                opt.Add(PropertyIDs.LockAgainstGrouping, 33226880);
                opt.Add(PropertyIDs.FitTextToShape, 262148);
                opt.Add(PropertyIDs.BlipId, (uint)sharedResource.Images.IndexOf(pic.Image) + 1);
                spContainer.EscherRecords.Add(opt);

                MsofbtClientAnchor anchor = new MsofbtClientAnchor();
                anchor.Row1      = pic.TopLeftCorner.RowIndex;
                anchor.Col1      = pic.TopLeftCorner.ColIndex;
                anchor.DX1       = pic.TopLeftCorner.DX;
                anchor.DY1       = pic.TopLeftCorner.DY;
                anchor.Row2      = pic.BottomRightCorner.RowIndex;
                anchor.Col2      = pic.BottomRightCorner.ColIndex;
                anchor.DX2       = pic.BottomRightCorner.DX;
                anchor.DY2       = pic.BottomRightCorner.DY;
                anchor.ExtraData = new byte[0];
                spContainer.EscherRecords.Add(anchor);

                spContainer.EscherRecords.Add(new MsofbtClientData());

                spgrContainer.EscherRecords.Add(spContainer);
            }
            return(msoDrawing);
        }
        private static Record EncodePictures(Dictionary<Pair<int, int>, Picture> pictures, SharedResource sharedResource, Worksheet worksheet)
        {
            MSODRAWING msoDrawing = new MSODRAWING();
            MsofbtDgContainer dgContainer = new MsofbtDgContainer();
            msoDrawing.EscherRecords.Add(dgContainer);

            MsofbtDg dg = new MsofbtDg();
            dg.Instance = 1;
            dg.NumShapes = pictures.Count + 1;
            dg.LastShapeID = 1024 + pictures.Count;
            dgContainer.EscherRecords.Add(dg);

            MsofbtSpgrContainer spgrContainer = new MsofbtSpgrContainer();
            dgContainer.EscherRecords.Add(spgrContainer);

            MsofbtSpContainer spContainer0 = new MsofbtSpContainer();
            spContainer0.EscherRecords.Add(new MsofbtSpgr());
            MsofbtSp shape0 = new MsofbtSp();
            shape0.ShapeId = 1024;
            shape0.Flags = ShapeFlag.Group | ShapeFlag.Patriarch;
            shape0.Version = 2;
            spContainer0.EscherRecords.Add(shape0);
            spgrContainer.EscherRecords.Add(spContainer0);

            foreach (Picture pic in pictures.Values)
            {
                if (!sharedResource.Images.Contains(pic.Image))
                {
                    sharedResource.Images.Add(pic.Image);
                }
                MsofbtSpContainer spContainer = new MsofbtSpContainer();
                MsofbtSp shape = new MsofbtSp();
                shape.Version = 2;
                shape.ShapeType = ShapeType.PictureFrame;
                shape.ShapeId = 1024 + spgrContainer.EscherRecords.Count;
                shape.Flags = ShapeFlag.Haveanchor | ShapeFlag.Hasshapetype;
                spContainer.EscherRecords.Add(shape);

                MsofbtOPT opt = new MsofbtOPT();
                opt.Add(PropertyIDs.LockAgainstGrouping, 33226880);
                opt.Add(PropertyIDs.FitTextToShape, 262148);
                opt.Add(PropertyIDs.BlipId, (uint)sharedResource.Images.IndexOf(pic.Image) + 1);
                spContainer.EscherRecords.Add(opt);

                MsofbtClientAnchor anchor = new MsofbtClientAnchor();
                anchor.Row1 = pic.TopLeftCorner.RowIndex;
                anchor.Col1 = pic.TopLeftCorner.ColIndex;
                anchor.DX1 = pic.TopLeftCorner.DX;
                anchor.DY1 = pic.TopLeftCorner.DY;
                anchor.Row2 = pic.BottomRightCorner.RowIndex;
                anchor.Col2 = pic.BottomRightCorner.ColIndex;
                anchor.DX2 = pic.BottomRightCorner.DX;
                anchor.DY2 = pic.BottomRightCorner.DY;
                anchor.ExtraData = new byte[0];
                spContainer.EscherRecords.Add(anchor);

                spContainer.EscherRecords.Add(new MsofbtClientData());

                spgrContainer.EscherRecords.Add(spContainer);
            }
            return msoDrawing;
        }