ilan Expert Licensed User Longtime User Jul 13, 2016 #1 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
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 B4X founder Staff member Licensed User Longtime User Jul 14, 2016 #2 There is no Excel library for B4i. You can create CSV files with StringUtils. Upvote 0
ilan Expert Licensed User Longtime User Jul 14, 2016 #3 Erel said: There is no Excel library for B4i. You can create CSV files with StringUtils. Click to expand... 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? Upvote 0
Erel said: There is no Excel library for B4i. You can create CSV files with StringUtils. Click to expand... 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 B4X founder Staff member Licensed User Longtime User Jul 14, 2016 #4 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. Upvote 0
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 Expert Licensed User Longtime User Jul 22, 2016 #5 Erel said: 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. Click to expand... 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. Last edited: Jul 22, 2016 Upvote 0
Erel said: 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. Click to expand... 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 Well-Known Member Licensed User Longtime User Jul 23, 2016 #6 I think it should be easier with .xlsx, cause of their xml nature Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Jul 24, 2016 #7 imbault said: I think it should be easier with .xlsx, cause of their xml nature Click to expand... It is a very complicated format. It is implemented in B4J jPOI library that is based on Apache POI. Upvote 0
imbault said: I think it should be easier with .xlsx, cause of their xml nature Click to expand... It is a very complicated format. It is implemented in B4J jPOI library that is based on Apache POI.
ilan Expert Licensed User Longtime User Sep 27, 2016 #8 Erel said: Note that Excel doesn't properly handle non-ASCII text in CSV files. Click to expand... 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 Click to expand... (maybe this may be helpful for someone else) Upvote 0
Erel said: Note that Excel doesn't properly handle non-ASCII text in CSV files. Click to expand... 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 Click to expand... (maybe this may be helpful for someone else)
Pendrush Well-Known Member Licensed User Longtime User Sep 28, 2016 #9 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 Upvote 0
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
