This is either a bug, or an odd feature:
In the Excel -Convert taks, if you convert to a TextFile, it will not overwrite the existing file properly. It does not append either. It just starts writing into the existing file (from top).
To replicate the problem:
1) Place a textfile test.txt in a folder, and add 10 lines of text into it.
2)Run the Excel convert job, with an excel file called test.xlsx, that has fewer
than 10 lines of content in it. Make sure the save to setting is 'Same folder but change extension'
You wil now see in the text file, that the excel content is written to the top of the file (so it's a Prepend instead of Append), and the original textfile content is below.
Edited by moderator
| Reason: Not specified