Mobile menu

How do I analyze Excel files with WF?
Thread poster: Edward Potter

Edward Potter  Identity Verified
Spain
Local time: 17:04
Member (2003)
Spanish to 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.


Direct link Reply with quote
 

David Daduč
Czech Republic
Local time: 17:04
English to 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 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


Direct link Reply with quote
 

Marek Buchtel  Identity Verified
Czech Republic
Local time: 17:04
Member (2005)
English to Czech
+ ...
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


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 17:04
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
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]


Direct link Reply with quote
 
Arthur Allmendinger  Identity Verified
Germany
Local time: 17:04
English to German
+ ...
You may do it via text file. 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.


Just save your spreadsheet as a text file and open it with Word.


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 17:04
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
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 analysis?



[Edited at 2005-07-11 19:20]


Direct link Reply with quote
 

GregSmith
Local time: 17:04
French to English
+ ...
Any news? Apr 23, 2007

That was all a long time ago...

And I'm still having that problem now!

Have there been any developments in Worfast that allow analysis of Excel files?


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How do I analyze Excel files with WF?

Advanced search


Translation news related to Wordfast





Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs