Save Translate To Excel - Specific Column Width

[SUBSCRIBE SPSSX-JohnF]

Any help\input would be appreciated.....

When saving an SPSS data file out as an Excel spreadsheet is it possible to specify the column widths?  I did my homework and it appears that there certainly isn't a canned approach to doing it.

Thanks,
JF

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso]

Doesn't the FORMATS command achieve this?
--

SUBSCRIBE SPSSX-JohnF wrote

> Any help\input would be appreciated.....
>
> When saving an SPSS data file out as an Excel spreadsheet is it possible
> to specify the column widths?  I did my homework and it appears that there
> certainly isn't a canned approach to doing it.
>
> Thanks,
> JF
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon Peck]

I don't think either FORMATS or VARIABLE WIDTH affects the width of the Excel export.  The only way I know of would be to write a SaxBasic script that used Exec VBA automation to set the widths, possibly based on the format or DE column width.

On Wed, Sep 27, 2017 at 4:28 PM, David Marso <[hidden email]> wrote:

Doesn't the FORMATS command achieve this?
--

SUBSCRIBE SPSSX-JohnF wrote
> Any help\input would be appreciated.....
>
> When saving an SPSS data file out as an Excel spreadsheet is it possible
> to specify the column widths?  I did my homework and it appears that there
> certainly isn't a canned approach to doing it.
>
> Thanks,
> JF
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

--

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[SUBSCRIBE SPSSX-JohnF]

Thank you for the input(s).....that is what I figured, i.e., using something via VBA within Excel.  Guess you really can't have your cake and eat it too.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon Peck]

You can import the VBA module in a SaxBasic script and do the adjustment as part of your SPSS job.

On Thu, Sep 28, 2017 at 8:02 AM SUBSCRIBE SPSSX-JohnF <[hidden email]> wrote:

Thank you for the input(s).....that is what I figured, i.e., using something via VBA within Excel.  Guess you really can't have your cake and eat it too.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

--

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[SUBSCRIBE SPSSX-JohnF]

Can it be embedded in the python code I have?

Thanks....

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon Peck]

You could try a Python library such as openpyex, although I have not used this one.  It seems to support most of the relevant Excel features.  By doing this from the SPSS side, you can use variable metainformation to choose the widths as well as having this embedded in your workflow rather than as a separate step.

On Thu, Sep 28, 2017 at 12:26 PM, SUBSCRIBE SPSSX-JohnF <[hidden email]> wrote:

Can it be embedded in the python code I have?

Thanks....

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

--

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[SUBSCRIBE SPSSX-JohnF]

Thank you for your interest and assistance.

JF

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD