Images in Worksheets

Aug 21, 2014 at 11:16 PM
Edited Aug 21, 2014 at 11:22 PM
I need put some imagen in my Worksheets, but the problem is when the sheet end,, because the next images appear in the middle of the page i need put the next images in the top of the next sheet
I have this..


var ws = wb.Workbook.Worksheets.Add("OrdenInspeccion");
        for (int i =0; i<10;i++)
        {
        Image logo =
            Image.FromFile(
                "C:\\Header-0.jpg");
        var picture = ws.Drawings.AddPicture(i.ToString(), logo);
        //position picture on desired column
            if(i%2==0)
            {
                 rango = i*210;
                picture.SetPosition(rango,1);
            }
            else
            { picture.SetPosition(rango,420); }


        //set picture size to fit inside the cell
        picture.SetSize(150, 150);
            currentRow ++;