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 32nd 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
Text from Image
All Plugins
- AD LDAP
- Adv Send Email
- Arithmetic Op
- Attach Image
- AWS Textra Rekog
- Bot Collabo
- Chatwork Notification
- Clipboard
- Codat API
- Convert CharSet
- Convert Image
- Create Newfile
- CSV2XLSX
- Detect CharSet
- Drag and Drop
- Email IMAP ReadMon
- Email Read Mon
- Env Check
- Env Var
- Excel Advanced
- Excel AdvII
- Excel AdvIII
- Excel Copy Paste
- Excel Formula
- Excel Macro
- Excel Newfile
- Fairy Devices mimi AI
- File Conv
- File Folder Op
- File Status
- Folder Monitor
- Folder Structure
- Google Calendar
- Google Cloud Vision API
- Google Drive
- Google Sheets
- Google Token
- Google Translate
- Google TTS
- Html Extract
- IBM Speech to Text
- IBM Visual Recognition
- JSON Select
- LINE Notify
- MongoDB
- MS Azure Text Analytics
- MS Word Extract
- NAVER OCR
- Newuser-SFDC
- PANDAS I
- pandas II
- pandas III
- PANDAS profiling
- Parsehub
- Password Generate
- PDF2Doc
- PDF Miner
- PDF SplitMerge
- PowerShell
- Print 2 Image
- Python Selenium
- QR Generate
- QR Read
- Regression
- REST API
- Rossum
- Scrapy Basic
- Screen Snipping
- Simple SFDC
- Slack
- Speed Test
- SQL
- SSH Command
- SSH Copy
- String Manipulation
- Telegram
- Tesseract
- Time Stamp
- Web Extract
- Windows Op
- Work Calendar
- XML Extract
- Xtracta Get Doc
- Xtracta Tracking
- Xtracta Upload
- ZipUnzip