LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

save data from LabVIEW2010 to Excel (Win7) with the format xlsx

Solved!
Go to solution

Hello all,

I have a question about the data save to Excel.
I want data save from LabVIEW2010 to Excel (Win7) with the format *.xlsx. I need directly this format.
Is there a "easy" way to do this. Maybe examples are somewhere.
The attachement shows a simple example. I know the "The Write to spreadsheet file.vi  " saves the data in the cvs format. But maybe this is the start of a solution.
Thanks in advance
 
zäpfle
0 Kudos
Message 1 of 12
(6,146 Views)

Hello,

 

Though I do not know why anyone would want to work with excel, especially for data analysis I think your problem is already solved; look in the help; in

labview\examples\comm\ExcelExamples.llb

you will find "Write Table To XL.vi"

This uses Excel as an Active-X component and should work just fine for you.

 

 

0 Kudos
Message 2 of 12
(6,142 Views)

As noted, you need to use ActiveX if you want to write directly to an Excel file. If you don't have the experience in dealing with ActiveX then you may wish to consider the Report Generation Toolkit.

0 Kudos
Message 3 of 12
(6,137 Views)

Thank you all

I think I can solve the problem

0 Kudos
Message 4 of 12
(6,127 Views)

Hello all,

unfortunately I couldn't solve the problem. Please see the attachment. I would like save the 2D Array to the shown path (C:\User\Public\.....). The prompt should not appear. The program stops at Invoke Node "Workbook close", why?

I don't know the error.

 

I hope anyone have solution.

 

many thanks in advance

 

Zäpfle

 

 

0 Kudos
Message 5 of 12
(6,081 Views)

You need to provide the filename to the Workbook.Close function. Please read the Help for that function.

0 Kudos
Message 6 of 12
(6,062 Views)

Hello,

sorry for the delay,

 

is it possible, that you explain with more details: "You need to provide the filename to the Workbook.Close function"

Where can I find the Help for that function.

 

Or maybe it's possible, someone completes the attached VI.

 

thanks in advance

 

regards zäpfle

 

0 Kudos
Message 7 of 12
(6,044 Views)

Here is another example:

 

 

0 Kudos
Message 8 of 12
(6,029 Views)

@zäpfle wrote:

Hello,

sorry for the delay,

 

is it possible, that you explain with more details: "You need to provide the filename to the Workbook.Close function"

Where can I find the Help for that function.

 

Or maybe it's possible, someone completes the attached VI.

 

thanks in advance

 

regards zäpfle

 


It's really quite simple. See the "Filename" input for the Close method? You have to wire in a path. You have a path there. Connect your path (which should be a control, NOT a hard-wired constant) to that through a Path to String function. Delete the file open function.

0 Kudos
Message 9 of 12
(6,027 Views)

Thank you very much for this part of the whole solution.

 

I don't wont a prompt (see unbenannt.png).

 

If the file isn't exist, the vi should generate a new one. If the file exist and the filename is the same, the vi overwrite the existing file.

 

Do you mean, there is a easy solution?

If so. Do you give me some good tips or examples?

 

thanks in advance

 

zäpfle

 

 

Download All
0 Kudos
Message 10 of 12
(6,022 Views)