I have created a excel file, which will insert a series of images in a particluar location using vb.net,
the issue is the images is getting merged after some 100 images is inserted
Any suggesstions...
**********************************************************
This is part of code, which inserts a images in a excel,which is in the loop takes rownumber as postion(RowIndex), from the vb.net
If CType(ImagePath, String).IndexOf(".jpeg") <> -1 Or CType(ImagePath, String).IndexOf(".jpg") <> -1 Or _
CType(ImagePath, String).IndexOf(".JPEG") <> -1 Or CType(ImagePath, String).IndexOf(".JPG") <> -1 Then
fp.WriteLine(" Set p = XL.ActiveSheet.Pictures.Insert(" & Chr(34) & ImagePath.Replace("**", "") & Chr(34) & ") ")
Else
fp.WriteLine(" Set p = XL.ActiveSheet.Pictures.Insert(" & Chr(34) & ApplicationRoot & "images/noimage.jpg" & Chr(34) & ") ")
End If
fp.WriteLine(" p.Top = XL.Rows(" & Chr(34) & "1:" & RowIndex & Chr(34) & ").Height")
fp.WriteLine(" p.Left = 50 ")
fp.WriteLine(" p.Width = 100 ")
fp.WriteLine(" p.Height = 100 ")
**********************************************************
the issue is the images is getting merged after some 100 images is inserted
Any suggesstions...
**********************************************************
This is part of code, which inserts a images in a excel,which is in the loop takes rownumber as postion(RowIndex), from the vb.net
If CType(ImagePath, String).IndexOf(".jpeg") <> -1 Or CType(ImagePath, String).IndexOf(".jpg") <> -1 Or _
CType(ImagePath, String).IndexOf(".JPEG") <> -1 Or CType(ImagePath, String).IndexOf(".JPG") <> -1 Then
fp.WriteLine(" Set p = XL.ActiveSheet.Pictures.Insert(" & Chr(34) & ImagePath.Replace("**", "") & Chr(34) & ") ")
Else
fp.WriteLine(" Set p = XL.ActiveSheet.Pictures.Insert(" & Chr(34) & ApplicationRoot & "images/noimage.jpg" & Chr(34) & ") ")
End If
fp.WriteLine(" p.Top = XL.Rows(" & Chr(34) & "1:" & RowIndex & Chr(34) & ").Height")
fp.WriteLine(" p.Left = 50 ")
fp.WriteLine(" p.Width = 100 ")
fp.WriteLine(" p.Height = 100 ")
**********************************************************