Excel to .NET resource file conversion

Question

I have resource strings for various languages collected into a large excel sheet. Is there a tool to convert the strings for each language into .NET resource files (resx)?

-pom

Answer 1

Simple cut-and-paste worked for me:

1. In the excel create a table with two columns: one for the control names, the second with the words/phrases of the language you have next to each control name (the control names can be copied from VS simply by selecting the controls "Name" column in the resx file and pasting in excel...)
2. Create an empty resx file for that language (such as yourproject.language.ru.resx)
3. In the excel select and copy the two columns from 1 above
4. back in the empty resx file, mark the "Name" and "Value" fields of the first empty row
5. Right-click paste

As I develop, I maintain only the English language file. For each release, I update the excel with the new controls and their translations, remove the other old languages resx files, re-create then and past as described above.