1. When creating .xlsx, the max length of file name is 206 characters
2. Additionally to the length of file name, the entire file path including the file name must be less than 261.
3. When you want to set your own extension to your new file, please check INPUT[Other Extension(Adv)] Please also refer to Advance parameters.
4. Newly added a feature to select Bot's behavior when the file already exists.
- Return error and fail the bot
- Add (n) at the end of the filename and continue
- Do not create a file and do not return error
5. Newly added a feature to handle illegal filenames.
- Return error and fail bot
- make correction and continue (COM0 and LPT0 can not be corrected)
6. timestamp options are added.
- add at the front
- add at the end
- do not add (default)
7. User Defined Extension will be used in conjunction with INPUT[Other Extension(Adv)]
8. Cannot use the following special character in the Excel Sheetname.
`\, ', *, /, :, ?, [, ], ’, ＇, ＊, ／, ：, ？, ［, ＼, ］, ￥`
Files with following eight (8) extensions can be created.
Options --- there are three (3) more optional features
- A file with a user defined extension can be created.
- A timestamp (system time data) can be added to the filename.
- Sheet name can be changed/specified (this option is good only for .xlsx files.
- Path for a folder o store the new file
- File name
- Timestamp to be added to the file name
- User defined extension
- Sheet name (.xlsx only)
- Choose [String]
- Full path to your new file will be returned.