Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

manipulating excel file while using GUI_DOWNLOAD

Former Member

‎09-22-2008 2:23 PM

0 Kudos

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?

2 REPLIES 2

Former Member

‎09-22-2008 2:32 PM

0 Kudos

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..

Former Member

‎12-08-2008 5:46 AM

0 Kudos

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