excel to xml to labview

[RavensFan]

DSarge,

You posted links to the ae.natinst.com server.  They are only visible to NI employees.

You need to post the links that are accesible by the public.

[dsarge101]

Apologies. Try these two, they should be the public links.

http://digital.ni.com/public.nsf/allkb/EA451498B828894886256F67007AE6B9?OpenDocumen t

http://digital.ni.com/public.nsf/allkb/3E1759E53173D8BD862573D200686E20?OpenDocument 

[id]

I am working with Labview, not CVI which makes the first link N/A.  The secondlink says  "LabVIEW has built-in XML tools that can be used to work with schemas, manipulate XML data, and perform XML parsing."

I do not see the ability of Labview to work with schemas from external sources.  I only see the way Labview works with its own schema.  Any thoughts??

[Ficare]

Hello,

I have the same problem.

Maybe can we read the data thru a .net method exposed by excel ?

(supposing excel is installed on the PC)

BR

[Roohcifer]

LabVIEW's flatten to and unflatten from string functions will work with the LabVIEW XML schema. To use a different XML schema in LabVIEW, you will need to parse the XML. This NI white paper has some more information:

https://www.ni.com/docs/en-US/bundle/labview/page/parsing-xml-files-in-labview.html

Let me know if this helps!

[Yamaeda]

---

@id wrote:

what I have is an excel SS to enter engineering data as a starting point.  What I want to do though is to have an XML file as the datafile that is stored as a part of the program for life cycle sustainment that is read into the Labview program. My challenge is that Excel does not write an XML file based on a labview schema. 

---

The much easier way is to save the Excel file as a comma or tab separated text file. 🙂

/Y

[Ficare]

Hi,

actually, I used ActiveX functions, it seems to work quite well. Some tuning may be required...

Phil

[id]

thanks but I seem to have errors if I save my file in excel to either an xml ss or an xml format still.  What are you saving your file in excel to in terms of teh excel dialogs?

[Ficare]

I don't use excel to save my file, it is created by a measuring device directly into xml format.

Maybe try to use the open method in lieu of the openxml methode ...

Phil

[Eric1977]

Is it a requirement that those Excel files be saved as an XML file? If it were me, I'd save them as a comma-delimited text file as Yamaeda suggested.