Free Support Forum - aspose.com

Insert image into Aspose.Cells from base 64string

Hello,

I am interested into inserting an image into Excel from base64string representation. From what I saw the current Aspose.Cells you can insert an image from a file path. Would it be possible to get it from base64string so that we aren’t force to write to disk the image before inserting it to Excel.
Maybe I missed the API that does this but your feedback would be great.
Thanks,
Daniel

Hi Daniel,


Thank you for considering Aspose APIs.

Aspose.Cells APIs can load images from Stream objects that means you can convert the Base64 string to Stream and insert it in spreadsheets using Aspose.Cells APIs. Please check the following code to achieve the same.

C#

string base64string = “iVBORw0KGgoAAAANSUhEUgAAACQAAAAkCAQAAABLCVATAAACH0lEQVR42q3WoZKrMBQGYGRkIpHEoY9DMrh1nUGtzxPcGV7gCsTaK3iBCqa2ipmrVqLrWrmytjL3nBwoEGD30ja/6JaSj/wp3SEIXjpUoB+Oeg0zpoR+NsyoDVOgi39cbYHAy4MQTc0wOYZepxRBUkn9UxxEiNnXxyYwd6w/438hSddHJilv1tqv664Shle1DeJaJihPV9uNQ+NWBRK2QVSr+GjtaFzOIpdjKFShnoY+Gv0N0u0OVLexY48NQ+68JchdpQu/o1piVMu6faJdwjNWIAYyl55bqGUtbndO53TzCIpUpCkdlEm+V3J3Ir8r3uops2+FkTmvx832IGJwN97xS/5Ti0LQ/WLwtbxMal2ueAwvc2c8CAgSJip5U4+tKHECMlUzq2UcA9EyROuJi6/71dtzWAfVcq0Jw1CsYh13kDDteVoirE+zWtLVinQ8ZAS5YlVlvRHWfi3pakUQL0OOwmp/W/vN6Gt5zBIkzEezxnCtMJsxDIECTYmhp3bej4HHzaalNMyAnzE0UBKp6Z1Do2pwd3JkAH6CxlTs/bZOZ661yMwhohDLQqREMWz8UAvWoUQleggehG5dSPUbv28GJlnKHGJsqPi7vuG/MGTyCGslOtkCOayrGOa/indajdudb6FUpXoepgiLHIIMriddyzrkMBhGAqlOH4U2hKCT2j0NdU8jFbzpZ3LQlh9srPqEQ1Y9lEP2CVa99KHvH8mnrGGdl9V9AAAAAElFTkSuQmCC”;
byte[] fileBytes = Convert.FromBase64String(base64string);
Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];
using (MemoryStream stream = new MemoryStream(fileBytes))
{
sheet.Pictures.Add(0, 0, stream);
}
book.Save(“D:/output.xlsx”);