You can create a real-time link between a sheet in Orca Scan and Microsoft Excel from the web application. Data collected by users with the Orca Scan mobile app will then be pushed directly into your Excel sheets from anywhere in the world.
Microsoft Excel for Mac has several options for formatting cells to help organize information in business spreadsheets, including two types of double underlines. The first option is the standard double underline, which places two lines under all of the characters within a cell. The second method is the double accounting underline, which places.
- There are a number of barcode reader apps, but Barcode-x is the only app that can replace a professional PDA Barcode Scanner. With its intuitive and easy-to-use user interface Barcode-x is a great solution for inventory and item movements in your distribution centre, warehouse, stock room or store.
- Step 4: Set up your barcode. A pop-up window will appear. You can choose to import your barcode data from a spreadsheet, add sequential numbering or type in a specific barcode. The sample view will show you what your barcode will look like. Click the circular arrow button to refresh the view image after entering your information.
- To set up an Excel spreadsheet with these barcode Macros, refer to the Barcode Tutorial for Excel. Note: C128 ReturnTypes 6 through 9 are not currently supported in Excel-Word mail-merges. Excel 2000 and 2003 require a medium security setting to run Macros. Open Excel and set the security level to medium by choosing Tools - Macro - Security.
- Sep 18, 2015 In this post, we’ll take you through using EZOfficeInventory to set up a Barcode scanner on your PC or Mac. To learn how to set up a Barcode scanner on the EZOfficeInventory mobile app, click here. EZOfficeInventory gives you a lot of options to speed up checkouts and reservations. These include.
Quickstart
To get started, log in to your Orca Scan account and create a Cloud Sheet. Once you've done that, use the following 4 steps to set up the connection.
- Get the export link from your Orca sheet
- Navigate to the Get Data section in Excel
- Paste the export link
- Set the import frequency
1. Go to Integrations menu
Click Integrations Settings on the Sheet you want to set up.
2. Activate and copy URL
Then Allow the Public URL access to activate the link and copy it to the clipboard.
3. Save updates in Orca
Finally, don't forget to save the updates on the integrations settings.
Now, let's head over to Microsoft Excel...
4. Go to Get Data section in Microsoft Excel
Find the Get Data menu Hover over From Other Sources, and click From Web
5. Paste the export link
The window below will surface - now paste the link from Orca Scan
6. Approve import settings
Then connect with standard anonymous access (advanced: configure if needed)
7. Confirm and load data
Click Load
8. Set import frequency
You can configure how often Excel pulls data from Orca Scan.
Click the Refresh button to do it manually, as seen here:
URL export configurations
You can configure the data export by appending parameters to the URL, for example:
| Function | URL parameter |
|---|---|
| Change output format | .html / .csv / .json / .xml |
| Include audit trail | transactions=true |
| Include deltas for numeric columns | deltas=true |
| Change date format | datetimeformat=DD/MM/YYYY |
| Change time zone | timezone=-03:00 |
Important: always use a ? before the first parameter and an & before each additional parameter, for example:
That's it!
How To Set Up A Barcode Scanner With Excel For Mac Download
Your Excel spreadsheet will now mirror everything in your Orca Sheet. So if you add, update or delete a row inside Orca Scan, Excel will pull those changes into your Excel Spreadsheet.
Important: Clearing your Orca Sheet will also clear the data from your Excel Spreadsheet.
Barcode Generator
Questions?
Barcode Scanner App
We're always happy to help, chat with us live or drop us an email.