topic Re: Formatting an excel in Application Development and Automation Discussions

Formatting an excel

Former Member — Tue, 07 Jun 2005 16:54:43 GMT

i create an excel file from an abap report.I create the workbooks ,fills the cells,etc

At this moment i need to format the excel with colors ,fonts etc . i don't know the property ,objects ,methods to do that

Re: Formatting an excel

former_member182670 — Tue, 07 Jun 2005 18:49:59 GMT

You can try this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrtskhowtoapplystylestorangesinworkbooks.asp

there is information about formatting excel sheets from your code and many other useful hints.

Link to Excel Object Model Reference is:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl11/html/Welcome_HV01134775.asp

Sample code to make your cell bold:

Worksheets("Sheet1").Range("A1:C5").Font.Bold = True

Re: Formatting an excel

ssimsekler — Tue, 07 Jun 2005 19:28:07 GMT

Hi Jorge

By the way, you can also refer to the tutorial <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/technologies/an%20easy%20reference%20for%20ole%20automation.article">"An Easy Reference For OLE Automation"</a>

As a second point, since you are new to this forum, let me introduce the portion of sytematic about assigning points. Not strictly relating with this specific thread, you can assign points to posts you find helpful while solving your questions. You can assign points by using the points scala at the left of each post. By giving a 10-point or choosing "Solved by own" at the left of your original post, you sign the thread as closed which makes SDNers save their time.

Regards

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

Re: Formatting an excel

former_member182670 — Fri, 24 Jun 2005 00:08:57 GMT

Pls don't forget to reward , if answers are helpful !