Setting Custom Paper size in Excel from Java Script

[Ramkumar]

I'm using Excel as a reporting service from my asp.net application.
First HTML page is generated and is exported to Excel using javascript, then alignment etc...are done via javascript.

My problem is while setting user definced paper size ..

Paper size is Height : 6 inches, Width : 10 inches

I try using oExcelSheet.PageSetup.PaperSize = xlPaperLetter for Letter size..

 

[Andrew Poulsom]

Welcome to the Board.

Is that paper size in the list in Ecel when you set it manually? If you record a macro while setting it what code do you get?

 

[Ramkumar]

Thanks Andrew,

I'm using javascript to align row height and column width for my report and use to set margins etc., and for paper size i use xlPaperLetter constant ..likely i need paper size constant to set custom paper size..

 

[Andrew Poulsom]

The value of the xlPaperLetter constant is 1.