Man illustrationFlower illustration

Format

Estimated reading: 2 minutes 134 views

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


*Excel nameThe reference name of the MS Excel file which has already been opened or created is chosen in the dropdown.
RangeExcel sheet range from which to fetch data is written.
Sheet nameThe name of the sheet to work in MS Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet indexIndex of the sheet to work in MS Excel. If not added, it takes the first sheet by default.
*FormatThe cells are formatted for dates, text, currency, and time using desired formats.
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 Sheet index as shown in the example.

5

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.

Share this Doc

Format

Or copy link

CONTENTS
Chat Icon Close Icon