- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: excel formatting
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2006 05:03 AM
12-16-2006 05:03 AM
excel formatting
Thanks in advance for any assistance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2006 07:26 AM
12-16-2006 07:26 AM
Re: excel formatting
If csv files are named .csv then the default open under Windoze activates excel without needing to do the text-to-column.
I don't think there is a Perl OLE.pm module available for OpenVMS, that woudl be too easy :-)
XL97 and up can read a HTML table saved with an .xls extension.
This allows you to add some basic formatting which will be preserved
when the file is opened in XL. Just write out a text file with the table
from
link to it)
I just tried it, going into excel first, and saving a trivial worksheet as html. Then rename to xls, Use notepad to change some entries to prove you can play with with, re-display with excel.
Use the excel saved table text as template for an alternative to .csv.
An interesting benefit could be that you can use a browser on OpenVMS to pre-view the information.
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2006 04:36 AM
12-17-2006 04:36 AM
Re: excel formatting
The first one is obsolete and replace by the second one.
From http://sourceforge.net/projects/pyexcelerator
"""
Generating Excel 97+ files with Python 2.4+ (need decorators), importing Excel 95+ files, support for UNICODE in Excel files, using variety of formatting features and printing options, Excel files and OLE2 compound files dumper. No need in Windows/COM
"""
JF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2006 05:42 PM
12-17-2006 05:42 PM
Re: excel formatting
Leave the data as csv, but provide a macro to do the formatting.
see http://support.microsoft.com/kb/272729
You could construct an XML file instead of csv and then use excel to open as a read-only workbook.
see http://office.microsoft.com/en-us/excel/HA011019641033.aspx
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2006 07:57 PM
12-17-2006 07:57 PM
Re: excel formatting
PHP is capable of creating Excel, Word, PDF, etc files :-
http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.intro.php
PHP comes free with VMS, and the advantage is it's very easy to learn and create new scripts.
Rob.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2006 04:26 AM
12-18-2006 04:26 AM
Re: excel formatting
You can simply just use MIME on the VMS side and then email the file to the users just as you're doing now. Is that not good enough?
$ mime :== $SYS$SYSTEM:MIME.EXE
$ mime
MIME> new filetosend.csv
*exit
MIME> add yourcsv.csv
MIME> save
MIME> exit
$ mail/subj="blah" filetosend.csv "me@me.com"
The Outlook recipient should be able to double-click on the attachment and get a nicely formatted CSV file in EXCEL.
Hope that helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2006 04:42 AM
12-18-2006 04:42 AM
Re: excel formatting
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.17/
I can't remember if I've ever used it on OpenVMS, but it's pure Perl (no C compiler necessary) so it should be easy enough to install if you have Perl.
I have used the Perl module RTF::Writer on VMS to create tabular reports in rich text format, and as others have indicated, there are a number of ways to create and send files in PC-friendly formats.
What the OP chooses to use as a solution depends in part on where the data are coming from and what tools he is comfortable using. I.e., do you need to pull data out of a database or RMS indexed file? What methods do you currently use to do that? Which of the many methods for sending e-mail attachments are you using or comfortable with?
As an example, if I had data in an RMS indexed file that needed to be sent as an Excel attachment, I would use Perl and the modules VMS::IndexedFile to retrieve the data, Spreadsheet::WriteExcel to generate the reports, and MIME::Lite to send the files as e-mail attachments.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2006 06:09 AM
12-18-2006 06:09 AM
Re: excel formatting
We generate tab delimited files from a browser based database. The user downloads these and Excel seems to handle the format with less user prompting.
Andy