|
|
在linux中，把csv文件转换成excel表格（xlsx或者xls）
+ F: A+ q% U R# U8 ?2 l
$ i7 a9 e8 g) ]; T echo -e 'surname,name,age\nCarlo,Smith,23\nJohn,Doe,46\nJane,Doe,69\nSarah,Meyer,23\n' > example.csv5 E& K0 F1 {* f; ]. q0 J
7 ?- J t7 D, J" q yum provides unix2dos 2 e' C% Q+ ~. P. I% v5 l0 ?8 j2 i
Loaded plugins: fastestmirror, langpacks; D# K+ j/ u- c; E% m* P! W
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
5 x O) f( `/ u* b* V9 JLoading mirror speeds from cached hostfile
6 \# L8 N' z# m) C0 P) Edos2unix-6.0.3-7.el7.x86_64 : Text file format converters' k' G# y" Y& \5 _: m# W j1 V1 s1 B- v
Repo : local
; e, f `( {5 YMatched from:! p' W# H2 z4 f
Provides : unix2dos = 6.0.3-7.el72 A1 P. ^% Q6 z" e* N3 @
9 `% }+ U& ~1 {" E8 x2 C
yum install -y unix2dos" O" Q3 C% a. ]/ ^' G0 o4 h
Loaded plugins: fastestmirror, langpacks: z1 S2 v. ]4 r" S
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast, i/ C) r; t+ j1 ?8 G
base | 3.6 kB 00:00:00
: S; i3 W# K+ X$ K& G/ bCould not get metalink https://mirrors.fedoraproject.or ... =epel-7&arch=x86_64 error was0 Y. M( }) g* O$ ?0 D2 T& `0 v; k
14: curl#35 - "Peer reports incompatible or unsupported protocol version."
6 a/ u$ y9 v0 r4 W$ Hextras | 2.9 kB 00:00:00 1 j. ?& r- ^6 J4 X7 g0 I7 k
updates | 2.9 kB 00:00:00 & a# s% ], b* m: X& |& @0 J
updates/7/x86_64/primary_db | 20 MB 00:00:01 ) C7 L0 q* o! ]+ i# D8 V
Determining fastest mirrors
" P2 k1 {! T4 ~- y$ N * base: mirrors.bupt.edu.cn% `/ ^" d6 u; n% Q7 U
* epel: mirrors.tuna.tsinghua.edu.cn
+ e1 U h: n g9 G+ N# c! s% M * extras: mirrors.bupt.edu.cn. [: q8 }$ R. c* G
* updates: mirrors.bupt.edu.cn5 N# R( P- v i: |/ u
Resolving Dependencies% @5 G% ?+ l# Y+ S% d7 I4 }
--> Running transaction check) B2 S' Z6 o2 M1 K! x
---> Package dos2unix.x86_64 0:6.0.3-7.el7 will be installed, [$ P4 z- {+ M, O$ o9 C- V8 A
--> Finished Dependency Resolution
4 s; `; }4 J" u6 G
$ r) G- N% ^+ X* }+ _/ O. e- G, x/ ~$ ?Dependencies Resolved. j4 _" Z2 F- {' k g; V6 @
' z6 u# a9 |* ] w==============================================================================================================================================================================================, {1 s5 X# e) f2 F1 _4 u+ K
Package Arch Version Repository Size6 v, n3 I9 j5 \) I A- M
==============================================================================================================================================================================================
, g8 P( q) n9 T# M4 wInstalling:1 ^) ~2 u$ _, E+ S7 K
dos2unix x86_64 6.0.3-7.el7 base 74 k& `5 D% s$ C! [- `" Y3 i
+ E: I% j u5 A$ Y$ c3 W
Transaction Summary2 D7 L3 \5 p3 T6 v
==============================================================================================================================================================================================) F! o1 E0 n" N2 f) k
Install 1 Package
8 ~ P$ V8 i4 [$ C- q. o8 e% ~ M7 O
4 a4 B) E1 }2 y% T0 q1 STotal download size: 74 k: B/ N _% }' H D3 o5 G
Installed size: 190 k
% K# w; a- M" @$ k7 W+ l, h" kDownloading packages:4 n0 o% l8 r$ j- f9 Y
dos2unix-6.0.3-7.el7.x86_64.rpm | 74 kB 00:00:00 2 Y$ w1 e9 j: q* p" p6 ]( q
Running transaction check
; v$ A6 y9 K9 b9 Y. @3 m8 z+ oRunning transaction test' O" k9 M+ y7 c. v) r5 h
Transaction test succeeded" F. t7 f8 ]* G- \/ R$ F
Running transaction
7 l7 N1 h* V+ ~2 M( ` D Installing : dos2unix-6.0.3-7.el7.x86_64 1/1
; C4 a2 t1 A8 O4 h2 F- O Verifying : dos2unix-6.0.3-7.el7.x86_64 1/1 2 X! n" {: d& Z! N
6 D% d- X2 v, \. N4 @9 P+ w- Y
Installed:0 k% }- n3 k+ q! M& m
dos2unix.x86_64 0:6.0.3-7.el7 2 i5 R' B! d1 {; W" U3 N( r
) X; ]1 R _) s: f* L8 T s: I9 sComplete!
# G2 j. h0 W9 a; Z3 d p0 A% R3 b7 a, I3 X
6 [2 a5 J9 l9 Y- z$ ], }. |* K
1 g9 }+ c2 s* U" n* M. ?
unix2dos example.csv; R' n! O1 S) m: Y( S0 f& a
unix2dos 2023-03-10xunjian.csv% W) a# v, t1 f4 W' U4 l h7 S$ l) v
unix2dos: Binary symbol found at line 1
( g4 Z* ^! D' ^! {0 \) ^4 N7 xunix2dos: Skipping binary file 2023-03-10xunjian.csv
6 h" i+ [) J% G! ]$ u5 E- l
% h h1 \0 m5 G2 K
4 N9 D6 T' |( r8 Z8 }0 @; U2 \6 W i! B0 |2 `4 j( O
1 h6 y; x8 {5 M8 D9 [4 L
ssconvert example.csv example.xlsx
3 i( O( F, {: P2 W8 W
4 l6 [$ G: _4 z. F9 S$ O; ]9 ^
) v: P% h" E! [) }0 D( { ssconvert example.csv example.xls( x Z* B9 y5 ], z8 ~+ j
! F3 N+ F1 l8 G0 \9 _; n! R4 r0 C0 D* ?9 o, [
|
|
发表于 2023-3-10 15:38:22