Search Results

As written here, I plan to make it easier to read and write Excel workbooks. The solution is based... on the Excel program. - jPOI - This is a wrapper for Apache POI. - XLUtils - A b4xlib (B4J only... the addresses "names", as they appear in Excel. You can create an address in three ways...
link: - V2.09 - New bidi attribute for paragraph tags. Dim doc As WordDocument = wd.CreateDocument doc.Append($" ${WrapLineWithRTL(&...
link: - V2.08 - New FieldCode tag for Word documents: $" Page out of ... "$ 155847...

it only supports Microsoft Excel related APIs. It is an alternative library to jExcel: https://www... (Excel 2007+ format). jExcel only supports the old format. More powerful. Apache POI is an active project.... Note that if the workbook is opened in Excel then the program will fail to open it. The attached...

A more powerful library is now available: https://www.b4x.com/android/forum/threads/jpoi-supports-microsoft-excel-xls-and-xlsx-workbooks.57392/ This library allows you to read and write XLS files. It is similar to B4A Excel library: http://www.b4x.com/android/forum/threads/read-write-excel-files-on-android.25632/#content You should follow the steps in the above link to download and copy the native library. There are two new methods in this library: ReadableWorkbook.InitializeAsync...

The Excel library is a new library that wraps the open source jexcel project and allows you to read or write Excel workbooks. This library supports XLS files. The new xml based format (xslx) is not supported. Setup - Download the attached library and copy both files to the libraries folder. - Download jexcel library: A Java library for reading/writing Excel - Browse /jexcelapi/2.6.12 at SourceForge.net (jexcelapi_2_6_12.zip). - Open the zip file and copy jxl.jar to the libraries folder...

Hi Fam... Let's say you have an excel sheet / a database that you want to convert to a WebApp, how can you do it? SithasoDaisy5 has a basic, simple app builder that can help you create a table...
link: Here is Part 2 https://www.b4x.com/android/forum/threads/web-excel-to-webapp-creating...
link: To be continued... PLEASE DO NOT ASK QUESTIONS ON THIS THREAD...
link: 3. Creating Table Fields Each table we will create will have fields, these will have titles and oth...

Hi Fam Some web apps need to be completed with reporting functionality. This can be in PDF, Excel, Word format etc. Today we look at Excel Reporting. You can create your Excel Template to your hearts desire and then read it and feed it content. Problem Statement: We want to easily generate excel reports from existing Excel Templates. Imagine This: Dim report As SDUI5ExcelReport report...(report.execute) You give it your Excel Template file name, the sheet to process, write some content...

Main concepts and reading MS Excel workbooks with XLUtils: https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel-workbooks.129969/#content Writing workbooks is also simple....xlsx", True) Wait For (xl.OpenExcel(f)) Complete (Success As Boolean) StopMessageLoop... in Excel. It returns the modified file name. You can use it with xl.OpenExcel to show the workbook with Excel, if Excel is installed. - Colors should be indexed colors = XL.COLOR constants...

Hi Fam Download from Github (02. Tutorials/Projects/Collectables) Final Web App Screens Side Drawer 163735 163730 163736 163731 163737 163732 163738 163733 163734 163739 This tutorial is a continuation of this tutorial.. https://www.b4x.com/android/forum/threads/sithasodaisy5-create-a-webapp-from-an-excel-spreadsheet-a-database.166633/ Here is the YT Video SOGCM1PsLNw Enjoy! PS...
link: This next video takes you through the process of creating the Collectables using SithasoDaisy Low Code. 56jFcoT_TwE The project is on the Tutorials Folder of SithasoDaisy5...

Hi Fam I wanted to generate an excel report based on an existing template. The template should... write it back by saving it. I have talked about reading and creating Excel reports here. 1. https...
link: More details... https://builtin.com/software-engineering-perspectives/exceljs...
link: a buffer, then save this as a Blob and then download this excel file 'save the updated...
link: my excel sheet....

for B4X Web applications — automatically generating Excel report templates using our low-code source... JSON data records …and dynamically populates an Excel report based on mapped column definitions... updating those Excel templates? That’s time-consuming and error-prone — especially when you need multiple variations or updates. ✨ The Big Leap: Auto-Generated Excel Report Templates The goal... feature — “Generate Excel Report Template” — scans your table’s columns and auto-generates an Excel file...