Jump to content
Sign in to follow this  
silvano

print table landscape

Recommended Posts

silvano

hello,

who is the best solution to print in landascape a table of data DB like img attached?

give me a link or example please

thanks

by

post-18288-1232027551_thumb.jpg

Edited by silvano

Share this post


Link to post
Share on other sites
Manjish

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

Share this post


Link to post
Share on other sites
Manjish

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

Share this post


Link to post
Share on other sites
silvano

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

Share this post


Link to post
Share on other sites
Manjish

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

Share this post


Link to post
Share on other sites
silvano

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

Share this post


Link to post
Share on other sites
Manjish

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

Share this post


Link to post
Share on other sites
silvano

ok,

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

have you one little example?

Edited by silvano

Share this post


Link to post
Share on other sites
Manjish

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

Share this post


Link to post
Share on other sites
silvano

_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

Share this post


Link to post
Share on other sites
Manjish

_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

Share this post


Link to post
Share on other sites
silvano

the only way is to create the html file with table and cells and promt print preview

thank you

Share this post


Link to post
Share on other sites
Manjish

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

Share this post


Link to post
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
Sign in to follow this  

×