Android Tutorial Read / Write Excel files on Android

Status
Not open for further replies.

fabio55

Member
Licensed User
Longtime User
I need the excel table to be drawn a little bit down the page. This to allow an editing text box on top of the table itself. There is a Table class in the example but if a change the SV (the internal scroll view) top property I get an error..The best wold be to place the table inside a panel or a TabHost, but how to do that?
 

Firpas

Active Member
Licensed User
Longtime User
Is possible insert images in a cell with this lib??

Thanks for your answer
 

lorebarita

Member
Licensed User
Longtime User
I am trying to read an excel document with xlsx extention and I get the following error

java.lang.RuntimeException: jxl.read.biff.BiffException: Unable to recognize OLE stream

So my question is does the library support excel 2013 format
 

jefflynn1974

Member
Licensed User
Longtime User
I want to make some backup of my workbook but after I use newWorkbook.Write I can not save later the same workbook again. Is there any solution for this situation?
 

fabio55

Member
Licensed User
Longtime User
If this can help I save my workbook several times without problems, I think you should show your code..
 

jefflynn1974

Member
Licensed User
Longtime User
I attached my sample application.

It records the touches on a button to an .xls file. The data have been saved when you quit from the app and in every minute as a backup.
The problem is that after the automatic backup is executed the save at the exit is do nothing. You can check this when you click the button after a minute and you won't see it in the workbook.
 

Attachments

  • demo.zip
    4.6 KB · Views: 656

Devan

Member
Licensed User
Longtime User
Hi to all, I'm not a programmer, but im learning Android programming language since January'15. This B4A and the active community has been very helpful for my project. I manage to convert SQL db to CSV. But I want to convert my SQL db to excel. After going through Excel tutorials & Questions im unable to find any sample code or understand how to do it.

Below error is from ExcelExample code from Erel.
What the reason for this error
Parsing code. 0.08
Compiling code. Error
Error compiling program.
Error description: Cannot access private member: numberofcolumns
Occurred on line: 444
For col = 0 To Table1.NumberofColumns - 1
Word: numberofcolumns

Parsing code. 0.08
Compiling code. Error
Error compiling program.
Error description: Cannot access private member: header
Occurred on line: 430
For Each lbl As Label In Table1.Header
Word: header
 

Devan

Member
Licensed User
Longtime User
I've just downloaded the example from the first post and it compiled successfully. NumberOfColumns is a public variable. Have you modified the code?

Hi Erel, yes i modified than i change back to same as per your example. Anyway i will download again & let me check. Meanwhile can you provide sample code to convert Sql db into excel as per .csv.
What the difference between public variable & private member.
Thank you
 

Erel

B4X founder
Staff member
Licensed User
Longtime User
Status
Not open for further replies.
Cookies are required to use this site. You must accept them to continue using the site. Learn more…