Question

大家有使用 ComponentOne Winforms 平台 c1FlexGrid 控件的吗？如何导出图片至Excel？求帮助

Answer 1

我刚好在用这款控件，大体看了下，给你个解决方案:
c1FlexGrid1[2, 1] = "abc";
c1FlexGrid1.SetCellImage(2, 2, Image.FromFile(@"C:UsersPublicPicturesSample PicturesChrysanthemum.jpg"));
XLSheet sheet = c1XLBook1.Sheets[0];
sheet[2, 1-1].Value = c1FlexGrid1[2, 1];
int width = (int)(((double)sheet.DefaultColumnWidth) * (1.0 / 1440.0) * this.c1FlexGrid1.CreateGraphics().DpiY);
int height = (int)(((double)sheet.DefaultRowHeight) * (1.0 / 1440.0) * this.c1FlexGrid1.CreateGraphics().DpiY);
Bitmap img = new Bitmap(c1FlexGrid1.GetCellImage(2, 2), width, height);
sheet[2, 2-1].Value = img;
c1XLBook1.Save(@"C:MyExcel.xlsx");
System.Diagnostics.Process.Start(@"C:MyExcel.xlsx");

追问

不好意思，因为我是刚刚接触编程，能不能发个附件给我。求求 11258745