General

Re: Reading from Excell

Matt Faus — Tue, 14 Nov 2006 16:15:06 GMT

It's probably going to be more trouble than it's worth to get your form to parse a CSV file - could you setup something in Excel to convert it to XML?

Re: Reading from Excell

Turnipboy — Mon, 13 Nov 2006 13:32:24 GMT

Thanks. Unfortuately I only have excel csv files to work with, not xml spreadsheets (our IT department won't give me anything else). Would I have to write a program, any help would be appreciated. Bascially row 1 contains headers like customer name etc and in the cell below (i.e. row 2) contains the specific info:

e.g.
Order number___Customer______Site____________Country
3213___________XYZ corp______Allentown_______UK

I have the fields for customer name, site and country in my infopath form and I want to automatically get them from excel. Also the csv file name is ordernumber.csv, so in the above example that would be 3213.csv, so I want infopath to choose the correct csv file based on the order number (which is entered manually into infopath) and then get the relevant information from it.

Re: Reading from Excell

Suresh Reddy — Mon, 13 Nov 2006 11:30:22 GMT

Hi,

Try out this linkhttp://www.infopathdev.com/forums/topic.asp?TOPIC_ID=1860
Hope this will help you

Reading from Excell

Turnipboy — Mon, 13 Nov 2006 09:41:08 GMT

Hi,

Is there a way to read data from Excel using infopath?

Thanks.