Passing data from Goggle sheets/Excel to repeater fields in Axure

technical-troubleshooting
advanced-prototyping
repeater-widget
newbie-question

#1

Hello, I am trying to find a way to link Goggle sheets/Excel to Axure.

The idea behind this is so that I can input data into a google/excel sheet and output it into a Axure repeater widget. I want to be able to do this all via excel and not have to input data values into the repeater data fields in Axure, Essentially I want to be able to use the google/excel sheet as a CMS, so that users with limited Axure knowledge can update any data via google/excel.


#2

This isn’t currently possible, although you can copy/paste from Excel or Sheets into the repeater data fields. That’s how I do it at the moment.

I believe it may be in their roadmap however.


#3

Seems it was (or possibly still is) possible with a connector Library:

The links to the original library files are down, but another poster reuploaded them. Hoping the original poster can bring this back since there seems to be a lot of interest.


#4

When I am trying to paste cells copied from Excel into the repeater data, it gets pasted as an image into one column :confused: all I am getting is

I am using Axure 9. I tried setting the number of columns in the repeater data to match the number of column in copied cells. I also tried having only one column in repeater data. Nothing works. Would you explain how you are doing that @davegoodman ?


#5

I no longer have Axure 9 installed in my current role, so I can’t test this, but are you selecting the cell or double clicking to focus into the cell? I think if you focus into the cell (i.e. you can see the cursor) then the paste operation will give you the result you’re seeing. But if you just select the top left cell, you should be able to paste normally.


#6

I did both. If I select the cell, the data is pasted as an image. If I double click into the cell, then all the data from multiple rows and columns is pasted into this one cell.


#7

Try using Ctrl/Cmd + Shift + V - this should paste the plain text rather than the fully formatted version. You may want to check your Excel preferences, as I believe some versions of Excel will give you a PNG as a copy object to the clipboard, rather than the text (to simplify the process of copying and pasting tables into Powerpoint etc).


#8

It finally worked by copying from Excel, pasting into text editor, then copying from text editor and pasting into Axure. Yep, Ctrl/Cmd + Shift + V is also working. Thanks @davegoodman!