1. Home
    1. Dashboard
    2. Search
  2. Forum
    1. Unresolved Threads
    2. Members
      1. Recent Activities
      2. Users Online
      3. Team Members
      4. Search Members
      5. Trophys
  3. Articles
  4. Blog
  5. Videos
  6. Jobs
  7. Shop
    1. Orders
  • Login or register
  • Search
This Thread
  • Everywhere
  • This Thread
  • This Forum
  • Articles
  • Pages
  • Forum
  • Blog Articles
  • Products
  • More Options
  1. Robotforum - Support and discussion community for industrial robots and cobots
  2. Forum
  3. Industrial Robot Support and Discussion Center
  4. Fanuc Robot Forum
  5. Manuals, Software and Tools for Fanuc Robots (you should look here first before posting)
Your browser does not support videos RoboDK Software for simulation and programming
Visit our Mainsponsor
IRBCAM
Robotics Channel
Robotics Training
Advertise in robotics
Sponsored Ads

Tool that labels/comments FANUC data directly from Excel spreadsheet

  • jay
  • September 26, 2019 at 10:49 PM
  • Thread is Unresolved
  • jay
    Reactions Received
    25
    Trophies
    3
    Posts
    82
    • September 26, 2019 at 10:49 PM
    • Best Answer
    • #1

    I wrote an open-source command-line tool called fexcel a while ago that reads an Excel spreadsheet and then populates the comments/labels for things like registers, position registers, string registers, user alarms, I/O, etc.

    You basically tell fexcel where your data is located, how the columns are laid out and a list of robot IP addresses, and it will go and do everything for you... probably in less than a second. (Probably overkill, but it works concurrently. i.e. it takes about the same time to label one robot as it does to label 20 robots)

    Usage:

    Make sure KAREL is unlocked under Setup > Host Comm > HTTP.

    fexcel [options] filename host(s)...

    > ./fexcel -sheet Data -numregs A2 -posregs D2 -dins IO:A2 spreadsheet.xlsx 127.0.0.101 127.0.0.102

    You can read more about it here or at the project's GitHub repository. Download the latest release here.

    ONE Robotics Company

  • Go to Best Answer
  • kwakisaki
    Reactions Received
    694
    Trophies
    11
    Posts
    4,770
    • September 26, 2019 at 11:15 PM
    • #2

    I've just started to get my head into the Fanuc family and have visited your website too for some background reading.

    Found it very informative and tried your fexcel spreadsheet very useful indeed, whilst using Roboguide helped me to set some basic templates quickly without 'like you say key bashing'.

    Makes it a whole lot easier for sure...……..:top:

    Many thanks as I have found your information very useful indeed.

    View my channel at Industrial Robotics Consultancy Limited - YouTube

  • pdl
    Reactions Received
    270
    Trophies
    9
    Posts
    1,533
    • September 27, 2019 at 1:11 AM
    • #3

    This is an awesome tool, so awesome that you could probably sell a bunch of copies for good money. Thanks for making it available free of charge to the community.

  • jay
    Reactions Received
    25
    Trophies
    3
    Posts
    82
    • January 16, 2020 at 10:58 PM
    • #4

    I just pushed a beta release of fexcel v2, and I would appreciate your feedback. You can download it here.

    From the release page:

    New features

    * Create a spreadsheet based on the comments of a remote robot or backup directory with `fexcel create`

    * Compare the comments in your spreadsheet to any number of targets (remote robots or backup directories) with `fexcel diff`

    * Create a configuration file so you don't have to pass the location flags to fexcel every time with the `--save` flag

    * See what fexcel sees in your spreadsheet and provided configuration (args or config file) with a bare `fexcel` command

    * Get help on any command via `fexcel help` or `fexcel help [cmd]` or `fexcel [cmd] --help`

    Improvements

    Too many to name, but it's worth mentioning that the comment setting/updating command (`fexcel set`) works intelligently. v1 just hammered each robot with potentially hundreds of requests, but v2 only updates comments that are different from the spreadsheet.

    Usage

    Use `fexcel help` or see the README on the dev branch.

    ONE Robotics Company

    Edited once, last by jay: updated release url (January 17, 2020 at 9:36 PM).

  • KUKA_Robot_Lovers
    Trophies
    3
    Posts
    10
    • January 20, 2020 at 7:03 AM
    • #5

    Hi,jay,

    I don't know how to use this .exe file

    After executing the command, the CMD window shows "Not an internal command or external command"

    Please forgive my ignorance of computer knowledge.

    Looking forward to your answer, thank you!

  • jay
    Reactions Received
    25
    Trophies
    3
    Posts
    82
    • January 20, 2020 at 8:17 PM
    • #6

    Hi KUKA_Robot_Lovers,

    Sounds like either you mistyped the program name or your command prompt doesn't know where the exe is.

    1. Make sure your cmd prompt is in the same directory as fexcel (e.g. C:\Users\KUKA_Robot_Lovers\Downloads) or place fexcel somewhere on your system's PATH

    2. If you're in the same directory as the exe, you should be able to type "fexcel" then TAB to complete the rest of the filename

    3. Use "fexcel help" for more information on the various command line flags

    Hope this helps.

    ONE Robotics Company

  • KUKA_Robot_Lovers
    Trophies
    3
    Posts
    10
    • February 22, 2020 at 8:05 AM
    • #7
    Quote from jay

    Hi KUKA_Robot_Lovers ,


    Sounds like either you mistyped the program name or your command prompt doesn't know where the exe is.


    1. Make sure your cmd prompt is in the same directory as fexcel (e.g. C:\Users\KUKA_Robot_Lovers\Downloads) or place fexcel somewhere on your system's PATH

    2. If you're in the same directory as the exe, you should be able to type "fexcel" then TAB to complete the rest of the filename

    3. Use "fexcel help" for more information on the various command line flags


    Hope this helps.

    Display More

    command:

    C:\Users\***>fexcel --sheet Data --numregs A2 spreadsheet.xlsx 127.0.0.1

    Error: requires a spreadsheet

    some problem happened

    and how to solved it?

  • KUKA_Robot_Lovers
    Trophies
    3
    Posts
    10
    • February 22, 2020 at 8:14 AM
    • #8

    C:\Users\***>fexcel create ./spreadsheet.xlsx 127.0.0.101

    __ _

    / _| | |

    | |_ _____ _____ ___| |

    | _/ _ \ \/ / __/ _ \ |

    | :tired_face: __/> < (_| __/ |

    |_| \___/_/\_\___\___|_|

    v2.0.0

    by ONE Robotics Company

    http://www.onerobotics.com

    Error: no cell locations defined

    and also error happened!!!

  • KUKA_Robot_Lovers
    Trophies
    3
    Posts
    10
    • February 22, 2020 at 11:59 AM
    • #9

    I have tested

    Only support FANUC System Ver8.30

  • cobenson
    Reactions Received
    10
    Trophies
    3
    Posts
    314
    • March 30, 2020 at 10:25 PM
    • #10

    I just use a file I created in Karel. This way you do not need to worry about command prompts. We all use Karel anyways!

  • KJustian
    Trophies
    3
    Posts
    1
    • September 24, 2020 at 10:36 PM
    • #11

    I would like/love to download the "beta release of fexcel v2, ... You can download it here" < but this link is not working for anything but v1.2 and the readme link also does not work.

  • zet-jaro
    Reactions Received
    3
    Trophies
    3
    Posts
    28
    • December 6, 2021 at 7:23 PM
    • #12
    Quote from jay

    I just pushed a beta release of fexcel v2, and I would appreciate your feedback. You can download it here.

    From the release page:

    New features

    * Create a spreadsheet based on the comments of a remote robot or backup directory with `fexcel create`

    * Compare the comments in your spreadsheet to any number of targets (remote robots or backup directories) with `fexcel diff`

    * Create a configuration file so you don't have to pass the location flags to fexcel every time with the `--save` flag

    * See what fexcel sees in your spreadsheet and provided configuration (args or config file) with a bare `fexcel` command

    * Get help on any command via `fexcel help` or `fexcel help [cmd]` or `fexcel [cmd] --help`

    Improvements

    Too many to name, but it's worth mentioning that the comment setting/updating command (`fexcel set`) works intelligently. v1 just hammered each robot with potentially hundreds of requests, but v2 only updates comments that are different from the spreadsheet.

    Usage

    Use `fexcel help` or see the README on the dev branch.

    Display More

    Hi Jay!

    I have just downloaded your program and I think its great!

    Yet, I have two questions:

    1. Could you please provide some more examples on how to use SET command? I am trying to save configuration with following command but he doesnt want to accept it:

    fexcel set c:/users/t.stampar/Downloads/spreadsheet1.xlsx 127.0.0.1 --gins G2 --save ./savedata.yaml

    2. Is it possible to just download all data without using flags, just this template?

    Thank you very much!

    Kind regards,

    Tom

  • GiannisGk
    Reactions Received
    1
    Trophies
    2
    Posts
    12
    • May 9, 2023 at 8:38 AM
    • #13

    Hi guys,

    I have tried to run the set command, to set data at a virtual robot in Roboguide

    and turned up the following error.

    Any help?

  • Online
    Tat_Iron_Man
    Trophies
    1
    Posts
    15
    • March 29, 2024 at 12:52 PM
    • #14

    Please record a detailed video tutorial on how to use the program

    :smiling_face_with_horns:

Advertising from our partners

IRBCAM
Robotics Channel
Robotics Training
Advertise in robotics
Advertise in Robotics
Advertise in Robotics

Job Postings

  • Anyware Robotics is hiring!

    yzhou377 February 23, 2025 at 4:54 AM
  • How to see your Job Posting (search or recruit) here in Robot-Forum.com

    Werner Hampel November 18, 2021 at 3:44 PM
Your browser does not support videos RoboDK Software for simulation and programming

Tag Cloud

  • abb
  • Backup
  • calibration
  • Communication
  • CRX
  • DCS
  • dx100
  • dx200
  • error
  • Ethernet
  • Ethernet IP
  • external axis
  • Fanuc
  • help
  • hmi
  • I/O
  • irc5
  • IRVIsion
  • karel
  • kawasaki
  • KRC2
  • KRC4
  • KRC 4
  • KRL
  • KUKA
  • motoman
  • Offset
  • PLC
  • PROFINET
  • Program
  • Programming
  • RAPID
  • robodk
  • roboguide
  • robot
  • robotstudio
  • RSI
  • safety
  • Siemens
  • simulation
  • SPEED
  • staubli
  • tcp
  • TCP/IP
  • teach pendant
  • vision
  • Welding
  • workvisual
  • yaskawa
  • YRC1000

Thread Tag Cloud

  • abb
  • Backup
  • calibration
  • Communication
  • CRX
  • DCS
  • dx100
  • dx200
  • error
  • Ethernet
  • Ethernet IP
  • external axis
  • Fanuc
  • help
  • hmi
  • I/O
  • irc5
  • IRVIsion
  • karel
  • kawasaki
  • KRC2
  • KRC4
  • KRC 4
  • KRL
  • KUKA
  • motoman
  • Offset
  • PLC
  • PROFINET
  • Program
  • Programming
  • RAPID
  • robodk
  • roboguide
  • robot
  • robotstudio
  • RSI
  • safety
  • Siemens
  • simulation
  • SPEED
  • staubli
  • tcp
  • TCP/IP
  • teach pendant
  • vision
  • Welding
  • workvisual
  • yaskawa
  • YRC1000
  1. Privacy Policy
  2. Legal Notice
Powered by WoltLab Suite™
As a registered Member:
* You will see no Google advertising
* You can translate posts into your local language
* You can ask questions or help the community with your knowledge
* You can thank the authors for their help
* You can receive notifications of replies or new topics on request
* We do not sell your data - we promise

JOIN OUR GREAT ROBOTICS COMMUNITY.
Don’t have an account yet? Register yourself now and be a part of our community!
Register Yourself Lost Password
Robotforum - Support and discussion community for industrial robots and cobots in the WSC-Connect App on Google Play
Robotforum - Support and discussion community for industrial robots and cobots in the WSC-Connect App on the App Store
Download