Dekui uz info. 20 programkiu bandyti nesinorejo, tai tikejausi jau isbandziusiu komentaru. Aisku, kad Excelis darbui su duomenimis tobuliausias. Tai pabandysiu su tuo makrosu, tikiuosi, kad pavyks.


"rimux" <pastas@pastas.com> wrote in message news:nrjdnaltdjg3ind53gnsn499tcmn4t3b77@4ax.com...
>O siaip tai googlas visagalis, va tau surinkau makro is internetiniu pavyzdziu, kaip irasineti aktyvu exelio sheeta i csv su utf8 koduote:
> 
> 
> Sub Save_CSV_UTF8()
>  Dim ws As Worksheet
>  Set ws = ActiveSheet
>  Call SaveWorksheet_As_CSV_UTF8("d:\temp\utf8.csv", ws)
> End Sub
> 
> Function SaveWorksheet_As_CSV_UTF8(ByVal sUTF8CSVOutputFileName As String, ByVal wksWorksheet As Excel.Worksheet)
>  Const sComma As String = ","
>  Dim lDataRows As Long, lDataColumns As Long, lRowIndex As Long, lColumnIndex As Long
>  lDataRows = wksWorksheet.Cells.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
>  lDataColumns = wksWorksheet.Cells.Find(What:="*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
>  
>  Dim vararrData() As Variant
>  ReDim vararrData(1 To lDataColumns)
>  
>  Dim adodbStream As Object
>  Set adodbStream = CreateObject("ADODB.Stream")
>  adodbStream.Type = 2
>  adodbStream.Charset = "utf-8"
>  adodbStream.Open
>    
>  For lRowIndex = 1 To lDataRows
>      For lColumnIndex = 1 To lDataColumns
>          vararrData(lColumnIndex) = wksWorksheet.Cells(lRowIndex, lColumnIndex).Text
>      Next
>      'adodbStream.WriteText Join(vararrData, sComma), adWriteLine
>      T = Join(vararrData, sComma)
>      T = T + Chr(13) + Chr(10)
>      adodbStream.WriteText T, adWriteLine
>  Next
>  
>  adodbStream.SaveToFile sUTF8CSVOutputFileName, 2
> 
> End Function
> 
> 
> 
> Bent jau pas mane veikia, kada irasau i celes teksta su lietuviskom raidem, ir po to uzseivinta su situo makrosu  failiuka atidarau su notepad++,
> tekstas teisingai rodomas buna. Gali modifikuotis pagal tai ko tau reikia - vietoj kablelio kabliataskius pasidaryti, ir pan.
> 
> Jeigu problema su atidarymu failo utf8, analogiska makrosa atidarymui failo galima pasirasyti.
> 
> 
> 
> 
> On Tue, 9 Jun 2015 13:36:17 +0300, "Aras" <nera@nera.nera> wrote:
> 
>>Excelis iskraipo, jeigu tekste yra rusisku ir lenkisku raidziu. Kitu atveju nebesupranta internetas, jei nedarau UTF-8 koduotes.
>>
>>"marijonas" <jo@fa.na> wrote in message news:ml6bvg$rbi$1@trimpas.omnitel.net...
>>> "Aras" <nera@nera.nera> Wrote in message:
>>>> Gal esate i?testav? kokia nemokama programa geriausia CSV failams redaguoti? Excelio nesi?lyti, bo jis nesusitvarko su UTF-8.
>>>> 
>>> 
>>> Siulau exceli
>>> -- 
>>> 
>>> 
>>> ----Android NewsGroup Reader----
>>> http://usenet.sinaapp.com/
>>>
>