Fazer uma PerguntaFazer uma Pergunta
 

PerguntaConsuming Excel data in an InfoPath form

  • terça-feira, 1 de dezembro de 2009 11:12Jessica Meats Medalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuário
     

    I have an InfoPath form and I want to populate some of the fields with figures from an Excel spreadsheet. The problem is, I don't have a fixed row number for the cells in Excel.

    In Excel, I have a table. The first column of this table is "metric name." The first field in my form is "metric name." The user will fill out the "metric name" field in the form. I then want the form to fill out other fields with the values from Excel which are in the row where the value in the "metric name" column equals the value on the form. Basically, I want to be able to filter the Excel table while doing the look-up.

    • EditadoMike Walsh MVPMVP, Moderadorterça-feira, 1 de dezembro de 2009 11:46Services removed from Title. No reference to Excel Services in the text - only Excel, Also moving to the InfoPath forum
    • MovidoMike Walsh MVPMVP, Moderadorterça-feira, 1 de dezembro de 2009 11:46infopath (From:SharePoint - Excel Services)
    •  

Todas as Respostas