Man illustrationFlower illustration

Docy

Format

Estimated reading: 1 minute 89 views

Format activity is used for converting the specified column in an Excel file to the desired format.


*Excel nameReference name of Excel which will be opened.
RangeExcel sheet range from which to fetch data.
Sheet nameName of the sheet to work in Excel. If no added, it takes the first sheet by default.
*FormatFormats cells for dates, text, currency, time
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${formatExcel}

You can use the Range as shown in the example.

A1:C5

You can use the Sheet name as shown in the example.

Sheet1

You can use the Format as shown in the example.

For date:

dd.MM.yyyy


For TC:

00000000000


For text:

@


For currency:

₺ #, ## 0; -₺ #, ## 0


For hours:

hh.mm: nn


These examples can be increased on demand or by using ready-made formats in excel.

CONTENTS