vba - How to create customized cvs files from excel? -


i linguist, not programmer or excel guru.

i have excel file this:

  • a column: master language (en_us, en_gb etc)
  • b column: english master sentence
  • c column: translation of x language. , first row has language code (de_de)
  • d, e, f... columns: translation of each , different languages.

the number of lines unlimited. need create tab delimited utf-8 csv files that:

en_us \t english master sentence in row 2 \t de_de \t translation in row 2  en_us \t english master sentence in row 3 \t de_de \t translation in row 3
  • en_us retrieved column a.
  • \t tab.
  • english master sentence retrieved column b.
  • de_de in first row of each relevant column.
  • translation retrived relevant column.

i stuck that. have either option of doing manually each language or having macro after preparing excel.

if want open text file output , cycle through worksheet , output each row csv, you'll need open file output, cycle through sheet next loop, building csv rows print statements. see "how write in txt file vba" (put "22907176" in search bar @ top of page) started. tab chr(9), you'll use statement such as

print #1, cells(counter,1) & chr(9) & cells(counter,2)

is you're after?


Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l...
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more