`
Join In
Useful Tools
Naming Convention
Tools       2020/6/9 11:27:28          Author: FFCell
Views: 0

Naming Convention will help us to name the result worksheets/workbooks automatcially.

There are several useful variables we can choose.

{Original folder name} refers to the name of the folder in which contains the original files.

{Original sheet name} refers to the sheet name in the original workbook.

{Original file name, no extension} refers to the original file name but without file extension such as Book 1, not Book 1.xlsx.

{Original file extension} refers to the extension of original file(without comma) such as xlsx or xls etc.

{Auto-increment number} refers to the ascending sequence of numbers such as 1, 2, 3, 4.

{Year} refers to the year of current system date, such as 2018.

{Month} refers to the month of current system date, a number from 01 to 12.

{Day} refers to the day of current system date, a number from 01 to 31.

{Hour} refers to the hour of current system time, a number from 00 to 23.

{Minute} refers to the minute of current system time, a number from 00 to 59.

{Second} refers to the second of current system time, a number from 00 to 59.


For example, we want to name the new sheets as original file name and original sheet name after combination, pls click {Original file name, no extension}and {Original sheet name},and type a middle hyphen "-" between these two variables. And we will get the flollowing result: