Formular una preguntaFormular una pregunta
 

PreguntaConsuming Excel data in an InfoPath form

  • martes, 01 de diciembre de 2009 11:12Jessica Meats Medallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuario
     

    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.

    • CambiadoMike Walsh MVPMVP, Moderadormartes, 01 de diciembre de 2009 11:46infopath (From:SharePoint - Excel Services)
    • EditadoMike Walsh MVPMVP, Moderadormartes, 01 de diciembre de 2009 11:46Services removed from Title. No reference to Excel Services in the text - only Excel, Also moving to the InfoPath forum
    •  

Todas las respuestas