Commit: 0746f8606531d826d2f292018cdb460922f2948c - myprojects-hg-reborn (hg)

Commit MetaInfo

• Revision: 0746f8606531d826d2f292018cdb460922f2948c (tree)
• Zeit: 2022-03-31 20:27:07
• Autor: Lorenzo Isella <lorenzo.isella@gmai...>
• Commiter: Lorenzo Isella

Log Message

A script to batch convert excel files to csv.

Ändern Zusammenfassung

• add: Bash-scripts/convert_xlsx_to_csv.bash

Diff

diff -r 85ca4f584d47 -r 0746f8606531 Bash-scripts/convert_xlsx_to_csv.bash
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Bash-scripts/convert_xlsx_to_csv.bash	Thu Mar 31 13:27:07 2022 +0200
@@ -0,0 +1,46 @@
+#!/bin/bash
+
+# #convert pdf to png
+
+# FILES="*.pdf"
+
+# for F in $FILES
+
+# do
+# newname=`basename "$F".pdf`
+# echo $newname
+# pdftoppm "$F" -rx 300 -ry 300 "$newname.png"
+
+# done
+
+
+
+FILES="*.xlsx"
+
+for F in $FILES
+
+do
+# See https://stackoverflow.com/questions/2664740/extract-file-basename-without-path-and-extension-in-bash/26753382#26753382
+    
+fbname=$(basename "$F" | cut -d. -f1)
+   
+newname=`basename "$F"`
+echo $newname
+echo $fbname
+
+# pdftoppm "$F" -rx 300 -ry 300 "$newname.png"
+xlsx2csv "$F"   "$fbname.csv"
+done
+
+
+
+# FILES="*.xlsb"
+
+# for F in $FILES
+
+# do
+# newname=`basename "$F"`
+# echo $newname
+# # pdftoppm "$F" -rx 300 -ry 300 "$newname.png"
+# soffice --convert-to csv --outdir text_conversion/ $newname 
+# done