Android Question b4a how to Show Data Rows Cols Like Excel?

[xiaoyao]

Which control do I need to use to create a simple app like Excel?
If editing is still possible, which control is better and how to save data?


For example, loading a CSV file into a table, or ABC XLS, ABC.XLSX files, or JSON format data.
[{"col1":"a1","Col2","a2"},{"col1":"b1","Col2","b2"}]

 

[xiaoyao]

If it could support setting the color of one column, one row, or automatic spacing between two colors, it would be more convenient
It can be modified in the app, and the color information will be automatically loaded the next time it is opened.
It would be even better if the color configuration of Excel table cells could be converted into JSON information

 

[epiCode]

[B4X] B4XTable - Cross platform, sortable, searchable, customizable table

B4XTable is a paged based table. The UI is made of a horizontal xCLV. The data is stored in an in-memory SQLite database. How to use? 1. Add a B4XTable with the designer. 2. Add the columns: B4XTable1.AddColumn("US County", B4XTable1.COLUMN_TYPE_NUMBERS) B4XTable1.AddColumn("Name"...

www.b4x.com

 

[Shelby]

I agree with Mr. Epicode's suggestion above. Many members here use SQLite for their table needs. Also, the SQLite db browser is useful for fast editing and producing a new table. The color of table cells can be accomplished by using the designer function in the IDE. There is even a function of the db browser where one can take cells from an excel document and place those cells in a table using the db browser.