Community
Showing results for 
Search instead for 
Do you mean 
Reply

Download tasks/call to excel---keep colors

New Member
Posts: 6
Country: USA

Download tasks/call to excel---keep colors

Hello to all. Is there anyway to download tasks/call list to excel and KEEp the colors I have coded for each? Thanks in advance.

Employee
Posts: 1,163
Country: USA

Re: Download tasks/call to excel---keep colors

This isn't possible to do through the SDK or via the OLEDB/ODBC provider, however it can be done with conditional color formatting:

 

http://stackoverflow.com/questions/2453152/cell-color-change-in-excel-using-conditional-formatting-i...

Matthew Wood
Act! SDK Support
Community Moderator
New Member
Posts: 6
Country: USA

Re: Download tasks/call to excel---keep colors

Thanks for the help. Main problem here is when it exports to excel it is all b&w. Once it is there is there anyway it is coded "behind the scenes" and I can bring it out? 

Employee
Posts: 1,163
Country: USA

Re: Download tasks/call to excel---keep colors

As I mentioned above, I think you can change the color values of cells via conditional formatting. This would be done in excel however. As far as I know this can't be done through ADO.Net.

Matthew Wood
Act! SDK Support
Community Moderator
New Member
Posts: 6
Country: USA

Re: Download tasks/call to excel---keep colors

thankk you