excel printing

[Greg_Shipley]

I have Labview 6.1 and Windows 2000. I am using the printout method of the Sheets Invoke node for Excel and I do not get a printout to my printer eventhough there is activity on my network connection. The printer and my PC do work together and I can print directly from Excel and I can print the worksheet I am trying to use in Labview manually from Excel. I am unclear on what needs to be connected to the ActivePrinter input. I connected a boolean true.
Any words of advice?

[Zvezdana S.]

Greg,
I have attached an example that accepts the path and file name of an ASCII or Excel spreadsheet file, and prints it to the default Windows printer without displaying Excel. (Everything is done in the background.) When printing an ASCII file, make sure that it is in spreadsheet format. The columns should be separated by tabs or commas, and so on.

Each of the examples in the zip files generate a 5 X 5 array of random numbers and save it in an Excel2000 or earlier version spreadsheet file using ActiveX. The VI then displays and prints the Excel file. There is one attachment for Excel2000 and one for Excel97.
Zvezdana S.