<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>We have a requirement, where the Excel (formatting) with <B>header and data in different fonts and different sizes to be generated</B>, when the program is running in background.<o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>I have successfully generated excel sheet, with all these requirements when the program is running in <B>foreground</B>. <o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>However the same would not work in when the <B>program is running in background</B>. <o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>Here is piece of code written to generate excel sheet when the program is running in background.<o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>create</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>object</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> gs_excel </SPAN><SPAN class=l0s331><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#4da619>'EXCEL.APPLICATION'</FONT></SPAN></SPAN></FONT><FONT size=3><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> .<BR> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>set</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY:
'Arial','sans-serif'"><FONT color=#0000ff>property</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>of</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> gs_excel </SPAN><SPAN class=l0s331><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#4da619>'Visible'</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> = </SPAN><SPAN class=l0s321><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#3399ff>0</FONT></SPAN></SPAN></FONT><FONT size=3><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> .<BR> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>get</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY:
'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>property</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>of</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> gs_excel </SPAN><SPAN class=l0s331><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#4da619>'Workbooks'</FONT></SPAN></SPAN></FONT><FONT size=3><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> = gs_wbooklist .<BR> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>get</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT
color=#0000ff>property</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>of</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> gs_wbooklist </SPAN><SPAN class=l0s331><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#4da619>'Application'</FONT></SPAN></SPAN></FONT><FONT size=3><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> = gs_application .<BR> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>set</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>property</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY:
'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>of</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> gs_application </SPAN><SPAN class=l0s331><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#4da619>'SheetsInNewWorkbook'</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> = </SPAN><SPAN class=l0s321><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#3399ff>1</FONT></SPAN></SPAN></FONT><FONT size=3><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> .<BR> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>call</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT
color=#0000ff>method</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><SPAN class=l0s521><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#0000ff>of</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> gs_wbooklist </SPAN><SPAN class=l0s331><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT color=#4da619>'Add'</FONT></SPAN></SPAN><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"> = gs_wbook .<o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3> <o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="BACKGROUND: white; FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>. .. . . . ….. <o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="COLOR: windowtext; FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>I have gone through your code given, but it is generating the normal excel sheet, however I need to open excel application at background and need to format with different styles. <o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>Please throw some light on this issue. <o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>Appreciate your response .<o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><o:p><FONT size=3> </FONT></o:p></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>Regards<o:p></o:p></FONT></SPAN></DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-FAMILY: 'Arial','sans-serif'"><FONT size=3>Harikrishna <o:p></o:p></FONT></SPAN></DIV></td></tr></table><br>