Hi everyone, is it possible to program an app in xcode that scans a barcode and then write information into an excel document in hidrive?
Barcode Scanner and write to Excel
Scanning the barcode is the easy task. Do you want to write to an existing document (where in doc ? - Excel files format is really complex) or create a new one. You could write to a file (in SYLK format for instance) and import this in Excel doc.
I want to write to an existing excel document stored in web (Hidrive). I want to use it as an inventory app.
If i get a barcode reader working, you said its the easy part, and i have the plain text how could i send information to excel?
Would it maybe be possible with Data Streamer Add In?
You should read this old thread, which confirms what I told you: writing directly to an Excel file is overly complex. Not advised to try…
https://developer.apple.com/forums/thread/23656
However, here is a parser https://github.com/CoreOffice/CoreXLSX
or code to modify an empty file https://stackoverflow.com/questions/40403322/writing-data-from-tableview-to-excel-using-swift