/*转载请注明出处 谢谢*/
研究了下Aspose.cells 操作Excel代码 总结下大致的使用
1、 Aspose.cells 插入图片(HTTP 方式)
private void button1_Click(object sender, EventArgs e)
{
System.IO.MemoryStream objImage;
System.Net.WebClient objwebClient;
string sURL = "http://127.0.0.1/45C.jpg"; //采用的http访问图片的方式
objwebClient = new System.Net.WebClient();
objImage = new System.IO.MemoryStream(objwebClient.DownloadData(sURL));
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(); //
Aspose.Cells.Worksheet sheet = wb.Worksheets[0];
Aspose.Cells.Drawing.PictureCollection pictures = sheet.Pictures;
pictures.Add(0, 0,3,3 ,objImage);
wb.Save("d:\\sysdata\\webimagebook.xls");
}