;_XLFontsAndFormatExample.au3 0_2
#include"ExcelCom.au3"
$FilePath=@ScriptDir&"\Blank5.xls"
$DataString="12,7,6,9,23,45,3,17,18,9"&@CRLF&"3,12,7,6,9,23,45,3,17,18"&@CRLF&"3,12,8,6,9,23,45,3,17,18"&@CRLF&"3,12,9,6,9,23,45,3,17,18"
$DataString=StringReplace($DataString,",",@TAB)
$XLRange=_XLpaste($FilePath,1,"Z",11,$DataString,1)
;=====================================================================================================
;_XLSetHorizontalAlign(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $s_Align, $s_i_Visible)
;Notes: ;Note. '5' is the color code
_XLSetHorizontalAlign($FilePath,1,$XLRange,1,"Left",1) 
MsgBox(0,"","_XLSetHorizontalAlign="&"Left")
_XLSetHorizontalAlign($FilePath,1,$XLRange,1,"Right",1) 
MsgBox(0,"","_XLSetHorizontalAlign="&"Right")
;Exit
;=====================================================================================================
;_XLSetCellColor(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $i_Row, $i_FontColor, $s_i_Visible) 
;Notes: Sets a cell's background color, use in the same way as _XLSetCellFontColor
_XLSetCellColor($FilePath,1,$XLRange,11,6,1) 
MsgBox(0,"","_XLSetCellColor="&6)
;_XLSetColumnWidth($FilePath, 1, $XLRange, "Autofit", 1)
_XLSetColumnWidth($FilePath, 1, $XLRange, 20, 1)
MsgBox(0,"","_XLSetColumnWidth="&20)
;=====================================================================================================
;_XLSetFontType(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $s_FontType, $s_i_Visible)
;Notes: ;Note. '5' is the color code
_XLSetFontType($FilePath,1,$XLRange,1,"Bold",1) 
MsgBox(0,"","_XLSetFontType="&"Bold")
;=====================================================================================================
;_XLSetColumnWidth(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $s_i_ColumnWidth, $s_i_Visible) 
;Notes: $s_i_ColumnWidth can either be a number or "Autofit". For example:
_XLSetColumnWidth($FilePath, 1, $XLRange,"Autofit", 1)
MsgBox(0,"","_XLSetColumnWidth="&"Autofit")
;=====================================================================================================
;_XLSetCellFontName(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $i_Row, $s_FontName, $s_i_Visible) 
;Notes: Set a cells font, ie 
;_XLSetCellFontName($FilePath,1,27,11,"Wingdings",1)
_XLSetCellFontName($FilePath,1,27,11,"Times New Roman",1)
MsgBox(0,"","_XLSetCellFontName="&"Times New Roman"&"Cell 27,11")
;=====================================================================================================
;_XLSetCellFontColor(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $i_Row, $i_FontColor, $s_i_Visible) 
;Notes: ;Note. '5' is the color code
_XLSetCellFontColor($FilePath,1,$XLRange,11,5,1) 
MsgBox(0,"","_XLSetCellFontColor="&5)
;=====================================================================================================
;_XLSetCellColor(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $i_Row, $i_FontColor, $s_i_Visible) 
;Notes: Sets a cell's background color, use in the same way as _XLSetCellFontColor
_XLSetCellColor($FilePath,1,$XLRange,11,7,1) 
MsgBox(0,"","_XLSetCellColor="&6)
;_XLSetColumnWidth($FilePath, 1, $XLRange, "Autofit", 1)
_XLSetColumnWidth($FilePath, 1, $XLRange, 20, 1)
MsgBox(0,"","_XLSetColumnWidth="&20)
;=====================================================================================================
;_XLSetFontType(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $s_FontType, $s_i_Visible)
;Notes: ;Note. '5' is the color code
_XLSetFontType($FilePath,1,$XLRange,1,"Italic",1) 
MsgBox(0,"","_XLSetFontType="&"Italic")
;=====================================================================================================
;_XLSetHorizontalAlign(ByRef $s_FilePath, $s_i_Sheet, $s_i_Column, $s_Align, $s_i_Visible)
;Notes: ;Note. '5' is the color code
_XLSetHorizontalAlign($FilePath,1,$XLRange,1,"Left",1) 
MsgBox(0,"","_XLSetHorizontalAlign="&"Left")