DataGridView导出到EXCEl后再Excel中插入固定标题图片的代码???急求啊! 从DataGridView导出到Excel后再Excel头部插入C盘下的一张图片怎么办代码怎么写啊??各位有知道的指点下 谢啦!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public void InsertPicture( string RangeName, string PicturePath ) { m_objRange = m_objSheet.get_Range(RangeName, m_objOpt); m_objRange.Select(); Excel.Pictures pics = (Excel.Pictures)m_objSheet.Pictures(m_objOpt); pics.Insert(PicturePath, m_objOpt); } public void InsertPicture( string RangeName, string PicturePath, float PictuteWidth, float PictureHeight ) { m_objRange = m_objSheet.get_Range(RangeName, m_objOpt); m_objRange.Select(); float PicLeft, PicTop; PicLeft = Convert.ToSingle(m_objRange.Left); PicTop = Convert.ToSingle(m_objRange.Top); m_objSheet.Shapes.AddPicture(PicturePath, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, PicLeft, PicTop, PictuteWidth, PictureHeight); } 或 sheet.Shapes.AddPicture("C:""a.gif", Microsoft.Office.Core.MsoTriState.msoCTrue, Microsoft.Office.Core.MsoTriState.msoCTrue, 250, 0, 70, 30); 如何通过代码连接远程OPC服务器? session对象什么情况下容易丢失 API WriteFile和readFile 返回错误:无效句柄 如何让PDA上的时间等于某个值 求解ADO.NET中更新数据库的操作 怎么调用USB口的打印机,打印东西?(以前是LPT1口的) 如何从一个图标的句柄获得这个图标的具体路径 C# 精确的代码,其中一点小问题 那位大哥知道如何通过程序配置ODBC 软件MapInfo如何更新列 帮我写个c#版的http代理程序
{
m_objRange = m_objSheet.get_Range(RangeName, m_objOpt);
m_objRange.Select();
Excel.Pictures pics = (Excel.Pictures)m_objSheet.Pictures(m_objOpt);
pics.Insert(PicturePath, m_objOpt);
}
public void InsertPicture( string RangeName, string PicturePath, float PictuteWidth, float PictureHeight )
{
m_objRange = m_objSheet.get_Range(RangeName, m_objOpt);
m_objRange.Select();
float PicLeft, PicTop;
PicLeft = Convert.ToSingle(m_objRange.Left);
PicTop = Convert.ToSingle(m_objRange.Top);
m_objSheet.Shapes.AddPicture(PicturePath, Microsoft.Office.Core.MsoTriState.msoFalse,
Microsoft.Office.Core.MsoTriState.msoTrue, PicLeft, PicTop, PictuteWidth, PictureHeight);
} 或
sheet.Shapes.AddPicture("C:""a.gif", Microsoft.Office.Core.MsoTriState.msoCTrue, Microsoft.Office.Core.MsoTriState.msoCTrue, 250, 0, 70, 30);