Barcode Scanner and write to Excel

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?

Up vote post of stephan944 Down vote post of stephan944
1.3k views
Posted by
stephan944
Reply

  • 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.

    —
    Claude31
Add a Comment

Replies

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?

Posted by
stephan944
Up vote reply of stephan944 Down vote reply of stephan944
Add a Comment

Would it maybe be possible with Data Streamer Add In?

Posted by
stephan944
Up vote reply of stephan944 Down vote reply of stephan944
Add a Comment

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

Posted by
Claude31
Up vote reply of Claude31 Down vote reply of Claude31
Add a Comment