Technical forums » MemoQ support »
Import an excel file with more than 600 sheets
Thread poster: Donglai Lou (X)
Donglai Lou (X)
Donglai Lou (X)  Identity Verified
China
Local time: 13:34
English to Chinese
+ ...
Oct 7, 2014

Dear Colleagues,

I need to import a certain range on each sheet from several excel files with hundreds of sheets. I have used a clumsy method to solve the problem by writing [sheet1]![Range], [sheet2]![Range].... and so on (no manually) into the import only box. what I would like to explore with you is whether there is a simple way in memoq to express that you want to specify a certain range on every sheet in an excel file.

thank you for your attention.
... See more
Dear Colleagues,

I need to import a certain range on each sheet from several excel files with hundreds of sheets. I have used a clumsy method to solve the problem by writing [sheet1]![Range], [sheet2]![Range].... and so on (no manually) into the import only box. what I would like to explore with you is whether there is a simple way in memoq to express that you want to specify a certain range on every sheet in an excel file.

thank you for your attention.

best regards,
Donglai ▲ Collapse
 
VIP9N
VIP9N
Local time: 08:34
Russian to English
+ ...
«Hide» unnecessary columns/rows Oct 7, 2014

I did some translations of that kind. Those were large Excel files with dozens of sheets each. The customer asked me to translate from French into Russian only some selected material from those files, and I started the job from checking each file and hiding the information, which had to be preserved. That done, I loaded the files in Memo as usual, saw only the unhidden text, and translated it. Of course, when I exported the ready and translated files, I had to go through the files again and ... See more
I did some translations of that kind. Those were large Excel files with dozens of sheets each. The customer asked me to translate from French into Russian only some selected material from those files, and I started the job from checking each file and hiding the information, which had to be preserved. That done, I loaded the files in Memo as usual, saw only the unhidden text, and translated it. Of course, when I exported the ready and translated files, I had to go through the files again and unhide all sheets.
Maybe it will be of any help to you.

[Edited at 2014-10-07 06:00 GMT] ▲ Collapse
 


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

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Peter Zauner[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Import an excel file with more than 600 sheets






Wordfast Pro
Translation Memory Software for Any Platform

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

Buy now! »
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 »