Android Question Export to CSV can't be read.

makis_best

Well-Known Member
Licensed User
Longtime User
I export some info from sqlite database to csv file.
The data in database are in Greek.

The code I use to save data is
B4X: 
Public Sub SaveTableToCSV(Dir As String, Filename As String)
    Dim headers(mNumberOfColumns) As String
    For i = 0 To headers.Length - 1
        Dim L As Label
        L = Header.GetView(i)
        headers(i) = L.Text
    Next
    StringUtils1.SaveCSV2(Dir, Filename, ",", Data, headers)
End Sub

But when I open the CSV file I cant read anything and the excel show something like.


How I can fix it?
 
Sort by date Sort by votes
R

RB Smissaert

Well-Known Member
Licensed User
Longtime User

You don't show how you got your data and I think headers needs to be a list, not an array.

RBS
 
Upvote 0

makis_best

Well-Known Member
Licensed User
Longtime User
I read data from a table

B4X: 
Sub Globals
    Private Kartela_Table As Table
End Sub

Sub SendBtn_Click
    Dim Message As Email
    Message.To.Add(EmailEditText.Text)
    Message.Subject = "ΚΑΡΤΕΛΑ ΠΕΛΑΤΗ: " & NameEditText.Text
    Kartela_Table.SaveTableToCSV(Starter.SafeFolder, "kartela - " & NameEditText.Text & ".csv")
    Message.Attachments.Add(File.Combine(Starter.SafeFolder, "kartela - " & NameEditText.Text & ".csv"))
    StartActivity(Message.GetIntent)
End Sub
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
Upvote 0

klaus

Expert
Licensed User
Longtime User
The problem is Excel not B4A.
If you want to read it with Excel you need to change the encoding.
As a workaround, after having saved the file with SaveTableToCSV, you can:
Read the file back with TextReader.ReadAll and save it back with TextWriter.Initialize2 and TextWriter.Write where you can set the encoding you need.
 
Upvote 0

makis_best

Well-Known Member
Licensed User
Longtime User
OK... I make the chances with TextWriter.Initialize2 but now StartActivity(Message.GetIntent)
not working properly... It doesn't show the list of available applications to choose from but
start the Exchange server settings
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Solved
Android Question B4X Load .csv file from download folder
Replies
1
Views
1K
Mahares
M
M
  • Question
Android Question Save CSV file in UTF8
Replies
1
Views
2K
Erel
A
  • Question
Android Question Export SQLite to CSV File not Found
Replies
12
Views
2K
Andromeda
A
R
  • Question
Android Question Files created with File.WriteList command not visible in Explorer
Replies
4
Views
1K
RDCrozier
R
  • Question
Android Question Import CSV
Replies
6
Views
2K
LA3QMA
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…