＋设为首页 ＋添加到收藏夹
用ASP 把图片插入EXCEL后,怎么改它的大小?
sheetActive.Pictures.Insert(“c:\test\test.jpg”).Select
我把录制的宏放进去也不行
Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.ShapeRange.Height = 348.75
Selection.ShapeRange.Width = 318.75
Selection.ShapeRange.Rotation = 0
哪位高手可以帮我啊?谢谢!!!
ASP代码也写了写：
<%
set myexcell=CreateObject("Excel.Application")
set mywork=myexcell.Workbooks.Add
set Activesheet=myexcell.sheets("sheet1")
Activesheet.Pictures.Insert("http://community.csdn.net/images/CSDN_logo.GIF")
Activesheet.Shapes("Picture 1").Height = 348.75
mywork.SaveAs "c:\test.xls"
mywork.close
set mywork=nothing
set myexcell=nothing
%>
