	Excel Newfile 日本語でのヘルプはこちらをクリック
	Author: Taiki Shimasaki This plugin creates new blank files with either .xlsx or .csv format.

Need help?

Technical contact to tech@argos-labs.com

May you search all operations,

IMPORTANT NOTE

NO special characters can be used --- The following special characters are not allowed for either the filenames or for the user defined extensions.

\, /, :, *, “, <, >, |

(They will cause an error.)

NO long file names can be used --- CSV file name cannot exceed 255 characters in length. Excel files names cannot contain more than 206 characters

NO long full file path can be used ---The plugin will fail when the full file path exceeds 260 characters

Files with following two (2) extensions can be created.

xlsx
.csv

Input

Required Inputs

File type
Choose either .xlsx or .csv

Path for a folder o store the new file
File name
IF File Exists
Select what to do when a file with the same name has been detected in the same folder.

Your choices are
1) fail the bot 2) create and fail by adding (n) at the end of the file name 3) overwrite the file, and 4) do not make the file, give no error, and proceed to the next operation.

Validate Option
When checked, it validates the file name.
- [Return Failure] option returns fail and stop the bot when illegal characters are detected.
- [Sanitize] option automatically removes the illegal characters. It also adds an underscore (_) when “reserved words” in the Windows are used for the file name. However, COM0 and LPT0 are not correctable with the Sanitize option. It just leads to a bot to fail.

Optional Inputs

Excel Sheet name
Defines the sheet name. Default is “Sheet1” (the new Excel file contains only one sheet.)
Special characters like the following are not allowed to be included in the sheet name.　
`\, ', *, /, :, ?, [, ], ’, ＇, ＊, ／, ：, ？, ［, ＼, ］, ￥`

Sheetname Length
Defines what to do when sheet name becomes longer than 31 characters.
"Cut to 31 char"：deletes all that is after the 32^nd characters.

"Return Failure"：bot fails and stops when more than 31 chars are detected.

Output/Return Value

Choose [String]
Full path to your new file will be returned.

日本語でのヘルプはこちらをクリック

How to set parameters

All Plugins