|
PureBytes Links
Trading Reference Links
|
Hi Eric,
As Abhijit says, save comma separated values.
If you save the file with a .csv (comma separated values)extension instead of .txt, it will be opened by Excel when you double-click it in Explorer - at least it does on my system. Upon opening, the fields will be automatically separated into cells without further user action.
Regards,
Mike Gossland
>There is no way to do this directly, unless there is a 3rd party tool to
>do this - which is highly unlikely. However, if you just print the
>values to the text file as comma-delimited, like this
>
>Print(numtostr(O, 2) + "," + numtostr(H, 2)); etc. etc.
>
>you can easily get this in Excel - just ask Excel to open this file and
>specify in the import dialog that this is comma delimited. If you wish,
>you can then save this file from Excel as a true .xls file, but then
>that file would become inaccessible from TS.
>
>Abhijit
>
>
>ericzh2003 wrote:
>
>>Hi list,
>>
>>Is it possible to print log to an excel file instead of TXT?
>>Or is there any way I can covert a TXT log file to an Excel file?
>>Thanks in advance.
>>
>>Eric
>>
>>
>>
>>
|