topic Hide First column from formatted excel in Application Development and Automation Discussions

Hide First column from formatted excel

Former Member — Thu, 16 May 2013 04:21:46 GMT

Hello Folks,

I have used simple transformation ( Call Transformation ID ) for formatting excel by following flow

internal table->XML->Downloaded as XLS->Sent as attachment through mail.

excel is being sent successfull in required format but i need to hide first column which comes as Verion.

Could you please help me out.

Regards

Aradhya.J.M.

Former Member — Thu, 16 May 2013 06:12:10 GMT

Hello Aradhya,

Before exporting to internal table, just change the structure and move the corresponding values expect the first column which is having the version.

Thanks

tamma

Former Member — Thu, 16 May 2013 06:52:45 GMT

Hi Aradhya,

Using OLE ABAP Code you can download XLS File and Hide 1st Column .

Regard's

Smruti

Former Member — Thu, 16 May 2013 07:03:46 GMT

Hello Smruthi,

Thanks for your reply,

earlier i used OLE but requiriment changed to run in background,so cant use OLE.

Regards

Aradhya.J.M.