| Author |
Filling an Excel sheet
|
|
| apogeusistemas@gmail.com 2006-09-19, 1:35 am |
| Hi all:
Every day in my job I need verify all Solaris FS and fill a Excel sheet
with FS values.
Do you know any tool to make this task automatically ?
Regards.
| |
| Hubble 2006-09-19, 7:28 am |
|
apogeusistemas@gmail.com wrote:
> Hi all:
>
> Every day in my job I need verify all Solaris FS and fill a Excel sheet
>
> with FS values.
> Do you know any tool to make this task automatically ?
>
> Regards.
If I understand correctly, you want to write excel data from unix. The
usual method is to
1. write a (shell) script which creates a csv file (comma separated
values)
2. read the csv to excel
Another way is to use perl. The module Spreadsheet::WriteExcel can
create *.xls files.
Hubble.
| |
| Steven Mocking 2006-09-19, 7:25 pm |
| Hubble wrote:
> If I understand correctly, you want to write excel data from unix. The
> usual method is to
> 1. write a (shell) script which creates a csv file (comma separated
> values)
> 2. read the csv to excel
3. Educate the luser who insists on the excel sheet to do step 2.
4. Apply rubber hose if unsuccesful.
5. See 4.
Seriously, it's a bleeding spreadsheet - you'd be better off scribbling
your data on random walls.
| |
| Hubble 2006-09-20, 1:32 am |
|
Steven Mocking wrote:
> Hubble wrote:
>
> 3. Educate the luser who insists on the excel sheet to do step 2.
> 4. Apply rubber hose if unsuccesful.
> 5. See 4.
>
> Seriously, it's a bleeding spreadsheet - you'd be better off scribbling
> your data on random walls.
Agreed. Do not use excel for serious data.
Hubble.
| |
| apogeusistemas@gmail.com 2006-09-20, 1:29 pm |
|
Hubble wrote:
> Steven Mocking wrote:
>
> Agreed. Do not use excel for serious data.
>
> Hubble.
I'd be happy if I could choice.
It's a job imposition (mandatory from my employer).
| |
|
| apogeusistemas@gmail.com wrote:
> Hi all:
>
> Every day in my job I need verify all Solaris FS and fill a Excel sheet
>
> with FS values.
> Do you know any tool to make this task automatically ?
>
> Regards.
>
can you use Oo and export to an Excel spreadsheet?
If not, and it was me, I'd probably turn the data into csv and then use
a macro in Excel to mangle the data.
I'm assuming the PHB wants a nice pretty graph? 
Ray
| |
|
|
| Hubble 2006-09-22, 7:27 am |
|
apogeusistemas@gmail.com schrieb:
> Hubble wrote:
[vbcol=seagreen]
> I'd be happy if I could choice.
> It's a job imposition (mandatory from my employer).
This is not meant against your efforts to automate the process.
They are honorable.
Hubble.
| |
| Dan Mercer 2006-09-23, 1:45 am |
|
"Hubble" <reiner@huober.de> wrote in message news:1158652975.005565.105700@i42g2000cwa.googlegroups.com...
:
: apogeusistemas@gmail.com wrote:
: > Hi all:
: >
: > Every day in my job I need verify all Solaris FS and fill a Excel sheet
: >
: > with FS values.
: > Do you know any tool to make this task automatically ?
: >
: > Regards.
:
: If I understand correctly, you want to write excel data from unix. The
: usual method is to
: 1. write a (shell) script which creates a csv file (comma separated
: values)
: 2. read the csv to excel
:
: Another way is to use perl. The module Spreadsheet::WriteExcel can
: create *.xls files.
:
: Hubble.
:
A third method is to write an HTML file (create a spreadsheet in eXcel,
save as HTML, then look at the resulting file for an idea of what
you'll need). I actually did that for a project a few years back.
Put up a shell based Web server using inetd. With the right Javascript
the users could click on a web link and up would pop eXcel with
the disk file usage and pretty charts.
Dan Mercer
|
|
|
|