请问如何往单元格加入图片呢？

收藏

winform的，不是webform的。就是双击单元格，然后弹出图片选择，然后把图片插入到该单元格？
能给一段示范代码吗？

ZenosZeng · ZenosZeng

回复 1楼youitlyang的帖子

请参考以下代码：

private void Form1_Load(object sender, EventArgs e)
{
FarPoint.Win.Spread.CellType.ImageCellType imgct = new FarPoint.Win.Spread.CellType.ImageCellType();
System.Drawing.Image image = System.Drawing.Image.FromFile("Man.png");
imgct.Style = FarPoint.Win.RenderStyle.Stretch;
imgct.TransparencyColor = Color.Black;
imgct.TransparencyTolerance = 20;
fpSpread1.Sheets[0].Columns[1, 2].Width = 100;
fpSpread1.Sheets[0].Rows[1, 1].Height = 50;
fpSpread1.Sheets[0].Cells[1, 1].CellType = imgct;
fpSpread1.Sheets[0].Cells[1, 1].Value = image;
}
private void fpSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
if (fpSpread1.ActiveSheet.ActiveCell.CellType is FarPoint.Win.Spread.CellType.ImageCellType)
{
OpenFileDialog dlgOpen = new OpenFileDialog();
dlgOpen.Filter = "*.jpeg|*.png";
if (dlgOpen.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
fpSpread1.ActiveSheet.ActiveCell.Value = System.Drawing.Image.FromFile(dlgOpen.FileName);
}
}
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] 请问如何往单元格加入图片呢？