Search Results

Hello everyone, I want to share a method to be able to export a table from B4XTable to an Excel...+ Public Sub ExportTableToExcel(Table As B4XTable, FileName As String) Log("Exporting table...
link: Hey Brian Michael, I can't find Excel Library in library manager in B4A, Can you please help m...
link: Hey Brian Michael, I can't find Excel Library in library manager in B4A, Can you please help me...
link: Hey Brian, thanks in advance for this wuick example! Just a quick comment, its only save the file bu...

its content. The data in B4XTable is stored in an in-memory database. The table name is 'data... editable table: https://www.b4x.com/android/forum/threads/b4x-cross-platform-editable-b4xtable-form...
link: No. Only editing existing cells. It shouldn't be too difficult to add new rows or delete rows....
link: Hi Thanks Erel for this wonderful and easy to use table. At this time I can't test the example b...
link: B4XTable v1.08 adds long click events. It should be simple to implement this with the new event...

Hello everyone, I want to share a method to be able to export a table from B4XTable to an Excel....6+ Public Sub ExportTableToExcel(Table as B4XTable) Dim xl As XLUtils : xl.Initialize...
link: Thank you LucMs for your support. I found the problem. The issue was calling the excel button from ...
link: Even if I comment the "Wait For" the results will be the same it closes my application. ...

Hi, i also create a B4A example: https://www.b4x.com/android/forum/threads/export-b4xtable-to-excel-file-b4a.145029/...
link: Dim oWWB As WritableWorkbook Dim oWS As WritableSheet Dim bCellFormatting As Boolean...
link: The reference above is from B4J (PC desktop), which uses the jPoi library. see: https://www.b4x.com...
link: The reference above is from B4J (PC desktop), which uses the jPoi library. see: https://www.b4x.com/...

I get the solution: I just create a Map var to set the data, before i add this map in the list. Do While rs.NextRow Dim row As List row.Initialize Dim trow As Map trow.Initialize Dim c As B4XTableColumn For i = 0 To Table.Columns.Size - 1 c = Table.Columns.Get(i) Select c.ColumnType...
link: As B4XTable) Dim data As List data.Initialize Dim rs As ResultSet = Table.sql1...

based on Erel's example, I use this code to export data from B4Xtable in different activities...") Public Sub ExportTableToCSV(Table As B4XTable,ExportFileName As String) As ResumableSub... Dim c As B4XTableColumn = Table.Columns.Get(i) row(i) = rs.GetString(c.SQLID...
link: thanks so much Erel, works perfect...
link: You should use B4XTable.BuildQuery....

For Each c As B4XTableColumn In B4XTable1.Columns If...
link: This worked great I tried the method proposed to you by Erel, but the text file that was exported...
link: ") Do While rs.NextRow Dim row(B4XTable1.Columns.Size) As String...

Hi, how can i export or convert the B4XTable rows to a json file?...
link: (Table As B4XTable) As List Dim data As List data.Initialize 'Load B4XTable...
link: Of course there is a way and it should be quite simple to do based on the code I posted. I recommend...
link: Hi Erel, thanks for answer. I need the output looks like: "Data": { ...

Thanks for this suggestion Erel....
link: File Explorers can access RP.GetSafeDirDefaultExternal. Another option is to request the write exter...
link: have a way to export the data (in this case, records of cheeses that I, and my artisanal home...
link: I wanted to export the data in the CSVfile to Excel, how is that done safely? I'm not sure...

I am very familiar with BuildQuery. I use it a lot. It is nothing but a representation of a paramet...
link: 134256 Dim obj() As Object = tbl.BuildQuery(True) Dim sql As String = obj(0) Log(sql) ...
link: EDIT: in B4A use: I am very familiar with BuildQuery. I use it a lot. It is nothing but a represen...
link: Solved with: That code you posted does not help others, as you do not show what o(0) and o(1) are...