Hi Experts,

I develop a report in excel using concat$ and seq.puts functions.
Is there any way to put colour in particular field in excel report.





Best Regards
Sapna Shekhawat

Hi,

You can create a VB Script for adding colors. Now, place the script on client machine and run it. Else, you can try creating macros.

Hmmm... not required ... try SpreadsheetML ,i am planning to write a blog about it ..

till then you can refer this

http://technet.microsoft.com/en-us/magazine/2006.01.blogtales.aspx


mind it .... to much of formatting requires to many styles to be created .. its better to limit it to 2-3 colors , Bold , italic and underlined.

The reason for limiting it is , once you start giving few Excel features , the User comes back to you with few more Excel features requirements and the cycle goes on .. :P

Hi,

I guess, you are into SSRS, so you can use it. Best option I say.

Vamsi,

Can you explain why it's a better way? Too much meta-deta and editorial content.

if you are on unix server and want to send the report to a mail box of the user,scheduled via job then how will you take care of that ??

As long as the the user is manually executing the job , you can transfer the macro to client and and execute it ( that to requires toggling with security setting - Enable macro)

VBS requires lot of handshakes .... where as spreadsheetml does not...

you can always hide the complexity of spreadsheetML using a DLL

Then I believe, you need to create a parser as well, just in case ;)

Vamsi has a good point. I worked on a small parser years ago based on the Open XML formats - http://en.wikipedia.org/wiki/Microsoft_Office_XML_formats