File utils

Top  Previous  Next

Break Large Excel (text) Files. If you download large database from any ERP package like SAP, Oracle etc where the number of rows is greater than 65536 then it becomes very difficult to get the data into Excel for data manipulation or summarizing. With this utility, the file will be broken into multiple smaller files to filenames suffixed with 1,2.... Please not that only text excel files can be broken ..not normal xls files. Also the original file will remain intact.

 

Rename Current Open File. This can a big time saver. Suppose you are working on a file and you want to rename it to something more appropriate then use this utility. It will give you a edit box with the current file name, change it to the name you want and click okay. The file name will be changed in a second flat, the old file being replaced with the new file name.

 

Create Hyperlinked Index of all files in a Directory.