Is it possible to format the Excel cell properties while using I/O approach?

Yes, it is possible from Tally.ERP 9 Series A Release 5.3.8.  The action Format Excel Sheet is used in function scope to allow the formatting of cell properties, Width and Text Wrap , while writing/updating to an Excel file using File I/O approach.

Syntax

Format Excel Sheet: <Property Name> : <Property Parameter>

Supported Properties : ColumnWidth and CellTextWrap

Column Width

Syntax

Format Excel Sheet : ColumnWidth : < Column Number >: < Width in pixels >

Example

[Function: Test Function]

10 : Format Excel Sheet: ColumnWidth:6:500

CellTextWrap

Syntax

Format Excel Sheet: CellTextWrap:< Row Number >:< Column Number >:< Enable Wrapping >

where, Enable Wrapping is a logical value.

Example

[Function: Test Function]

20  : Format Excel Sheet: CellTextWrap:5:6:Yes

;; Here text wrap will be enabled as we mentioned YES