topic Re: Proper formatting in excel..on HP server.. in Operating System - HP-UX

Proper formatting in excel..on HP server..

boomer_2 — Tue, 13 Nov 2007 02:42:05 GMT

hi guys,
I need to convert a report format which gets generated on my hp server into xls format with all the columns to be viewed as v view them using vim editor and set nowrap option......

like the following :->

A B C D E F
1 2 3 4 5 6
1 2 3 4 5 6

i WANT THIS EVERYTHING IN A column/FORMAT DIRECTLY ON MY HP SERVER..is it possible...???

Server details :->
rx4640
hp ux 11i v2
8 gb RAM
foundation OE

Re: Proper formatting in excel..on HP server..

Steven E. Protter — Tue, 13 Nov 2007 03:14:43 GMT

Shalom,

Best thing to do is put the data in comma delimited format and let excel import the data.

excel is a proprietary format. I know Microsoft recently agreed to release an API but Its beyond normal systems administration to deal with that.

SEP

Re: Proper formatting in excel..on HP server..

V. Nyga — Wed, 14 Nov 2007 12:39:26 GMT

Hi,

this is the .csv format!
You can read this in Excel and also store it from Excel in .csv format to work with vim editor.

You can use comma or semicolon for example.

HTH
Volkmar

Re: Proper formatting in excel..on HP server..

A. Clay Stephenson — Wed, 14 Nov 2007 12:55:22 GMT

Yes, it is possible to do everything to create an Excel file including Column Headings, colors, ... using HP-UX if you use Perl's Spreadsheet::WriteExcel module.

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm

... and no, I am not going to do a step-by-step for you. It's the journey that's important not the destination.

Re: Proper formatting in excel..on HP server..

boomer_2 — Mon, 10 Dec 2007 11:25:24 GMT

Thanx clay for guiding me towards my destination....

Re: Proper formatting in excel..on HP server..

S.Rider — Mon, 10 Dec 2007 17:23:04 GMT

Let me echo what A.Clay said.
Use WriteExcel - great tool - I've been using it for a couple years - Creating xls files directly under HPUX with all the formatting that csv lacks and emailing them as attachments - it does takes some research/experimenting to get all the formatting right, but the ability to send xls files directly from Unix and not require someone to reformat a csv file is worth it.