To log and export data to excel file with column headers

[stark8]

Hi...

I need to log sample number, date and time, voltage, current and power to a excel file and need to export that data to a specified location on the system. Can anyone help me with this?

Thankyou.

[GerdW]

Hi stark,

---

@stark8 wrote:

I need to log sample number, date and time, voltage, current and power to a excel file and need to export that data to a specified location on the system. Can anyone help me with this?

---

Sure we can help…

• What exactly is an "excel file"? Is a simple CSV text file sufficient (as its much easier to create)?
• What is a "location in the system"? Do you mean specific folder and filename? You can define this easily using a filepath constant…

[stark8]

Excel file means .xlsx file and save location would be the current VI folder.

[GerdW · Accepted solution]

Hi stark,

---

@stark8 wrote:

Excel file means .xlsx file

---

Use the ReportGeneration functions to create/handle XLSX files.

There are example VIs in the example finder…

---

@stark8 wrote:

save location would be the current VI folder.

---

Which is a bad decision, you better use "public" folders like Desktop or UserAppData…

There is a File constants palette with lots of predefined path constants (including CurrentVIPath), including a function to select several pre-defined folders in typical Windows environments!

[stark8]

Hi....

Can you send me an example program for this. I can't find examples for the above.

Thankyou

[GerdW]

Hi stark,

---

@stark8 wrote:

Can you send me an example program for this. I can't find examples for the above.

---

What is "this" and what is "the above"?

Please ask specific questions. It also helps to quote other messages (like I do) to provide context for your questions!

Maybe you are talking about the Report Generation functions:

• Have you tried to look for examples in LabVIEW's example finder?
• I (and Bob) can recommend the "Revised Excel" example...