CodeProject: RESX to XLS conversion for multi-language support. Free source code and programming help

Report Article

Discuss

Send to a friend

6 votes for this Article.

Popularity: 3.52 Rating: 4.53 out of 5

Resx2Xls ScreenShot

Introduction

Do you need to localize your RESX files and don't want to open them one file at a time, clean them of unused keys, localize them etc., etc.? Then Resx2Xls is for you.

Open Resx2xls. Click on "Create new Excel document...," select your Project Root and follow the wizard. Done!!
Fill your Excel file with your localized key values or just send it to your translator.
Now, do you want to create the localized RESX files from the filled Excel workbook? Open Resx2xls, click on "Generate resx files...," select your Excel file, click Next and then click Finish. Done!!
Have you updated your project after your resource files were modified/added/removed/updated? No problem. Open Resx2xls, click on "Update your Excel document...," click Next, select your Project Root and Excel document and click Finish. Done!!

Thanks go to Manish Ranjan Kumar and his WizardBase control. It has helped me to give the application a more decent style.

Background

I was frustrated with copying my project resource files created in VS 2005, cleaning them of unused keys and then localizing them one file at a time. This tool should help you to just point and click at your project and obtain an Excel file filled with all of the strings of ALL of your resource files. After compiling the XLS with the translations, I wanted to convert all of the keys back into localized RESX files. I hope this helps!

Points of interest

I've had some problems loading resources with the ResxResourceReader class. I've noticed that if you have an image resource stored in the resource file, the path of the image in the XML document is relative to the document itself, not the project. Opening from another directory, i.e. Resx2xls bin, I get a "cannot parse" path exception. This was solved by setting the BasePath property of the resource reader with the path to the RESX file.

History

25-7-2007: Article edited and posted to the main CodeProject article base
5-7-2007: Added wizard
4-7-2007: First release

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Marco Roello

Occupation:	Web Developer
Location:	Italy

Other popular C# articles:

Asynchronous Method Invocation
How to use .NET to call methods in a non-blocking mode.
I/O Ports Uncensored - 1 - Controlling LEDs (Light Emiting Diodes) with Parallel Port
Controlling LEDs (Light Emiting Diodes) with Parallel Port
IconLib - Icons Unfolded (MultiIcon and Windows Vista supported)
Library to manipulate icons and icons libraries with support to create, load, save, import and export icons in ico, icl, dll, exe, cpl and src format. (Windows Vista icons supported).
100% Reflective Class Diagram Creation Tool
100% Reflective Class Diagram Creation Tool
I/O Ports Uncensored Part 2 - Controlling LCDs (Liquid Crystal Displays) and VFDs (Vacuum Fluorescent Displays) with Parallel Port
Controlling LCDs (Liquid Crystal Displays) and VFDs (Vacuum Fluorescent Displays) with Parallel Port

Article Top

You must Sign In to use this message board.

Msgs 1 to 9 of 9 (Total in Forum: 9) (Refresh)

FirstPrevNext

Subject

Author

Date

Fantastic!

uswebpro2

3:50 18 Aug '08

This is great! thanks It would great if the RESX comments were preserved too. That way you can help the translators see the context of the terms you have. - aron
Sign In·View Thread·PermaLink

Ottimo lavoro...

Nicola Costantini

5:59 21 Jan '08

ho visto i sources ed intuisco che questo funziona sse è installato Office2003 o 2005 ossia quelli che danno supporto di ToolLibrary a Dot.Net. Immagino niente per versioni precedenti di Excel che usano invece l'oggetto COM vero ?
Sign In·View Thread·PermaLink	1.00/5 (1 vote)

Excellent work

Ethan Huang

0:13 20 Sep '07

What you do is what I need Thank you very much
Sign In·View Thread·PermaLink	2.00/5 (1 vote)

COMException: Old format or invalid type library

marco vervoort

22:18 10 Jul '07

Hi Marco,

I get an unhandled exception when running your project:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in Resx2Xls.exe
Additional information: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))

The exception raises in Resx2XlsForm.DataSetToXls in line:
Excel.Workbook wb = app.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
Perhaps an incompatibility with Office Excel? I've Excel 2003 installed.

Regards,
Marco Vervoort - Pulse Business Solutions

Re: COMException: Old format or invalid type library

Kerdal

8:18 17 Jul '07

That's a regional settings issue.
(See http://support.microsoft.com/kb/320369 for more information)

There are 3 possible workarounds :

1. Manually set your regional settings to be the same than your excel's language.

2. Before using automation, switch the currentthread cultureinfo to en-us (en-us is apparently universal for automation, it works with any other language)

3. Install the Multilingual User Interface Pack for your version of Office. (see the kb article for the link)

Personally, I prefer switching the currentthread cultureinfo before using automation (and switch back once automation is complete).

5.00/5 (1 vote)

Re: COMException: Old format or invalid type library

marco vervoort

22:16 17 Jul '07

Thanks, that solved the problem.
You've already written the code in file Resx2XlsForm.cs at line 32-34, but commented it out. After removing the comment tags, it worked.

Great tool Cool

. Nice to translate the resources. It still needs some tweaking before I can use it, but it's a good starting point. Currenlty you only load the default culture, altough I already have a localized resource which is not imported into Excel. And I get an OUT_OF_MEMORY from Excel at about 240 labels. I think I have about 800 labels in my resouce file. But these are thinks I can solve by my selve :->.

You haven't imported the comment from the resource file. The default resouce reader (ResXResourceReader) doesn't load the comments. I would suggest using an XmlReader with a few more lines of code. The comment can be very valueable for translations Sniff

Regards,
Marco Vervoort - Pulse Business Solutions

Re: COMException: Old format or invalid type library

uswebpro2

3:09 18 Aug '08

I had the same error. However I did not have Office installed. I just installed Office 2003 and the error went away. - aron
Sign In·View Thread·PermaLink

resource editor with multi language support

edwin_vermeer

3:39 10 Jul '07

ResEx is a nice resource editor with support for multiple languages. What you can do with it:

Translate values side by side (just like the old time classic VB6 resource editor)
Lock specific strings so that translator does not translate them
Restrict length of translating strings
Ensure correct translation of strings with placeholders {0} {1} ...
Warnings about shortcut characters (string containing &)
View resource strings in tree form
Translate resources without Visual Studio IDE
Search inside resource files while translating

You can find it here:
http://www.papadi.gr/projects/resex.aspx

Re: resource editor with multi language support

Marco Roello

22:36 22 Jul '07

Thanks Edwin,

I've downloaded it and I can say it's a very good tool, with a very friendly interface. But it missises one of the main purpose of my project.

The purpose of this utility (at a very early stage) is to allow a developer to produce a Single Excel document containing ALL the Resx files of your project. I don't want to open each resx file, one at a time, translate it in all languages and so on....

Marco

1.67/5 (3 votes)

Last Visit: Sunday, September 7, 2008 6:36 AM Last Update:Sunday, September 7, 2008 6:36 AM

General News Question Answer Joke Rant Admin