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

[zäpfle]

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

[Questionmarker]

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.

[smercurio_fc]

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.

[zäpfle]

Thank you all

I think I can solve the problem

[zäpfle]

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

[smercurio_fc]

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

[zäpfle]

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

[zilla]

Here is another example:

[smercurio_fc]

---

@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.

[zäpfle]

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