Hello.
My team and I are using the FitNesse for Appian automation tool and need to know how we can connect and manipulate data from an excel sheet.
Discussion posts and replies are publicly visible
I don't believe you can retrieve data directly from a spreadsheet, but there are still a few ways you can load and use data in Appian. You will likely need to use a variable: http://localhost:8980/FitNesseForAppian.Documentation.Development.UsingVariables to use data in Appian. If you look at the bottom section for How can I generate variables for my tests it gives you a few good options. I've typically used the Web API option, because it gives you a lot of flexibility. You can create a web API design object in Appian which could query data from anywhere (database, Appian data, etc.) and return the information to your test.