PictureCollection.Add

Add(int, int, int, int, Stream)

Adds a picture to the collection.

public int Add(int upperLeftRow, int upperLeftColumn, int lowerRightRow, int lowerRightColumn, 
    Stream stream)

Parameter	Type	Description
upperLeftRow	Int32	Upper left row index.
upperLeftColumn	Int32	Upper left column index.
lowerRightRow	Int32	Lower right row index
lowerRightColumn	Int32	Lower right column index
stream	Stream	Stream object which contains the image data.

Return Value

Picture object index.

Examples

using System;
using System.IO;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class PictureCollectionMethodAddWithInt32Int32Int32Int32StreamDemo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            // Add a picture from stream
            using (FileStream fs = new FileStream("image.jpg", FileMode.Open))
            {
                worksheet.Pictures.Add(10, 10, 200, 200, fs);
            }

            // Save the workbook
            workbook.Save("output.xlsx");
        }
    }
}

See Also

• class PictureCollection
• namespace Aspose.Cells.Drawing
• assembly Aspose.Cells

---

Add(int, int, int, int, string)

Adds a picture to the collection.

public int Add(int upperLeftRow, int upperLeftColumn, int lowerRightRow, int lowerRightColumn, 
    string fileName)

Parameter	Type	Description
upperLeftRow	Int32	Upper left row index.
upperLeftColumn	Int32	Upper left column index.
lowerRightRow	Int32	Lower right row index
lowerRightColumn	Int32	Lower right column index
fileName	String	Image filename.

Return Value

Picture object index.

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Drawing;

namespace AsposeCellsExamples
{
    public class PictureCollectionMethodAddWithInt32Int32Int32Int32StringDemo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            PictureCollection pictures = worksheet.Pictures;
            pictures.Add(1, 1, 5, 5, "image.jpg");

            workbook.Save("output.xlsx");
        }
    }
}

See Also

• class PictureCollection
• namespace Aspose.Cells.Drawing
• assembly Aspose.Cells

---

Add(int, int, Stream)

Adds a picture to the collection.

public int Add(int upperLeftRow, int upperLeftColumn, Stream stream)

Parameter	Type	Description
upperLeftRow	Int32	Upper left row index.
upperLeftColumn	Int32	Upper left column index.
stream	Stream	Stream object which contains the image data.

Return Value

Picture object index.

Examples

using System;
using System.IO;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class PictureCollectionMethodAddWithInt32Int32StreamDemo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            // Add a picture from stream
            using (FileStream fs = new FileStream("image.jpg", FileMode.Open))
            {
                worksheet.Pictures.Add(1, 1, fs);
            }

            // Save the workbook
            workbook.Save("output.xlsx");
        }
    }
}

See Also

• class PictureCollection
• namespace Aspose.Cells.Drawing
• assembly Aspose.Cells

---

Add(int, int, string)

Adds a picture to the collection.

public int Add(int upperLeftRow, int upperLeftColumn, string fileName)

Parameter	Type	Description
upperLeftRow	Int32	Upper left row index.
upperLeftColumn	Int32	Upper left column index.
fileName	String	Image filename.

Return Value

Picture object index.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class PictureCollectionMethodAddWithInt32Int32StringDemo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            Aspose.Cells.Drawing.PictureCollection pictures = worksheet.Pictures;
            pictures.Add(1, 1, "image.jpg");

            workbook.Save("output.xlsx");
        }
    }
}

See Also

• class PictureCollection
• namespace Aspose.Cells.Drawing
• assembly Aspose.Cells

---

Add(int, int, Stream, int, int)

Adds a picture to the collection.

public int Add(int upperLeftRow, int upperLeftColumn, Stream stream, int widthScale, 
    int heightScale)

Parameter	Type	Description
upperLeftRow	Int32	Upper left row index.
upperLeftColumn	Int32	Upper left column index.
stream	Stream	Stream object which contains the image data.
widthScale	Int32	Scale of image width, a percentage.
heightScale	Int32	Scale of image height, a percentage.

Return Value

Picture object index.

Examples

[C#]
//add a picture
using (FileStream fs = new FileStream("image.jpg", FileMode.Open))
{
    pictures.Add(1, 1, fs, 50, 50);
}

See Also

• class PictureCollection
• namespace Aspose.Cells.Drawing
• assembly Aspose.Cells

---

Add(int, int, string, int, int)

Adds a picture to the collection.

public int Add(int upperLeftRow, int upperLeftColumn, string fileName, int widthScale, 
    int heightScale)

Parameter	Type	Description
upperLeftRow	Int32	Upper left row index.
upperLeftColumn	Int32	Upper left column index.
fileName	String	Image filename.
widthScale	Int32	Scale of image width, a percentage.
heightScale	Int32	Scale of image height, a percentage.

Return Value

Picture object index.

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Drawing;

namespace AsposeCellsExamples
{
    public class PictureCollectionMethodAddWithInt32Int32StringInt32Int32Demo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            PictureCollection pictures = worksheet.Pictures;
            pictures.Add(1, 1, "image.jpg", 50, 50);

            workbook.Save("output.xlsx");
        }
    }
}

See Also

• class PictureCollection
• namespace Aspose.Cells.Drawing
• assembly Aspose.Cells