|
|
在linux中，把csv文件转换成excel表格（xlsx或者xls）
$ t/ D! Z* [. S2 l) t; `+ { J2 f
echo -e 'surname,name,age\nCarlo,Smith,23\nJohn,Doe,46\nJane,Doe,69\nSarah,Meyer,23\n' > example.csv
- ^, `2 d/ t% m8 a" P1 j8 ^
# W3 ^/ ^+ k/ |$ u yum provides unix2dos ' Y" A! H% v# ~+ H5 R: k/ |8 t0 D9 P
Loaded plugins: fastestmirror, langpacks
; M6 u' X6 Q" X2 k4 i1 fRepodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast, M1 X% ?& D1 q
Loading mirror speeds from cached hostfile
0 Q1 S! C2 J- x3 N( o, V$ Idos2unix-6.0.3-7.el7.x86_64 : Text file format converters
, l3 E8 D: m- {4 d2 U0 o: DRepo : local
/ x2 Z, P2 ]1 b6 vMatched from:7 r) j; S9 k( Y B# h/ _( b1 o
Provides : unix2dos = 6.0.3-7.el7& {4 t% Z; |8 o
7 N3 H3 h7 @6 g7 ?9 t0 d
yum install -y unix2dos
' c* b* Y9 R3 O, D: Q& ILoaded plugins: fastestmirror, langpacks+ N+ C. q# T+ F
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
/ L$ `- z$ ^8 S9 T. n% Qbase | 3.6 kB 00:00:00
- C9 g# f; x8 S" YCould not get metalink https://mirrors.fedoraproject.or ... =epel-7&arch=x86_64 error was
7 V2 {, U, M( ]14: curl#35 - "Peer reports incompatible or unsupported protocol version."# M( `9 u# f6 M* k! d0 X- O4 B8 N
extras | 2.9 kB 00:00:00
8 h8 ^/ F4 |5 b; j6 kupdates | 2.9 kB 00:00:00 , r0 N; I7 }2 n: a8 B' l7 j2 F
updates/7/x86_64/primary_db | 20 MB 00:00:01
) I& Y& e* A: ?# e( G4 SDetermining fastest mirrors
5 `5 n9 W$ a2 R. B9 T) `9 z7 S5 V" b * base: mirrors.bupt.edu.cn% i( }4 _- m8 W2 X' P3 _9 u& c, K
* epel: mirrors.tuna.tsinghua.edu.cn
6 j4 |: r! A. M+ Z' M * extras: mirrors.bupt.edu.cn4 }8 e* [3 Y p. n/ O: g( K' Q* O
* updates: mirrors.bupt.edu.cn
7 A5 t- X6 l! ]. V5 E" {8 y& zResolving Dependencies" V$ b* l% C: A7 F" q4 Z2 V
--> Running transaction check1 |8 n6 n, T6 J4 B
---> Package dos2unix.x86_64 0:6.0.3-7.el7 will be installed& z4 W! A. z6 F: ? f) C( G0 r8 L
--> Finished Dependency Resolution. _# n$ ?1 ^/ i7 L
% V) ` k5 a; n
Dependencies Resolved- \0 A9 s3 T, F
9 e8 m- w% t: M3 r+ D
==============================================================================================================================================================================================
. |9 o7 I5 J. L( c# { Package Arch Version Repository Size' T* K* E+ p3 ]
==============================================================================================================================================================================================# s- a: u8 q2 |2 ^
Installing:
& |; O; L0 m; f dos2unix x86_64 6.0.3-7.el7 base 74 k
5 k. c# k- f# j/ p' q7 y# o& ~4 E0 I6 M7 N
Transaction Summary) p, q9 }% Q4 y& q- P
==============================================================================================================================================================================================. ^9 W* w) w% p: C8 C* B
Install 1 Package
# Z5 f# x# ]. ^# R" ?
( a+ F2 `+ A, d& E: V* sTotal download size: 74 k8 O% ?3 K0 I+ I1 w/ _) R& u
Installed size: 190 k# ]# L9 T# V, s7 W0 j
Downloading packages:
' D% e W$ D- W; F1 P" j6 `dos2unix-6.0.3-7.el7.x86_64.rpm | 74 kB 00:00:00
0 E+ u, a" I9 X+ i: p% q0 {Running transaction check
" A1 n+ ^8 E/ ^' gRunning transaction test$ a- U& a% `. i2 K5 Z1 j) h- g$ H. |
Transaction test succeeded" g# ?8 u* S R2 C& \
Running transaction
4 x3 e- Q/ e0 {$ f+ P% W Installing : dos2unix-6.0.3-7.el7.x86_64 1/1
0 \, t* t& V4 t! Y2 B& w Verifying : dos2unix-6.0.3-7.el7.x86_64 1/1
5 {* _3 \$ p. g- V1 q6 B, p' W, K, ^0 L* y
Installed:
0 T( p7 Y- \! |9 q3 T' y0 ]6 r dos2unix.x86_64 0:6.0.3-7.el7
! M7 Y+ R2 n- f( |3 `0 l8 i4 Y3 Q: s2 b% v3 \/ j* m& D
Complete!
% z2 j2 g+ X9 L- f/ m. { v- k
3 ~4 n* x( R" L4 {2 F# f E- x
4 I8 A2 W A G# p* ~, D" T
9 Q5 C: V) R, ~( u0 X6 T$ ?/ r unix2dos example.csv
/ E' t! r" G! Q unix2dos 2023-03-10xunjian.csv
$ g: a# `5 @# @: w; P! kunix2dos: Binary symbol found at line 1% M; ?- h3 u7 e0 ?/ S
unix2dos: Skipping binary file 2023-03-10xunjian.csv# q) b9 Y: y }7 Y) x
7 V6 c$ I0 j3 o$ P6 a
. B9 Q7 E" u8 ~/ ]3 J
N" E: p; m+ G
q6 V+ E- r6 a5 Ussconvert example.csv example.xlsx
% v: {( x2 Y" @; Q* E) b- b( J( e
A. |3 A0 g; B. C/ F' S' @, V0 H+ B' X P2 ?
ssconvert example.csv example.xls& O: @# B2 \, m* o( j* \+ x( D
! B3 Q" V2 ]- q) z& o
6 U: V$ B8 y8 v6 C |
|
发表于 2023-3-10 15:38:22