LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

print all excel sheet in the folder

hello,
i want to create an autoprint function if my vi.
how do i print all the excel files in a directory?
thank you in advance
p.s---i am using labview 7.0



Message Edited by krispiekream on 04-01-2008 03:41 PM
Best regards,
Krispiekream
0 Kudos
Message 1 of 9
(3,374 Views)
basically, i want to list the file names in the directory and print all files..
my files happen to be excel format, so i want to print all of the files..


i dont want to have to open up every file and click on the print button, one at a time..

Best regards,
Krispiekream
0 Kudos
Message 2 of 9
(3,354 Views)
If they're really true-blue Excel files (as opposed to tab-delimited text files), then you can use ActiveX to call the "PrintOut" method for the sheet. You can search the Example Finder (Help -> Find Examples) for examples on how to control Excel from LabVIEW via ActiveX. There's also the Excel "board".
Message 3 of 9
(3,348 Views)
i tried this, but it didnt work

Best regards,
Krispiekream
0 Kudos
Message 4 of 9
(3,311 Views)
i think i got it..
thanks for the help in finding the examples..

Best regards,
Krispiekream
0 Kudos
Message 5 of 9
(3,307 Views)
i got it to print all files...

but i am wondering if we can use a function like...."fit to 1 page" as we can do it with windows...
does labview allow us to automatically shrink the contents to 1 page?

thanks
Best regards,
Krispiekream
0 Kudos
Message 6 of 9
(3,303 Views)

Can you post the VI saved for LV 8.x?

Since it is in LV 5.x, I m unable to open it n LV 8.5. Smiley Sad

- Partha ( CLD until Oct 2027 🙂 )
0 Kudos
Message 7 of 9
(3,291 Views)

but i am wondering if we can use a function like...."fit to 1 page" as we can do it with windows...
does labview allow us to automatically shrink the contents to 1 page

That would not be under the control of LabVIEW. It's the ActiveX interface that's printing, not LabVIEW. So, you would need to see if the ActiveX interface has such a method or property. I would suggest checking MSDN.
0 Kudos
Message 8 of 9
(3,272 Views)
parthabe,
are you talking about this file?
Attachment PrintXL2000.ZIP

Best regards,
Krispiekream
0 Kudos
Message 9 of 9
(3,262 Views)