62,074
社区成员
发帖
与我相关
我的任务
分享
private Application m_excel;
private Workbook m_workbook;
m_excel = new Microsoft.Office.Interop.Excel.Application();
m_workbook = m_excel.Workbooks.Open(URL.Replace("/", @"\"),
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
m_excel.Visible = true;//自动打开Excel
xSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_workbook.Sheets[1];
pic2 = (Microsoft.Office.Interop.Excel.Range)m_excel.get_Range("A4", Missing.Value);
pic2.Select();
float picleft, pictop;
picleft = Convert.ToSingle(pic2.Left);
pictop = Convert.ToSingle(pic2.Top);
xSheet.Shapes.AddPicture(URL2.Replace("/", @"\"), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, 2, 2, 100, 100);
sheet.Shapes.AddPicture(ds.Tables[0].Rows[row][col].ToString(), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, Convert.ToSingle(range.Left) + 15 + image.Width, Convert.ToSingle(range.Top) + 5, image.Width, image.Height); //插入图片
http://blog.csdn.net/happy09li/article/details/7431967 sheet.Shapes.AddPicture(ds.Tables[0].Rows[row][col].ToString(), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, Convert.ToSingle(range.Left) + 15 + image.Width, Convert.ToSingle(range.Top) + 5, image.Width, image.Height); //插入图片
http://blog.csdn.net/happy09li/article/details/7431967[/quote]
这个插入图片之后,会生存两个Excel 文件,数据是一个文件,图片又是一个文件,
我要的是数据和图片在同一个Excel 同一个工作簿 文件里面[/quote]
这个数据是图片是在一个excel中 sheet.Shapes.AddPicture(ds.Tables[0].Rows[row][col].ToString(), Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, Convert.ToSingle(range.Left) + 15 + image.Width, Convert.ToSingle(range.Top) + 5, image.Width, image.Height); //插入图片
http://blog.csdn.net/happy09li/article/details/7431967[/quote]
这个插入图片之后,会生存两个Excel 文件,数据是一个文件,图片又是一个文件,
我要的是数据和图片在同一个Excel 同一个工作簿 文件里面