Search Results

You are referring to the NHS datasets. The given link gives access to files with an Excel extension. The contents of an Excel file contain text that has been written in a certain way. The method depends, among other things, like the Excel version, the cell formatting, character size, text color, bac
link: Had a look at this and unfortunately, although they are called Excel files they have all the items in a row concatenated with the ¬ character in one c
link: Of course Windows Excel can import/open text files with different (not comma or tab) field delimiters, but not sure this can be done in B4A code with
link: I just opened the file as .txt or .csv and processed that, but you are right the files in the mentioned link are Excel files. I know how to read these

The thing with the automobiles was just another example I had in mind. The real background: I am working as a hardware technician for digital printers, so the Excel file is for solving hardware problems on several devices. Categories for example (imagine that as columns within the sheet): name of t
link: Oh my goodness Emexes, I think I've given your brain a problem to work on, haven't I? I am impressed by your commitment! This attempt also looks very
link: Yeah, I was taking a chance that your Excel API could handle RnCn-style addressing like Excel can (or could: it was a carryover from Multiplan, maybe

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")

https://www.b4x.-jpoi-5-read-and-write-ms-excel-workbooks.129969/
link: result.BottomRight points to the last non-empty row.

What about Excel? You can create a template and fill it with jPOI or the soon to be released XLUtils library.

Hi guys, I have an excel file, doc.xls in my default app folder. Suppose I have a button view, when user click this button, an app that able to read excel file automatically open and read this doc.xls file. Is that possible? If possible, how to do that? Thanks in advance.
link: Read / Write Excel files on Android
link: That is not what I want. Let's say that user has Microsoft excel in his phone. When he clicked a button in my app, my app open Microsoft excel and
link: See intents. You can share that Excel file to MS Excel.

Well the online excel sheet is created from walt61 html feed. Maybe there it is marked as B4A.
link: B4J Excel Set Author, Title and Category for Excel Set Author, Title and Category for Excel https://www.b4x.com/android/forum/threads/set-author-title
link: B4X B4X B4Xgoodies_from_walt61 Online Web based version of the B4Xgoodies Excel workbook https://www.b4x.-online.110060/ B4X B4X B4Xgoodies Excel Yo

is it posible to convert an excel file to pdf fit it in 1 page?, how?
link: Searching I found that each sheet should be adjusted and save the file before use PowerShellConvertToPdf Sheet sheet = wb.getSheetAt(sheetnumber); P

File.Exists does not support the File.DirAssets folder. 97498 You should probably use File.DirData("AppName") instead.
link: I would like to load parameters from an external EXCEL file. I loaded the file by using B4J files system command. File has been copied in "Files" fold
link: Try and see Log(file.dirassets) and the extension of your file, xls, xlsx? C:\Users\roerg\OneDrive\DOCUME~1\ProjB4J\PROJECTNAME\Objects - DIRAPP C:\Us

Use XLUtils: XLUtils / jPOI 5 - Read and write MS Excel workbooks

Powered by ColBERT