Proper formatting in excel..on HP server..

[boomer_2]

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

[Steven E. Protter]

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

[V. Nyga]

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

[A. Clay Stephenson · Accepted solution]

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.

[boomer_2]

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

[S.Rider]

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.