Hello,
API documentation says that there is not "getCellAddressString" method exposed by the topLeftCornerCell. You should instead pass a cell object to it as follows:
imageShape.topLeftCornerCell(sheet.getCell('C9'));
Please let me know if this solves the situation.
Thanks for the reply, but it does not solve the problem. It shows the below error
Cannot call method 'getHashCode' of null
Please help asap
Thanks,
Hi,
I am currently investigating this error and will update once I have more information.
Okay. Please give some solution as soon as possible.
You can track the status of the issue in the following case CAS*175080*K2G2H9
I have been facing the same issue, has this issue been fixed already?
To allow for a way to construct a WorksheetImage, there is the ability for the constructor to take a data url for a base 64 encoded image. Image element cannot be passed in order to create a WorksheetImage. Passing image need to be handled by the developer - e.g. handle the load of the image to wait for the image to be available, then draw that image into a canvas and then use the toDataUrl to have it create a data url that they could then use when creating a WorksheetImage. So to get the sample that was attached to work we need to convert the image to a base 64 image string.e.g.var image = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQUAAAAlCAMAAAB8kwwhAAABCFBMVEUAAAABmf9mZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmYBmf9mZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmYBmP9mZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmZmYCmf8Bmf8Cmf8Cmf8AmP9mZmYBmf////8Ajf8JmP/G4/8Alv8Ai/+p1v/u9/8Aj/+Wzv/O5/8anP8Ak/+Lxv8fnP8Ae//h8f9mtf90u/8Afv+i0v/U6//B4v+63/8Ahv9Mq/97wv9ovP/P6v9hs//azDGiAAAAOHRSTlMA8PjkOF4aQLqVj06ewqMG3bICCmU32FgVcexHD/Ijavs8H3jG8NPNmDAp5q1ShLaKf6n7OjTi4pWcsSAAAAeZSURBVGje5Zppe9JAEMdXQiEBwhUkCYGEq5yFAl7RYqtV0ar1Pr7/NzGzRyZXE330Vf3XRzab7DG/nZ3dDZBHdzwdH98RH8feHwovHpDbrHuP996fpz384/KTeH2f3GbdeRwXMkHdJbdZd9DYOAo/cespJNuNOf+RL1yegQ6vDmdCF+z/y/N9IgVbI/9CheTsrr1Ia6BmL4YkrrQC87kdbVo00c1zXzh8eAp6/+X907A+fXt8CFJoVZQN7cBIjvZSryjbJkuUfFV0IDaj6c1oFTVaGw9IVM2BotY7vU5bNvHxVUVR8jxd3E06veW0kqcXSikoZd0l3a0yGxGU0Wp4BXKd6U7XfASbsQRN6ITMS9sROYaxPnv7BPTh6sWTqD4zDHtGQXVdd0BxuFEMDdfN1SBx4gZ04mVY/lVvEy6kuzMSkaVi4Y4pcqveVYslFXG3D6Zu3YgKpJDzGmr6UEcS3my3WPtlP+/UsCoNhc2Iy5fU4hdXryMMIPMy4AunXuOUwpHrqgahwo4uazyBasB44WWE3djtYSVoI0rusuyZlz6KPWA2yTqBwtJ164LCYhy+XYLMvItSdc9jyTGYeJZC4e3+HH0BBjzPKbiqFqEgUQoV79ZE5RpxCp3xtO6C0FfZjW1o/u7YkDU225LcgeSEUVIEhSLNHJWdKbhWl+gqaAIXNHVqkIKEFGzW6LS6Xs/kJffNGjyeU1Y6Ha8jfbsix1m+8PzNOYCKUYDKCzdRGJCIsRVCjPIYcCA68CxX6obqABuP2CO2Ak3YYQpVyIMitRP3dEW4FjnPt3k6SMGgEE4sQjU06+6M9ydnMSuWpsFXSowLN1HYxykwxsYNFMpRClXaPxhe1iV0TD73/Up3iEXvzJokTAFA6iy0WwRr8ijICRR2Ee8zKhuI7MwnQBaFLNaI189A764Zhef06sMndvHqRl9Ab8im4PeqhSWY+9f8FUNy6ZCixHqIFGAiFAkqlUJRQEDBsEEsURJ2Ta++XF9fX11fnDEKP75cXFycXX9Np9CnNth/QkEJUrC9CmSv+75fmzBhACsqRkFlsyubAu8tZKOwHcmIUzj/+R709Quj8PEAhl+8S48LnVIOMAwz4wJSkIOANrDeeDljuBB31ySdgoLDm0lh6OX28wQVnIkyYkiMC0ghY0bMyy5QnSdQ2JR1qqM8pzCj8zznFReDbfQAgImRAqJGbp5BYZGj6+/idyisYMqSiPwdTV3HjMT9wkewO5uCRRzEEKKAqnIKY/1odNqH4Ee4tnR2DHt+/wc0SKRRwIDUmy2yKWxx/oc1ZOunivMW9gtI4QXbIhzO95kzAnybYVjmb6ZwQimg6sIVukvveY0+3WcYywCLpFPAfV9/VsiiMMMVKIrhlG+ZLJwRSOH621vQZ/SFDAqkRUdmEKWQ6+Wo+rMQhdyJH0xbfMc098PdKhTLFtM2l4UUmJWVvguS9AwK0BGHJMuRcC8ZpXABF2B0eEbsb6Dge2hnEKFgzvNURZtTaMNja5z1zTbfQEG5nB33BdzlHiEF/zyFd1IoKOgLcRnrDnPWZgKFcxBSyPAFkE4HeRCmUIyuEasRghelKkbBE9SkiLhQ93eW8wQKqEGDzopFKoWRiMrJGq6pT43iFPYMwJ9QICuoTCpsUvYLkDHBkeF7QDZreuBLBozOUlQOMsyRaZoQzfU4BW6iu0mlAM41ISkqStBzLe4LqKw1Ak21wJCxnEqhRde4/kAUccPaQqaMdgWjxyCRAilBo6kUYP3pF0mK8nRHEaHw+uoioKuvmRS4LLqIp1NgFtW7eI5C8TOVA/4xJEHtvPaGyRQWEG1SKPB9gUrSpEJfOYU9p/DxxTMUnCOyZoTQoJNJgZ8bTv3QN7GKXJDv8MXTVWtBS8G6ZpCCNioFKEzSKQy4m6Fs6ozWzg5QsEK+EFcmBcTQ+w0K3bYIDVVuFB4o2k2x7J50MY5PWUmkYNVZ5MWTYRoFUo1gWHXWXjca/lHE7oH3MQr7x5cfkwngjNinUyD5ZTYFku+ziWrn8L2COPXoPIHvF2pHbbjSkAILeEtauQ7cWxkUDLpAyyt6ZegndBA0cNxNV7yIGuMO+tPfUiBzKZsCMVkIUCLHJkt0RlPFu6Z1qQEWsNaQQm0KmeNqRWXRJIMCGbZdCva0ulPrYl00IVFvzBp0HpdxpfyePSP8qDYQFFYkgkGibVcTKeCozwrgh6ET9FScqbo7N6SOFX7vCPb6wvifd4MUOi70hGOQXZRAGcxTAifrw4ubMbw5oC/I+A4aKeAZpZZMgUc/ERqk2CkHmKqs4/o0YGZVRLGKH0jyE3G3XcSwBOUjFIRaUEAUYZNNq/otrAlS2J8fvn9+mqzPwZXSMp2WAQnbcVpDEtacndmLZuRWwWmZCxHZzZZTclpOgQSltbzqNJauWTO1LS2libyeo5mm49j8WUeeSMu2bHaDXzk4puVXpjuOHqy8XIEK6+PqSvPnYHUKObM5QQqA4fLsJrEHgEKWtBr5N9IKQyOlrlphqJE/Urcw5NCQ3NCIf0+5j39v/z99Z53yRTX//B8pCNv/K1+491sU9rf8tywPxS+X8JdNfgokPm7175p+AcQh0p+Lw6joAAAAAElFTkSuQmCC"; var imageShape = new $.ig.excel.WorksheetImage(image);"