iOS Question create excel files?

[ilan]

hi

is it possible to create excel files with b4i (like we have excel lib in b4a)?

i searched the forum but could not find any lib.

thanx

 

[Erel]

There is no Excel library for B4i. You can create CSV files with StringUtils.

 

[ilan]

There is no Excel library for B4i. You can create CSV files with StringUtils.

Thank you erel for your answer.

Can i also create columns and raws with stringutils so when i open the file in excel i will get the same result like i am getting with the excel lib of b4a?

 

[Erel]

CSV (comma separated values) files are made of rows with multiple fields. Excel will show it as a table. You cannot change the formatting.

Note that Excel doesn't properly handle non-ASCII text in CSV files.

 

[ilan]

CSV (comma separated values) files are made of rows with multiple fields. Excel will show it as a table. You cannot change the formatting.

Note that Excel doesn't properly handle non-ASCII text in CSV files.

hi i have just tried to create a csv file and send it via MailComposer from my app. everything works but when i open my file (with Open Office) i get only rows but all values are in only 1 column even i have used "," as SeperatorChar.

how can i get the values i create each in a different column and not all in the same column?

EDIT: ok got it, when i open open office i have the possibility to choose seperator option so choosing COMMA will open the file with all columns.

 

[imbault]

I think it should be easier with .xlsx, cause of their xml nature

 

[Erel]

I think it should be easier with .xlsx, cause of their xml nature

It is a very complicated format. It is implemented in B4J jPOI library that is based on Apache POI.

 

[ilan]

Note that Excel doesn't properly handle non-ASCII text in CSV files.

i found out that if you open the file with character set: "Unicode (UTF-8)" you should see any text (i tested it with hebrew)
so when i open the file with "Open Office" i just select "Unicode (UTF-8)" and it works

i also add a line with the info to the csv file my app created

"Important! Open the file with Character Set: Unicode (UTF-8) if you can't see hebrew characters

(maybe this may be helpful for someone else)

 

[Pendrush]

When you export CSV in first line (before any data) add this sep=,
This tell excel to use comma as separator.
http://superuser.com/a/686415