locked
excel / resx file >> expert advice need for an automatization script / RRS feed

  • Question

  • User-2060258345 posted

    Do you guys have an idea?

    I've an excel files with orginal datas in english and the traduction in another language juste beside and I've my xml resx file with my id of the ressource, and my translation column.


    The only link between them is the text which is the same in english. like:


    excel

    a1 = "my text"  b1 = "mon text"

    my resx file is a copy of the english one so something like

    col1 = label1   col2= "<h2>my text</h2>" 

    I need to change this as resource.fr.resx >> col1 = label1   col2= "<h2>mon text</h2>"


    Do you guys have an idea how can I automatize that ? which language should I use... vbscript?

    what do you reckon ??


    Thanks a lot,


    Friday, March 5, 2010 4:18 AM

Answers

  • User-36838843 posted

    .resx is a XML file so you can read ResXResourceReader/ResXResourceWriter classes to read/update value in .resx file.


    Here is the steps

    1) read row one by one from excel

    2) check that resourcekey in french resource file.  if exists, update that value from excel sheet.  if not found add that key in french resource file along with value from excel sheet.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 8, 2010 12:58 PM

All replies

  • User-1659704165 posted

    Hi,

    http://forums.asp.net/p/1527103/3688756.aspx

    http://www.asp.net/%28S%28ywiyuluxr3qb2dfva1z5lgeg%29%29/learn/videos/video-40.aspx

    http://www.asp.net/%28S%28wnmvzu45umnszm455c1qs522%29%29/learn/ajax-videos/video-179.aspx

    localization

    Friday, March 5, 2010 5:37 AM
  • User-36838843 posted

    .resx is a XML file so you can read ResXResourceReader/ResXResourceWriter classes to read/update value in .resx file.


    Here is the steps

    1) read row one by one from excel

    2) check that resourcekey in french resource file.  if exists, update that value from excel sheet.  if not found add that key in french resource file along with value from excel sheet.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 8, 2010 12:58 PM