I have a very large Excel file (DB Export) that contains multiple sheets that have different source columns (e.g. Sheet 1/Source column C; sheet 2/source column E; sheet 3/source column F).
I already tried Excelling Studio for this, but I can only define one source column and not different source columns for the different sheets.
Does anybody know about a solution for this?
Michaela Moosbrugger If you just have one file, or maybe only a few, then I think your best solution is to save the individual worksheets as separate files, and then handle them in Studio as needed. It might be more effort to try and automate the process. Once you complete the translations putting the workbook back together is simple.
In this very example the usual situation is that there is NO COMMON COLUMN HEADER, but there are either no headers at all, or they are different for each column. And the translation instruction says which columns on which sheet should be translated.
And BTW, you don't seem to be aware of the basic and well-known fact (at least among translators having at least SOME clue about Studio functionality... which, I'm sorry, you don't seem to be...) - that hidden cells are not extracted for translation... i.e. the solution is MUCH SIMPLER: just hide the columns/rows/sheets which shoudn't be translated and that's it! Just a few simple clicks.
The problem with your "solutions" is that you are always focusing on one very specific and particular problem and your "solutions" are tailored for that very and only case... i.e. count with particular names, columns, number of rows, filenames, tag names, etc.And that makes your "solutions" essentially useless for other users... simply because their cases would differ in tags, number of columns, number of rows, etc.
Try to make some plugin which can be used GENERICALLY, in ANY situation... i.e. which would either detect all needed parameters/inputs/values/etc. automatially, or provide users with a comprehensive settings GUI where all the needed info can be easily configured.
And only then you might have the right to complain about SDL!
Creating a plugin for every possible one-off and specific need is total nonsense and just a waste of time... since solving the problem manually usually takes way less time that creating (and especially fine-tuning and debugging!) the plugin.
Your "solutions" might be perhaps an inspiration for another coders (who are capable of modifying your code to suit their different needs), but are basically useless for common translators.
Paul said:But I get an error trying to run it: Compile error: Wrong number of arguments or invalid property assignment I don't know enough about VBA to understand how to fix this... do you have any idea?
Click on the "Debug" button in the error message dialog. This will take you to the macro code and highlight the part of the code where the error occurred.And then you need to use appropriate analytic- and programming skills to understand what is going on and what the problem can be.
Every 6 months is actually not THAT frequently... doing the hiding work manually is still acceptable ;-). If you don't wan to do it manually, just record a macro in Excel (and then possibly clean it up a bit) and use the macro next time...
Alternatively, you can try to convince the client to start using more sophisticated format... since Excel is simply the most stupid way for such kind of work.