Text file import into Excel.

[chrlum47]

Would somebody happen to have a simple example VI for the following:
Text file import into Excel. Anything reasonably close would be appreciated thank you.

[GerdW]

Hi chrlum,

---

@chrlum47 wrote:

Would somebody happen to have a simple example VI for the following:
Text file import into Excel. Anything reasonably close would be appreciated thank you.

---

Read the text file using ReadTextFile in LabVIEW. Then use RGT functions to send to text data to Excel.

LabVIEW comes with RGT example VIs…

[RTSLVU]

This is hardly a LabVIEW problem...

1. Open Excel
2. Browse to the directory your file is in
3. You might have to set the filter to display "All Files (*.*)"
4. Select your text file
5. This should automatically start the "Text Import Wizard"
6. Excel will ask you a couple questions about how to delimit your file and format anything that might be a date or time.
7. Follow the prompts and click Finish 

[chrlum47]

I'm kind of a newbie..RGT?

Could you direct me to that example?

[RavensFan]

RGT = Report Generation Toolkit

[chrlum47]

Yes that's exactly what I needed thanks again..

[chrlum47]

I'm having a little trouble with "easy text report VI"
under report generation.

I'm in version 2015..

Does anybody have or can direct me to an example to run this VI using Excel report type?

[cbutcher]

I don't have 2015 installed to check, but if I open the Example Finder ("Help > Find Examples..." on the toolbar in LabVIEW) and then go to the search tab (top left) and search for "report generation excel" I get a whole collection of examples.

Admittedly the first one is for an HTML report, but reading from the second entry works fine 😉

[GerdW]

Hi chrlum,

which "trouble" do you encounter?