//ЗАПИСЬ КАРТИНКИ В ЯЧЕЙКУ public void AddPicture(string path, string cellAdress) { SelectCells(cellAdress, cellAdress); _p = _xlWorkSheet.Pictures(_misValue) as Excel.Pictures; _pic = _p.Insert(path, _misValue); _pic.Left = Convert.ToDouble(_range.Left); _pic.Top = Convert.ToDouble(_range.Top); }
/// <summary> /// 插入图片 /// </summary> /// <param name="sheet"> 工作表 </param> /// <param name="imageFilePath"> 图片的绝对路径 </param> /// <param name="rowNumber"> 单元格行号 </param> /// <param name="columnNumber"> 单元格列号 </param> /// <param name="width"> 图片的宽度 </param> /// <param name="height"> 图片的高度 </param> /// <returns></returns> public Xls.Picture AddImage(Xls.Worksheet sheet, string imageFilePath, int rowNumber, int columnNumber, double width, double height) { Xls.Picture pic = this.AddImage(sheet, imageFilePath, rowNumber, columnNumber); pic.Width = width; pic.Height = height; return(pic); }
/// <summary> /// 插入图片 /// </summary> /// <param name="sheet"> 工作表 </param> /// <param name="imageFilePath"> 图片的绝对路径 </param> /// <param name="rowNumber"> 单元格行号 </param> /// <param name="columnNumber"> 单元格列号 </param> /// <returns></returns> public Xls.Picture AddImage(Xls.Worksheet sheet, string imageFilePath, int rowNumber, int columnNumber) { Xls.Range range = this.GetRange(sheet, rowNumber, columnNumber, rowNumber, columnNumber); range.Select(); Xls.Pictures pics = sheet.Pictures(_missing) as Xls.Pictures; Xls.Picture pic = pics.Insert(imageFilePath, _missing); pic.Left = (double)range.Left; pic.Top = (double)range.Top; return(pic); }
public void InsertPicture(int iRowStart, int iColStart, string imgPath, double imgWidth, double imgHeight) { object misValue = System.Reflection.Missing.Value; Excel.Range rangeObj = (Excel.Range)worksheet.Cells[iRowStart, iColStart]; Excel.Pictures imgObjCollection = worksheet.Pictures(misValue) as Excel.Pictures; Excel.Picture imgObj = null; imgObj = imgObjCollection.Insert(imgPath, misValue); imgObj.Left = Convert.ToDouble(rangeObj.Left) + (Convert.ToDouble(rangeObj.Width) - imgWidth) / 2; imgObj.Top = Convert.ToDouble(rangeObj.Top); imgObj.Width = imgWidth; imgObj.Height = imgHeight; }
/// <summary> /// Chn 插入图片 /// </summary> /// <param name="workSheet"></param> /// <param name="picturePath"></param> /// <param name="picLeft"></param> /// <param name="picTop"></param> /// <returns></returns> public static Excel.Picture InsertPictureByPicture(this Excel.Worksheet workSheet, string picturePath, float picLeft, float picTop) { Size picSize = ImageHelper.GetDimensions(picturePath); int picWidth = picSize.Width; int picHeight = picSize.Height; Excel.Pictures pics = (Excel.Pictures)workSheet.Pictures(Type.Missing); Excel.Picture pic = pics.Insert(picturePath, Type.Missing); pic.Left = (double)picLeft; pic.Top = (double)picTop; pic.Width = (double)picWidth; pic.Height = (double)picHeight; return(pic); }
//«јѕ»—№ ј–“»Ќ » ¬ я„≈… ” public void WritePictureToCell(string path) { p = xlWorkSheet.Pictures(misValue) as Excel.Pictures; pic = p.Insert(path, misValue); pic.Left = Convert.ToDouble(range.Left); pic.Top = Convert.ToDouble(range.Top); }
//ЗАПИСЬ КАРТИНКИ В ЯЧЕЙКУ public void WritePictureToCell(string path) { _p = _xlWorkSheet.Pictures(_misValue) as Excel.Pictures; _pic = _p.Insert(path, _misValue); _pic.Left = Convert.ToDouble(_range.Left); _pic.Top = Convert.ToDouble(_range.Top); }