Micros and spreadsheet

I want to write a micro that will pull variables from a spread sheet and update from the spread sheet each cycle. Is thIs possible and does anyone have examples?

Hi

There are no macros in Linuxcnc, which I assume is what you mean.
You can use binary programs, bash scripts, python etc, but none of them is called in the same way as the visual basic macros in mach.

A spreadsheet is a GUI representation of numerical data for humans to be able to grasp, it is not an ideal format for any data for machining.
Whatever produces this spreadsheet would be better programmed to do it in at least a csv format, if not actually outputting gcode.

................update from the spread sheet each cycle

depends what you mean by 'each cycle'

Can you arbitrarily, externally change values that the interpreter has already used to read ahead and plan the next moves, in mid program, no.

Can you run a program, then re-write the program based upon new data and run the new program, yes.

If want to make movements based upon external data, which is unknown at the point of commencement, then you are really into setting up a psuedo DNC
and making all the calls through MDI, one at a time.

Without more info, cannot be specific.

regards

The machine will run the same program all the time the only changes will be distance the dimensions will come from an excell spreadsheet