From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Template

Hello LabVIEW group,

This is more of an excel question than a LabVIEW question, but I'm hoping
one of you has run into this before. I'm saving array data going to an XY
graph into an .xls file that has the correct deliminators to be read
properly by MS Excel. This works very well for me because I can read this
data and display it onto my XY graph later. However, when I open up excel,
I have to go through the motions of selecting the proper rows and columns
and graph wizards to re-create the graph in the excel program.

Does anyone know of a way to use a template so that I don't have to do this.
When I collect graph data, I collect dozens of graphs at a time and having
to go into excel and re-create all these graphs is time consuming. An
y info
would be great.

Thanks

George Callara




-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
0 Kudos
Message 1 of 5
(3,012 Views)
"George M. Callara" wrote:
>
> Hello LabVIEW group,
>
> This is more of an excel question than a LabVIEW question, but I'm hoping
> one of you has run into this before. I'm saving array data going to an XY
> graph into an .xls file that has the correct deliminators to be read
> properly by MS Excel. This works very well for me because I can read this
> data and display it onto my XY graph later. However, when I open up excel,
> I have to go through the motions of selecting the proper rows and columns
> and graph wizards to re-create the graph in the excel program.
>
> Does anyone know of a way to use a template so that I don't have to do this.
> When I collect graph data, I collect dozens of graphs at a time and having
> to go into excel and re-create all
these graphs is time consuming. Any info
> would be great.
>
> Thanks
>
> George Callara
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
George,

Hope you are not writing data into the .xls binary file, but
tab-delimited? If really so, and you are saving it into binary .xls, let
me know and we'll join our efforts to add your .xls writer to my .xls
reader vi's.
If you are writing ASCII text file to read in EXCEL, you probably
opening it through the EXCEL dialog sequence, where you can select
appropriate delimiter, in my case. Then I'm using in the
tab of text field delimiter instead of "" by default. This works for me.
--
Sergey Krasnishov,
--------------------------------------
Automated Control Systems
National Instruments Alliance Member
Moscow, Russia
sergey_acs@levsha.ru
-
-------------------------------------
0 Kudos
Message 2 of 5
(3,012 Views)
Anything you want with Excel is possible. Your choices include:

1. Use a template file that uses the INDIRECT function to extract data from another file

2. Use ActiveX to write data directly to a template file with the graphs

3. Use an Excel macro to create the graphs from the data

4. Copy and paste the data into a template file with the graphs

Your best bet is choice #1. Create a template with data on Sheet1 and your graphs on a separate
sheet. Then create formulas for the data array in sheet1 to find each data point in the other
file. A1 = INDIRECT("Datafile!A1"). You can then Define a Cell Name to "Datafile" and enter the
name of the file to display. When you change the name, the graphs updates instantly.
--
Michael Munroe Mailto:mmunroe@abcdefirm.
com
A Better Complete Development Engineering Firm
San Mateo, CA 94403 http://www.abcdefirm.com

"George M. Callara" wrote:

> Hello LabVIEW group,
>
> This is more of an excel question than a LabVIEW question, but I'm hoping
> one of you has run into this before. I'm saving array data going to an XY
> graph into an .xls file that has the correct deliminators to be read
> properly by MS Excel. This works very well for me because I can read this
> data and display it onto my XY graph later. However, when I open up excel,
> I have to go through the motions of selecting the proper rows and columns
> and graph wizards to re-create the graph in the excel program.
>
> Does anyone know of a way to use a template so that I don't have to do this.
> When I collect graph data, I collect dozens of graphs at a time and having
> to go into excel and re-create all these graphs is time consuming. Any info
> would be great.
>
> Thanks
>
> George Callara
>
> -----------== Posted via Newsfeeds.Co
m, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
Message 3 of 5
(3,012 Views)
Hello..
 
> i need to make an excel sheet from a template excel file that cannot be edited..
but i can only be displayed..
> Is it possible to open the excel sheets n labview software itself..
i mean without the tool Icons for Save, print..etc..
i should be only the display sheet..
 
 
TIJU
Regards

Tiju Thomas
0 Kudos
Message 4 of 5
(2,498 Views)

Duplicate post

-Lauren

Applications Engineering
National Instruments
0 Kudos
Message 5 of 5
(2,458 Views)