Columns A-Y have various information about the house, and column Z has a picture of the house.
Var cellWidth = Convert.ToSingle() Īlthough Doug Glancy is correct in stating that Excel does not consider a picture to be "inside" of a cell, a picture can be associated with a particular cell and will act intuitively if correctly placed.įor example, say you have a list of houses. Public float FloatLeftPixelsCalculation(int rowNumber)įor (var columnNumber = 1 columnNumber < ColumnIndex columnNumber++) Public float FloatTopPixelsCalculation(int rowNumber)įor (var rNumber = 1 rNumber < rowNumber rNumber++) (urlCellValue, MsoTriState.msoFalse, MsoTriState.msoTrue, floatLeft, floatTop, PictureWidth, PictureHeight) Var floatTop = FloatTopPixelsCalculation(rowNumber) Here is my workaround: var floatLeft = FloatLeftPixelsCalculation(rowNumber) Of course, I have no problem with that (I created some kind of workaround), however, I'd like to ask whether my approach to solve this problem is right or if there is some other method where I could insert image into cell. When I use (), I have to calculate coordinates where to put my picture. My main problem though is that I cannot find a way to insert a picture exactly into cell. My task is to put picture from URL into certain cell in excel worksheet.
0 kommentar(er)
