Library documentation: Excel - v1.00 B4J Library XLUtils / jPOI 5 - Read and write MS Excel workbooks - Erel    Mar 4, 2022   (38 reactions) 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... are strings such as: "sheet1!F2:M100" or named ranges. Named ranges are set in Excel (search for name manager in Excel). This is a very useful feature. 112058 - Empty or missing cells - In... B4J Library jPOI - Supports Microsoft Excel xls and xlsx Workbooks - Erel    May 25, 2021   (21 reactions) 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... B4J Library jExcel library - Erel    Jan 1, 2021   (6 reactions) 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... B4A Tutorial Read / Write Excel files on Android - Erel    Jul 28, 2013   (23 reactions) 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... B4J Tutorial [XLUtils] Writing Excel Workbooks - Erel    May 6, 2021   (18 reactions) 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... B4J Code Snippet Tip - Forcing Excel Columns To Be Stored As Text - Erel    Jul 8, 2019   (2 reactions) Use case: reading an Excel workbook where the column data is not consistent. Some of the cells are correctly stored as dates and some as text. Handling the various types is easy in B4J assuming that you can access the raw text value. In Excel: 1. Select the column. 2. Data - Text to Columns 3. Choose the default values in the first two screens. It doesn't really matter. 4. Change the format to Text: https://www.b4x.com/basic4android/images/EXCEL_sOKSKpYare.png... B4J Question Error MAC OpenExcel (XLUtils) - MarcoRome    Feb 9, 2023 Hi Erel, All.
All run on Windows but if i open excel file with
Wait For (xl.OpenExcel(nomefile....OpenExcel(nomefile)) Complete (Success As Boolean)
Log("Eseguito")
... B4J Tutorial B4XTable + jPoi + Excel Workbook - Erel    Apr 10, 2019   (8 reactions) https://www.b4x.com/basic4android/images/SS-2019-04-10_10.52.25.png It is very simple to read data from an Excel workbook and show it with B4XTable. The almost complete code: B4XTable1.AddColumn("Country", B4XTable1.COLUMN_TYPE_TEXT) B4XTable1.AddColumn("Region", B4XTable1.COLUMN_TYPE_TEXT) B4XTable1.AddColumn("Population", B4XTable1.COLUMN_TYPE_NUMBERS) Dim poi As PoiWorkbook poi.InitializeExisting(File.DirAssets, "countries of the world.xls", "... B4J Code Snippet Set Author, Title and Category for Excel - aeric    Mar 20, 2022   (3 reactions) If you follow the tutorial, the excel file is created with a default author "Apache POI". Dim jo As JavaObject = Me jo.RunMethod("updateTitle", Array(File.Combine(File.DirApp, "Products.xlsx"), "Products")) jo.RunMethod("updateCategory", Array(File.Combine(File.DirApp, "Products.xlsx"), "Category")) jo.RunMethod("updateAuthor", Array(File.Combine(File.DirApp, "Products.xlsx"), "Aeric Poon"... B4A Code Snippet [B4X] Localizator - Script for Excel to translate directly from google translate - scsjc    Jun 25, 2022   (13 reactions) I share an Excel file with a visual macro to translate directly using google translate, It also detects and warns if any key is repeated in red. I use it a lot in my apps, thanks to B4XLocalizator https://www.b4x.com/android/forum/threads/b4x-localizator-localize-your-b4x-applications.68751/ 130801 130803... Page: 1   2   3   4   5   6   7   |