I have an excel spreadsheet set up to calculate average, count, max and min of some data that will be regularly altered.
I would like to connect the spreadsheet cells to my form sop that this calculated data is imported into my form (created in Livecycle Designer).
I have looked at numerous pages explaining connecting to databases but don't seem to be able to translate this information to relate to excel. Could someone please help me connect these single cell pieces of data from Excel spreadsheet to my form.
I am now looking at eporting the data as an xml file from excel in an attempt to make this work. It seems to me that this should/could be possible but is just out of my grasp. When I think I find the answer it does not hold enough detail for me to follow through with making it work
Can anyone steer me in the right direction.
Message was edited by: CDesign2
If you designed the original form (from which the xml/excel data was created) as pdf, it is straight forward as if reintegrating data back into the form. I suspect that may not be the case in your situation. However, try to save the excel/xml document as a pdf document. Then using adobe reader or professional, open this document and Adobe will load the elements. You may want to you use Adobe LiveCycle to edit or create a form and preview at the same time until you are satisfied. In that case open the saved pdf form in liveCycle. Hope this helps.
Thanks for responding Mike-Davies!
I am trying to use DATA from say excel and use it to populate a form. The
excel form would be updated and then hopefully so would the relevant areas
of the form, which would do other things with the data. I am not sure
that what you have suggest will accomplish that....but maybe I am missing
If I understood you correctly, you are either trying to
I suspect points 2, 3 may be the case.
My experience with migrating excel data back to adobe is this.
If you created the original form with adobe, you have the option of distributing the form (file/form distribution..)
to recipients list (could include form creator).
This allows adobe to generate a distribution and form response file and therefore able to track returned forms either as pdf (preferably) or excel/xml converted back to pdf after saving it.
For Point 2 above,assuming your original data set were created using an adobe form you previously saved, open your original form in acrobat pro, go to menu/forms/manage form data/import data (usually as xml). It automatically repopulates the form.
To view returned forms as a set, go to menu/forms/compile returned forms and this will bring up a window that
-to browse and locate your response file (essentially defining the index form),which is opened into the top row
-then find and add each new completed form into a list in the second row.
You then click ok and all returned forms are opened in a tracker window...
I just realised I am talking about liveCycle ES version8 and this forum refers to pre ES!
I am not sure if this helps but I hope it answers some of your questions.
I'm working on this same thing today, and we are getting it to work. First make sure that you define a data range for your Excel spreadsheet information. Next, follow the instructions at: http://www.ehow.com/how_12175930_connect-adobe-livecycle-excel-workshe ets.html After building the connection string in Step 3, be sure to select the Table radio option and select your data range from the dropdown list. Hope this help!