topic manipulating excel file while using GUI_DOWNLOAD in Application Development and Automation Discussions

manipulating excel file while using GUI_DOWNLOAD

Former Member — Mon, 22 Sep 2008 13:23:26 GMT

hi all,

while using GUI_UPLOAD i want to

1) fix the width of the column of excel file

2) define the font of the data in excel file

3) change background color of the cells in excel file.

please suggest as to how can this be done?

Re: manipulating excel file while using GUI_DOWNLOAD

Former Member — Mon, 22 Sep 2008 13:32:29 GMT

using GUI_DOWNLOAD you can't change the data in excel sheet...if you want to do the things you need to use OLE concpets for downloading of data to Excel sheet wherein you can do most of the options excel can handle..

Check within SDN as there are blogs for downloading data to Excel sheet using OLE concepts..

Re: manipulating excel file while using GUI_DOWNLOAD

Former Member — Mon, 08 Dec 2008 05:46:25 GMT

thnaks ramesh, i shall look into the OLe concepts for all these related details