Insert image into cell

[Mark Jayvee]

Hi,

how can I insert an image into a selected cell?

regards,

Mark

[Arulpriya Ramalingam]

Hi Mark, 

 

To load image in the selected cell range, the AddImage method can be used. We already provided the details in our user guide to load images in spreadsheet with specific cell range. Please make use of the below code and UG for further reference. 

 

Example code 

 

var worksheet = spreadsheet.ActiveSheet; 

Image img = Image.FromFile(@"..\..\Icon\syncfusion.png"); 

Stream stream = new MemoryStream(); 

img.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);  

var shape = spreadsheet.AddImage(worksheet, spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex, stream); 

 

UG link: https://help.syncfusion.com/windowsforms/spreadsheet/shapes#pictures 

 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/CS_(6)958530045 

 

Please get back to us if you have any other queries. 

 

Regards, 

Arulpriya Ramalingam 

[Mark Jayvee]

Thank you for the response.

It works importing the image to the spreadsheet but the image size is with its original scale.

How can I import the image that autofit to the current cell?

[Arulpriya Ramalingam]

Hi Mark, 

 

The Spreadsheet does not have built-in support to auto fit the image into cell. However, the Height and Width properties of Shape can be used to update the size manually for provided image based on our requirement. Please make use of below code and modified sample. 

 

Example code 

 

var worksheet = spreadsheet.ActiveSheet; 

Image img = Image.FromFile(@"..\..\Icon\syncfusion.png"); 

Stream stream = new MemoryStream(); 

img.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);  

var shape = spreadsheet.AddImage(worksheet, spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex, stream); 

 

//Re-sizing a Picture 

shape.Height = (int)spreadsheet.ActiveGrid.RowHeights[spreadsheet.ActiveGrid.CurrentCell.RowIndex]; 

shape.Width = (int)spreadsheet.ActiveGrid.ColumnWidths[spreadsheet.ActiveGrid.CurrentCell.ColumnIndex]; 

//To invalidate the image cell. 

spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicVisual(true); 

spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicObjects(); 

 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/CS_(7)-1419731175 

 

Regards, 

Arulpriya Ramalingam 

[Mark Jayvee]

Thank you for the response.

I tried the code and import successfully. Only issue is that it import to a random cell.

What I want to do is to import this image to the current selected cell.

Regards,

[Sampathnarayanan Sankaralingam]

Hi Mark,

Please find the below code snippet to load image in the current selected cell.

var worksheet = spreadsheet.ActiveSheet;

Image img = Image.FromFile(@"..\..\Icon\syncfusion.png");

Stream stream = new MemoryStream();

img.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);

BitmapShapeImpl shape = spreadsheet.AddImage(worksheet, spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex, stream) as BitmapShapeImpl;

if (shape != null)

{

shape.LeftColumn = spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex.ColumnIndex - 1;

shape.TopRow = spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex.RowIndex;

shape.EvaluateTopLeftPosition();

}

//Re-sizing a Picture

shape.Height = (int)spreadsheet.ActiveGrid.RowHeights[spreadsheet.ActiveGrid.CurrentCell.RowIndex];

shape.Width = (int)spreadsheet.ActiveGrid.ColumnWidths[spreadsheet.ActiveGrid.CurrentCell.ColumnIndex];

spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicVisual(true);

spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicObjects();

Sample Link : https://www.syncfusion.com/downloads/support/forum/171117/ze/CS670463001

Regards,

Sampath Narayanan.S

[Mark Jayvee]

Hi  Sampath Narayanan.S,

Thank you for the response. It works as tested.

One last question, How can I consider if the image is imported in a Merge Cell?

[Sampathnarayanan Sankaralingam]

Hi Mark, 

 

We are unable to understand the exact requirement with merged cells. We are able to inset image to merged cells. Kindly revert to us with more details about your requirement with image illustration. So that we can understand the exact scenario and provide a prompt solution. 

 

Regards, 

Sampath Narayanan.S 

[Mark Jayvee]

Hi Sampath Narayanan.S,

Thank you for your email.

Insert image into 1 selected cell is working well with size is alsi correct.

Could you please merge like 4 cells and try to import the image? It can import but the size is not matching?

[Sampathnarayanan Sankaralingam]

Hi Mark, 

 

Please find the below code snippet to autofit image into the merge cell. 

 

Code Snippet 

var worksheet = spreadsheet.ActiveSheet; 

 

 

Image img = Image.FromFile(@"..\..\Icon\syncfusion.png"); 

Stream stream = new MemoryStream(); 

 

img.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg); 

BitmapShapeImpl shape = spreadsheet.AddImage(worksheet, spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex, stream) as BitmapShapeImpl; 

 

if (shape != null) 

{ 

    shape.LeftColumn = spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex.ColumnIndex - 1; 

    shape.TopRow = spreadsheet.ActiveGrid.CurrentCell.CellRowColumnIndex.RowIndex; 

    shape.EvaluateTopLeftPosition(); 

} 

 

if (spreadsheet.ActiveSheet.Range[spreadsheet.ActiveGrid.CurrentCell.RowIndex, spreadsheet.ActiveGrid.CurrentCell.ColumnIndex].IsMerged) 

{ 

    if (spreadsheet.ActiveSheet.MergedCells != null) 

    { 

        double height = 0.0; 

        double width = 0.0; 

        for (int i = 0; i < spreadsheet.ActiveSheet.MergedCells.Length; i++) 

        { 

            IRange curRange = spreadsheet.ActiveSheet.MergedCells[i]; 

            GridRangeInfo mergdRange = GridRangeInfo.Cells(curRange.Row, curRange.Column, curRange.LastRow, curRange.LastColumn); 

            if (mergdRange.IntersectsWith(GridRangeInfo.Cell(spreadsheet.ActiveGrid.CurrentCell.RowIndex, spreadsheet.ActiveGrid.CurrentCell.ColumnIndex))) 

            { 

                for (int j = mergdRange.Left; j <= mergdRange.Right; j++) 

                { 

                    width += (int)spreadsheet.ActiveGrid.ColumnWidths[j]; 

                } 

 

                for (int k = mergdRange.Top; k <= mergdRange.Bottom; k++) 

                { 

                    height += (int)spreadsheet.ActiveGrid.RowHeights[k]; 

                } 

            } 

        } 

 

        shape.Height = (int)height; 

        shape.Width = (int)width; 

    } 

} 

else 

{ 

    //Re-sizing a Picture 

    shape.Height = (int)spreadsheet.ActiveGrid.RowHeights[spreadsheet.ActiveGrid.CurrentCell.RowIndex]; 

    shape.Width = (int)spreadsheet.ActiveGrid.ColumnWidths[spreadsheet.ActiveGrid.CurrentCell.ColumnIndex]; 

} 

 

spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicVisual(true); 

spreadsheet.ActiveGrid.GraphicModel.InvalidateGraphicObjects(); 

Sample Link : https://www.syncfusion.com/downloads/support/forum/171117/ze/SpreadSheet_Demo-1752847738 

 

Regards, 

Sampath Narayanan.S