In XFDF the field name is listed following field name = "" and the value is contained in a separate element. In XML the data element contains the field name and the value is listed thereafter: Now that I recall, there is a slight difference between XFDF and XML If it would only need a few tweaks to be made to work for you (like having a configuration option that says where to append the new data rows instead of always inserting them at row two) then let me know and I'll see what I can do. I hope that this utility can be useful to you but I have a suspicion, purely based on the fact that you're using Livecycle, that your needs might be a bit more complex than it can handle. The idea of appending into the second row is to place the new data somewhere easy to find for a quick visual check (or any immediate manipulation you want) as Excel can very easily sort them to your liking once you are happy with the loaded rows.
#Convert adobe to excel code
The code expects an existing Excel file with one row of headers (which are used as column names when mapping between the XFDF field names and Excel) and inserts data into the second row of the first sheet, shifting the existing data down - so: Yes, it does append data to an existing file that can have as much pre-existing data in it as you like. but also more if you need to load several at once. Yes, the file open dialogue for the XFDF files will allow you to select only one file. So if the Livecycle data file's XML looks like that then it should work but my quick trawl through the Livecycle documentation this morning indicates that it may not work as it stands. The code expects the fields and values in the XFDF file(s) to be in the format:
I haven't looked at the spec for the data files out of Livecycle XFA so I don't know how similar they are. The import uses the data file portion in XFDF format.
0 kommentar(er)
