Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with PrintOut Method
Hi All,
I am trying to set print setting for excel file programatically and used the PrintOut Method to give the print. The problem is,for HP Laser Jet,its working fine but for Xerox Phaser ,its just hanging at the printOut Method.Is there any problem with printer compatibility issues ?. Or is there any way to do this differently. Kindly see below my requirement. I have to print an image file (.bmp,.gif,.jpeg) in LandScape Orientation from an asp.net application. To set the page orientation,I have embedded the image in excel sheet and set the page orientation property to landscape. I used the PrintOut Method. but its not working. ANy help in this regard is greatly appreciated. Thanks Shyam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with PrintOut Method
I guess it is something to do with the code you are using, but you did not
post anything. Seems strange way to print an graphic though. There must a better way from ASP.Net. NickHK "Prasad" wrote in message ... Hi All, I am trying to set print setting for excel file programatically and used the PrintOut Method to give the print. The problem is,for HP Laser Jet,its working fine but for Xerox Phaser ,its just hanging at the printOut Method.Is there any problem with printer compatibility issues ?. Or is there any way to do this differently. Kindly see below my requirement. I have to print an image file (.bmp,.gif,.jpeg) in LandScape Orientation from an asp.net application. To set the page orientation,I have embedded the image in excel sheet and set the page orientation property to landscape. I used the PrintOut Method. but its not working. ANy help in this regard is greatly appreciated. Thanks Shyam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with PrintOut Method
Hi Nick,
Even without image also,its not working. Please find below the code oXL= new Excel.Application oWB=(Excel._Workbook)(oXL.Workbooks.Add(Missing.Va lue)); workSheet=(Excel._Worksheet)oWB.ActiveSheet; ((Range)Worksheet.Cells[2,1]).Value2="Test"; worksheet.PrintOut(Missing.Value,Missing.Value,Mis sing.Value,Missing.Value,Missing.Value,Missing.Val ue,1,Missing.Value); oXL.Quit(); oWB=null; oXL=null; Page.Visible=false; The above code is working fine for HP Printer but not for Xerox Phaser 5500 DS Kindly help Thanks, Prasad "NickHK" wrote: I guess it is something to do with the code you are using, but you did not post anything. Seems strange way to print an graphic though. There must a better way from ASP.Net. NickHK "Prasad" wrote in message ... Hi All, I am trying to set print setting for excel file programatically and used the PrintOut Method to give the print. The problem is,for HP Laser Jet,its working fine but for Xerox Phaser ,its just hanging at the printOut Method.Is there any problem with printer compatibility issues ?. Or is there any way to do this differently. Kindly see below my requirement. I have to print an image file (.bmp,.gif,.jpeg) in LandScape Orientation from an asp.net application. To set the page orientation,I have embedded the image in excel sheet and set the page orientation property to landscape. I used the PrintOut Method. but its not working. ANy help in this regard is greatly appreciated. Thanks Shyam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Printout Method | Excel Programming | |||
PrintOut Method, Set ActivePrinter with a variable | Excel Programming | |||
Printout method: in color, duplex | Excel Programming | |||
Problem with the PrToFileName parameter when using the Printout method on a worksheet | Excel Programming | |||
Excel vba printout method | Excel Programming |