How to Save a Table Data to Excel File

[syrpimp]

Hi Does anyone know how to save data on labview table , I want to save those data to excel file.

[Munna232 · Accepted solution]

Duplicate Post

https://forums.ni.com/t5/LabVIEW/How-to-Save-a-multicolumn-listbox-Data-to-Excel-File/m-p/2974581

U can use,

1. Write To Spreadsheet File.vi

2. Report Generation Tool kit

[Dennis_Knutson]

Why would you ask this again when you marked the question as solved in your other thread?

[Hooovahh]

---

@Dennis_Knutson wrote:
Why would you ask this again when you marked the question as solved in your other thread?

---

Perhaps the OP is not satisfied with a ASCII text file being opened in Excel, and actually wants a XLS or XLSX file.  If that is the case checkout the Report Generation Toolkit which now comes with some versions of LabVIEW 2014, or look at XLR8.

[RTSLVU]

---

@Hooovahh wrote:

---

@Dennis_Knutson wrote:
Why would you ask this again when you marked the question as solved in your other thread?

---

Perhaps the OP is not satisfied with a ASCII text file being opened in Excel, and actually wants a XLS or XLSX file.  If that is the case checkout the Report Generation Toolkit which now comes with some versions of LabVIEW 2014, or look at XLR8.

---

You know if you make a text file with a TAB delimiter and give the file a .xls extension it opens in Excel just fine. I do it all the time.

[PaulG.]

---

@RTSLVU wrote:

You know if you make a text file with a TAB delimiter and give the file a .xls extension it opens in Excel just fine. I do it all the time.

---

NO. It does not open "just fine" because it's not an Excel file.

I wish people would STOP DOING THIS. Don't ever EVER put a .xls or any other file extension used by a licensed and or commercial application on a plain text file.

This kind of practice makes LabVIEW programmers look like rank amateurs.

STOP IT. NOW.

[crossrulz]

---

RTSLVU wrote:

You know if you make a text file with a TAB delimiter and give the file a .xls extension it opens in Excel just fine. I do it all the time.

---

You really should not do that.  It makes Excel do extra work.   But Excel can open up *.txt files just fine.  So I save my tab delimited text files with an extention of txt and then edit them with Excel.

[crossrulz]

---

Hooovahh wrote:

Perhaps the OP is not satisfied with a ASCII text file being opened in Excel, and actually wants a XLS or XLSX file.  If that is the case checkout the Report Generation Toolkit which now comes with some versions of LabVIEW 2014, or look at XLR8.

---

We should also mention that the Write Measurement File Express VI can save data with an xlsx format.  Yes, it is the true format that Excel uses.  So if you already have all of the data, that might be a really good way to go.

[RTSLVU]

---

@crossrulz wrote:

---

RTSLVU wrote:

You know if you make a text file with a TAB delimiter and give the file a .xls extension it opens in Excel just fine. I do it all the time.

---

You really should not do that.  It makes Excel do extra work.   But Excel can open up *.txt files just fine.  So I save my tab delimited text files with an extention of txt and then edit them with Excel.

---

Yes, but you have to go through the "import"  process every time and tell Excel the file is tab delimited, that's a P.I.T.A.

And it confuses my managers if I send them a raw data file that will not open directly in Excel by double clicking on it, as double clicking a txt file opens in Notepad by default.

Putting a .xls opens it right up in Excel, but Excel 2010 and newer will say it's not really an Excel file but allow you to open it anyway.

Right or wrong I find it is eaiser for everyone if I do that.

[RTSLVU]

---

@PaulG. wrote:

---

@RTSLVU wrote:

You know if you make a text file with a TAB delimiter and give the file a .xls extension it opens in Excel just fine. I do it all the time.

---

NO. It does not open "just fine" because it's not an Excel file.

I wish people would STOP DOING THIS. Don't ever EVER put a .xls or any other file extension used by a licensed and or commercial application on a plain text file.

This kind of practice makes LabVIEW programmers look like rank amateurs.

STOP IT. NOW.

---

I have been doing this for 20 years becasuse it confuses my managers if I send them a raw data file that will not open directly in Excel by double clicking on it.

Right or wrong I find it is eaiser for everyone if I do that, and I am not going to stop now.