Excel file generation UDF (don't need Excel to be installed)

[MrCreatoR]

Ok here is the fix for my problem above:

Replace this in the udf:

Func _XLSAddStyle($file, $name="S21", $font="Arial", $size=11, $fstyle=0, $pcolor="000000", $icolor="", $AlignHor=$XMLXLS_CENTER, $AlignVer=$XMLXLS_BOTTOM, $Border=0)
     Local $f, $fontfam="Swiss"
     FileWriteLine($file, ' <Style ss:ID="' & $name &'">')
     FileWriteLine($file, '     <Alignment ss:Horizontal="' & $AlignHor & '" ss:Vertical="' & $AlignVer &'"/>')

With this:

Func _XLSAddStyle($file, $name="S21", $font="Arial", $size=11, $fstyle=0, $pcolor="000000", $icolor="", $AlignHor=$XMLXLS_CENTER, $AlignVer=$XMLXLS_BOTTOM, $Border=0, $WrapText=1)
     Local $f, $fontfam="Swiss"
     FileWriteLine($file, ' <Style ss:ID="' & $name &'">')
     FileWriteLine($file, '     <Alignment ss:Horizontal="' & $AlignHor & '" ss:Vertical="' & $AlignVer &'" ss:WrapText="' & $WrapText & '"/>')

 

[marklynch]

Hi, i just joined. I am trying to learn C# the fastest way possible.Currently i am using Zet Excel platform. It helps me to create, edit, convert or print excel spreadsheet file formats without requiring Microsoft

[Earthshine]

  On 7/25/2020 at 1:12 AM, marklynch said:

Hi, i just joined. I am trying to learn C# the fastest way possible.Currently i am using Zet Excel platform. It helps me to create, edit, convert or print excel spreadsheet file formats without requiring Microsoft

Expand  

That’s nice but this is an autoIt forum