Devexpress SpreadSheet 如何在工作表中插入图片

基于文件流法：

workbook.BeginUpdate();// Set the measurement unit to Millimeter.workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter;try{    Worksheet worksheet = workbook.Worksheets[0];    // Insert a picture from a file so that its top left corner is in the specified cell.    // By default the picture is named Picture 1.. Picture NN.    worksheet.Pictures.AddPicture("Pictures\\x-docserver.png", worksheet.Cells["A1"]);    // Insert a picture at 70 mm from the left, 40 mm from the top,     // and resize it to a width of 85 mm and a height of 25 mm, locking the aspect ratio.    worksheet.Pictures.AddPicture("Pictures\\x-docserver.png", 70, 40, 85, 25, true);    // Insert the picture to be removed.    worksheet.Pictures.AddPicture("Pictures\\x-docserver.png", 0, 0);    // Remove the last inserted picture.    // Find the shape by its name. The method returns a collection of shapes with the same name.    Picture picShape = worksheet.Pictures.GetPicturesByName("Picture 3")[0];    picShape.Delete();}finally{    workbook.EndUpdate();}

基于URL法：

string imageUri = "https://www.devexpress.com/Products/NET/Controls/WinForms/spreadsheet/i/winforms-spreadsheet-control.png";// Create an image from Uri.SpreadsheetImageSource imageSource = SpreadsheetImageSource.FromUri(imageUri, workbook);// Set the measurement unit to point.workbook.Unit = DevExpress.Office.DocumentUnit.Point;workbook.BeginUpdate();try{    Worksheet worksheet = workbook.Worksheets[0];    // Insert a picture from the SpreadsheetImageSource at 100 pt from the left, 40 pt from the top,     // and resize it to a width of 300 pt and a height of 200 pt.    worksheet.Pictures.AddPicture(imageSource, 100, 40, 300, 200);}finally{    workbook.EndUpdate();}

如何修改：

workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter;workbook.BeginUpdate();try{    Worksheet worksheet = workbook.Worksheets[0];    // Insert pictures from the file.    Picture pic = worksheet.Pictures.AddPicture("Pictures\\x-docserver.png", worksheet.Cells["A1"]);    // Specify picture name and draw a border.    pic.Name = "Logo";    pic.AlternativeText = "Spreadsheet Logo";    pic.BorderWidth = 1;    pic.BorderColor = DevExpress.Utils.DXColor.Black;    // Move a picture.    pic.Move(20, 30);    // Change picture behavior so it will move and size with underlying cells.     pic.Placement = Placement.MoveAndSize;    worksheet.Rows[5].Height += 10;    worksheet.Columns["D"].Width += 10;    // Specify rotation angle.    pic.Rotation = 30;    // Add a hyperlink.    pic.InsertHyperlink("http://www.devexpress.com/Products/NET/Document-Server/", true);}finally{    workbook.EndUpdate();}