Import Excel files via LABTALK

Asked By alyss aellaa 10 points N/A Posted on - 12/13/2013

 

I would like to import a few files from Excel that contain data in two rows each via LABTALK I want to use that data to plot an XY coordinate graph. I have written a script but was unsuccessful in importing the files. Please help me with the correct code. Thanks.
 

• Status: Open
• Question Views: 971
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: LabView

Answered By points N/A #177371

Import Excel files via LABTALK

Hello,

This task requires a code that will be inserted in a cell. The code is as below:

dlgfile gr:=Excel mu:=1;

loop(ii,1,fname.GetNumTokens(CRLF))

{

file$ = fname.GetToken(ii,CRLF)$;

// Customize Excel import options as needed

impExcel fname:=file$

lname:=1

desig:=<Unchanged>

options.names.FNameToBk:=0;

plotxy (1,2) plot:=200;

}

Open a workbook. Go “Formulas” from the ribbon on the top and select “Insert Function”. Paste the code there, and fill all the argument fields accordingly.

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 03/21/2014
• Question Category: LabView