Jump to content

print table landscape


silvano
 Share

Recommended Posts

up please :)

Hey why don't you print from the cmd prompt??

PRINT [/D:device] [[drive:][path]filename[...]]

/D:device Specifies a print device

you can easily automate this using the @comspec macro in autoit

[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com
Link to comment
Share on other sites

Hey why don't you print from the cmd prompt??

PRINT [/D:device] [[drive:][path]filename[...]]

/D:device Specifies a print device

you can easily automate this using the @comspec macro in autoit

If this doesn't work, try the _fileprint UDF in autoit. Search for it in help.
[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com
Link to comment
Share on other sites

thanks i have search in the forum and i have look _fileprint and _word udf... but my problems are:

1) set orientation (no problem with _word udf)

2) print table cells (problem for me...)

but if i use _word udf without office does not print nothing

Link to comment
Share on other sites

thanks i have search in the forum and i have look _fileprint and _word udf... but my problems are:

1) set orientation (no problem with _word udf)

2) print table cells (problem for me...)

but if i use _word udf without office does not print nothing

ok what format file r u trying to print?

.doc, .jpg,.xls

which 1

[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com
Link to comment
Share on other sites

the better one formed would not have that legacy to programs

it is possible to print a format as in the attached image without to use word or excel?

and if i use excel i don't know like printing the table cells

U cannot use excel and word UDFs without MSOffice installed.

u can print image files(just like the one in ur attachment) in cmd line.

the UDF for excel, doesn't include printing cells functions.

n if u want to insert a table in word and then print it, u can do it by _worddocprint, there u can set the orientation n everything else too.

but u'll need word installed for that.

There can be another method too though I haven't tried it.

U can print a csv file.

just enter the information u want to enter in the cells, into a notepad file seperated by a comma and save it as .csv. the info seperated by ","will automatically get transfered into cells. n u just print this from cmd prompt.

Simple n sweet.

[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com
Link to comment
Share on other sites

ok,

the csv is the best solution... but i don't know to print table cells

have you one little example?

See the post in which i have mentioned the usage of the print cmd in command prompt.

Example (syntax in autoit)

Run(@comspec & " /c print /d " & $printerName &" "& $file); $prinername is the device name of ur printer and $file is the path of ur csv or any other file u req to print.

Simple n Sweet.

Edited by Manjish
[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com
Link to comment
Share on other sites

_FilePrint() or _PrintFile() not work fine for me...

i have created a csv file like test.csv with:

1,2,3

one,two,three

but the print func return a blank page

Hey i am not sure about autoit's func fileprint(), coz i haven't used it. but u can definately use cmd prompt. just like the example i typed above.

[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com
Link to comment
Share on other sites

Oh gr8..

Thanks for the info man. n sorry my solution didn't work for u. But that's the beauty of brainstorming. U can't get to the right solution unless u go thru a million of wrong solutions.

cheers, n ya if possible please send me the exact script, it cud be a handy 1.

u can post it here, n ppl wud greatly benefit by it!!

[font="Garamond"]Manjish Naik[/font]Engineer, Global Services - QPSHoneywell Automation India LimitedE-mail - Manjish.Naik@honeywell.com
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...