Extracting embedded Excel files from Word document
เธรดต่อผู้เขียนข้อความ: John Fossey
John Fossey
John Fossey  Identity Verified
แคนาดา
Local time: 02:40
สมาชิก (2008)
ภาษาฝรั่งเศส เป็น ภาษาอังกฤษ
+ ...
Oct 13, 2010

Is there any quick way to extract all the Excel files embedded in a Word document?

I am trying to work on a large Word document that has many embedded Excel files. What I have found is that certain of the Excel charts & tables share common Excel files, but its very confusing to even know how many Excel files are embedded. Many of the worksheets of the embedded Excel files are not visible on the Word document itself, but still have to be translated.

What would be great
... See more
Is there any quick way to extract all the Excel files embedded in a Word document?

I am trying to work on a large Word document that has many embedded Excel files. What I have found is that certain of the Excel charts & tables share common Excel files, but its very confusing to even know how many Excel files are embedded. Many of the worksheets of the embedded Excel files are not visible on the Word document itself, but still have to be translated.

What would be great would be some way to simply extract all the objects embedded in the Word document so they can be counted and translated separately, all at one go.
Collapse


 
Peter Linton (X)
Peter Linton (X)  Identity Verified
Local time: 07:40
ภาษาสวีเดน เป็น ภาษาอังกฤษ
+ ...
Your choices Oct 13, 2010

AFAIK, this is not possible. You have 2 options:
- persuade your customer to send you the Excel files
- else as a desperate last resort, convert the Word file to PDF ( this will display all the Excel data), convert back to Word and translate as normal.
I hope someone has a better solution.


 
John Fossey
John Fossey  Identity Verified
แคนาดา
Local time: 02:40
สมาชิก (2008)
ภาษาฝรั่งเศส เป็น ภาษาอังกฤษ
+ ...
TOPIC STARTER
Original files are embedded, just a question of accessing them Oct 13, 2010

Unfortunately, the end client is a large corporation and many people have had a hand in creating this document - getting the original Excel files isn't practical. On the other hand, they are all there embedded in the Word document, its just a question of extracting them. Right clicking on the embedded object and selecting Chart Object/Worksheet Object > Open will open the embedded file, but with many files embedded it becomes quite confusing to follow them - some seem to be shared, some seem t... See more
Unfortunately, the end client is a large corporation and many people have had a hand in creating this document - getting the original Excel files isn't practical. On the other hand, they are all there embedded in the Word document, its just a question of extracting them. Right clicking on the embedded object and selecting Chart Object/Worksheet Object > Open will open the embedded file, but with many files embedded it becomes quite confusing to follow them - some seem to be shared, some seem to be repeats of others.Collapse


 
Antoní­n Otáhal
Antoní­n Otáhal
Local time: 08:40
สมาชิก (2005)
ภาษาอังกฤษ เป็น ภาษาเชค
+ ...
What CAT tool? Oct 13, 2010

I know for sure that Transit can manage embedded Office files smoothly - meaning that if you import into a project, say, a Word file with embedded Excel files, the info in those files is imported to be translated as well. AFAIR, the only problem is that the Excel info not actually vidsible in the Word file is always imported and some customers do not want to pay for that translation, but you are saying this is what you actually need.

I am not sure but perhaps MemoQ can do it as well
... See more
I know for sure that Transit can manage embedded Office files smoothly - meaning that if you import into a project, say, a Word file with embedded Excel files, the info in those files is imported to be translated as well. AFAIR, the only problem is that the Excel info not actually vidsible in the Word file is always imported and some customers do not want to pay for that translation, but you are saying this is what you actually need.

I am not sure but perhaps MemoQ can do it as well...

Antonin
Collapse


 
Soonthon LUPKITARO(Ph.D.)
Soonthon LUPKITARO(Ph.D.)  Identity Verified
ไทย
Local time: 13:40
สมาชิก (2004)
ภาษาอังกฤษ เป็น ภาษาไทย
+ ...
Document properties Oct 13, 2010

In MS Word >File > Properties, you will see embedded files. I also have a reference link about embedded Word file in Excel file: You can operate in an opposite direction for handle the embedded Excelled files.

Soonthon Lupkitaro


 
John Fossey
John Fossey  Identity Verified
แคนาดา
Local time: 02:40
สมาชิก (2008)
ภาษาฝรั่งเศส เป็น ภาษาอังกฤษ
+ ...
TOPIC STARTER
memoQ Aug 27, 2014

Antoní­n Otáhal wrote:

I am not sure but perhaps MemoQ can do it as well...

Antonin


It looks like I have come across an old thread that I started, so I might as well finish the story.

Since I originally asked this I have gone through Wordfast, SDL Studio and finally now have memoQ. I am pleased to report that I am in the middle of a large job with 67 embedded Excell documents and memoQ does it all without a hitch. The trick is to import the Word document using "Import with options" and then set it to import the embedded objects.


 


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

ผู้ไกล่เกลี่ยของฟอรัมนี้
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Extracting embedded Excel files from Word document






LinguaCore
AI Translation at Your Fingertips

The underlying LLM technology of LinguaCore offers AI translations of unprecedented quality. Quick and simple. Add a human linguistic review at the end for expert-level quality at a fraction of the cost and time.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »