Hi
I want convert df -h output to exel
how we can doing this?
#df -h

/dev/mapper/vg01-lvroot
200G 608M 18G 4% /
/dev/mapper/vg01-lvtmp
250G 1.7G 22G 8% /tmp
/dev/mapper/vg01-lvopt
200G 1.1G 18G 6% /opt
/dev/mapper/vg01-lvhome
200G 173M 19G 1% /home
/dev/mapper/vg01-lvvar
200G 400M 18G 3% /var
/dev/mapper/vg01-lvusr
200G 5.1G 14G 28% /usr
/dev/mapper/vg01-lvoracle
30G 1.6G 27G 6% /oracle
/dev/mapper/vg01-lv_rocra_home
30G 14G 15G 49% /rocra_home
/dev/cciss/c0d0p1 99M 21M 74M 22% /boot
tmpfs 32G 0 32G 0% /dev/shm
ff03:/dd
19T 3.1T 8.0T 28% /dd
ff03:/pp
19T 5.3T 5.7T 49% /pp

I assume you are speaking about excel, and not only that but csv format. You need to use sed or tr to replace space chars to commas.

YES
I speaking about .xlsx

how we must using from sed or tr ?
please help me.

Excel can import text files using many different separators other then a comma.
What happens if you save the output to a file and open it up in Excel?

really i want similar below for all lines of df -h output.

/dev/mapper/vg01-lvroot ----> /dev/mapper/vg01-lvroot 200G 608M 18G 4% /
200G 608M 18G 4% / ---->

if you can help me with any way or with any command?

please see this picture

Use
df -Ph

self of way with command df -Ph sloved.

but i want a part on a cell

foe example
/dev/mapper/vg01-lvroot -> a cell
200G -> a cell
608M -> a cell
18G -> a cell
4% -> a cell

you need to open text file and specify delimiter in excel or replace spaces to comma (using tr)

Try using the import wizard and select space as the separator. Its been awhile since I've needed to import a similar file.

That depends on the version of excel, I have just tried MS Excel 2010 and there was no import but open ...

Tank-you
every thing correct
goodbye.

the op is off premise. unless you are a m$ employee and have legal access to their source code would one be able to transpose ascii text into proprietary binary xlsx format (you would have better luck with open/libre-office (xml) odf format but would probably be overkill).

as suggested use linux programs (like sed, awk, tr, cut, paste, ...)to format into something like *.csv.

with ms-excel 2010 there is a quirk (bug ?) where if you name a txt file with a xls suffix (not xlsx) it will open the file without the text import wizard. if you close the worksheet (but dont close excel) and then open the file ribbon and select recent and select the latest file, it will reopen with the text import wizard).

It looks like you did a cut and paste from a terminal window into the spreadsheet (that would explain the odd line wrap).

you might try "df -h >file", then import the file.

Normally, df only outputs one line per filesystem - thus long filesystem names (or mounted on names, or both) could cause the output to be wrapped.

Otherwise, you will be stuck with using awk to combine lines, break up the lines into fields, and output with commas.