This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Edward Potter 西班牙 Local time: 04:54 正式会员 (自2003) Spanish西班牙语译成English英语 + ...
Jul 10, 2005
When I go to Tools > Documents I cannot see the Excel files I have open in order to select them and then analyze them.
How do I get Excel files to show in the WordFast functions so that I can analyze them.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
David Daduč 捷克共和国 Local time: 04:54 English英语译成Czech捷克语
Save the Excel sheets as TXT
Jul 11, 2005
As far as I know this is not possible directly.
One way would be to pre-translate the Excel file using Wordfast, so you have the Word file with all the text from Excel. However, you'd need to use CopySourceWhenNoMatch in PB, an empty TM, and finally use the Back to Source method described in the Wordfast manual.
What I think is easier is saving the Excel file as text (TXT) and analyzing the text file(s).
One problem is Excel saves each sheet as a separate T... See more
As far as I know this is not possible directly.
One way would be to pre-translate the Excel file using Wordfast, so you have the Word file with all the text from Excel. However, you'd need to use CopySourceWhenNoMatch in PB, an empty TM, and finally use the Back to Source method described in the Wordfast manual.
What I think is easier is saving the Excel file as text (TXT) and analyzing the text file(s).
One problem is Excel saves each sheet as a separate TXT file, so you may need to save many times in a multi-sheet workbook. The following Excel macro might help. It saves the sheets of a workbook as separate text files automatically. All the text files are saved in the same folder where the XLS file is.
Sub SaveSheetsAsTxt() Dim i As Integer, pocet As Integer, jmeno As String pocet = ActiveWorkbook.Sheets.Count jmeno = ActiveWorkbook.FullName jmeno = Left(jmeno, Len(jmeno) - 4) For i = 1 To pocet Sheets(i).SaveAs Filename:= _ jmeno & "_" & i & ".txt", FileFormat:=xlText, _ CreateBackup:=False Next i End Sub ▲ Collapse
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Marek Buchtel 捷克共和国 Local time: 04:54 正式会员 (自2005) English英语译成Czech捷克语 + ...
SITE LOCALIZER
Copy/paste to Word
Jul 11, 2005
Edward Potter wrote:
When I go to Tools > Documents I cannot see the Excel files I have open in order to select them and then analyze them.
How do I get Excel files to show in the WordFast functions so that I can analyze them.
Hello Edward,
As far as I know, you cannot analyze Excel files directly from Wf. The easiest way is to copy/paste the text to Word. The analysis results should be the same (the segments will be the same in Excel and Word)
Regards
Marek
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Edward Potter 西班牙 Local time: 04:54 正式会员 (自2003) Spanish西班牙语译成English英语 + ...
主题发起人
Copy / paste into Word
Jul 11, 2005
Thank you very much, Marek.
Indeed, I copied and pasted everything into Word then did an analysis on the Word file.
WF would be improved greatly if an analyze function for Excel tables were included.
[Edited at 2005-07-11 14:13]
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
When I go to Tools > Documents I cannot see the Excel files I have open in order to select them and then analyze them.
How do I get Excel files to show in the WordFast functions so that I can analyze them.
Just save your spreadsheet as a text file and open it with Word.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Edward Potter 西班牙 Local time: 04:54 正式会员 (自2003) Spanish西班牙语译成English英语 + ...
主题发起人
Saving the Excel table as a text file
Jul 11, 2005
Thank you for another good suggestion, Arthur.
Let me just give a bit of further information - there were about 25 files. This is a fairly common situation with the translation of Excel files and I am continuing to discuss this topic because it would be of use to others and myself in the future.
So, neither the copy/paste nor saving them as text files really solve the problem of the time-consuming clickey clickey. Is there any way to set up the files quickly for analy... See more
Thank you for another good suggestion, Arthur.
Let me just give a bit of further information - there were about 25 files. This is a fairly common situation with the translation of Excel files and I am continuing to discuss this topic because it would be of use to others and myself in the future.
So, neither the copy/paste nor saving them as text files really solve the problem of the time-consuming clickey clickey. Is there any way to set up the files quickly for analysis?
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value