Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

exporting .resx file to excel.

1,070 views
Skip to first unread message

NIDU

unread,
May 16, 2008, 5:41:39 AM5/16/08
to
I am using Rc WinTrans as the software to localize the strings we use
in our company`s software. These strings are stored and managed in
a .resx file, and can be opened using microsoft visual studio. Once
opened in MS visual studio i want to export their IDs,Source Text,
German Translation to an excel file. I know the objects and functions
that i use to export .resx file from Rc WinTrans. And i also know how
to use excel vbscript. Can anybody guide me how to export the same
source file(.resx) to an excel file once opened in MS visual studio.
What kind of objects and functions do i have to use?

mr_unreliable

unread,
May 16, 2008, 1:55:17 PM5/16/08
to
hi NIDU,

As best I can tell, a resx file is an old-fashioned "res" file,
rendered into xml, the format used by vs.

I can't imagine what you want the file in xl for, as you can
most likely modify or re-format it any way you want with
vbscript.

However, if you must use xl, then there are (at least) two
options.

Option 1, just import the file as a text file. You can do
this by changing the file ext to "txt", or by adding a "txt"
extension to the existing file name. (ex. owc10.aspx.resx.txt).
You can then use the import wizard to specify the delimiters.
If you specify a crlf, you will most likely import the resx
into xl with each line loaded into an xl row. Or, you could
use a blank as a delimiter, in which case you get each new
phrase on a new row.

Option 2 (my preferred option), you write an xl vba macro to
use the "MSXML2.DOMDocument" object to import the "resx" file.
Then use the object to parse the xml into its constituent
pieces-and-parts, and load it however you wish into xl. But
then you could use "MSXML2.DOMDocument" from script to
reprocess the resx file directly.

cheers, jw
____________________________________________________________

You got questions? WE GOT ANSWERS!!! ..(but,
no guarantee the answers will be applicable to the questions)

0 new messages