How to convert .xls file which has html tags in it to delimited .csv from command line
We have a requirement to download the export from jira portal and insert this information to a table for some reporting. now the challenge is , the file downloaded from jira is in .xlx extension and has all the html links in it. when i use the xls2csv (catdoc software )and other converter tools over the command line they cant recognize the file format and not able to convert. I need this file to be converted as .csv file with some delimiter that way i can use sql loader to load it to a table.
If you have libreoffice installed on your system, running the following code on a bash terminal (as a normal user, not root - see the reason here) might help you:
libreoffice --invisible --convert-to csv my_file.xls
If you need this code to be run on a script that runs as root, it would still be possible to (safely) run this command if you run it as a "normal" user instead of root, such as:
su - myuser -c 'libreoffice --invisible --convert-to csv my_file.xls'
To find out who is the user who should be used to run the command above, one of the best options would be to use the logname command, such as:
myuser="$(logname 2>/dev/null)"
- Do CLOCK_MONOTONIC and CLOCK_MONOTONIC_COARSE have the same base?
- How to convert \uXXXX unicode to UTF-8 using console tools in *nix
- How to match CR or end of line with grep?
- What is the difference between installing a package using pip vs. apt-get?
- Laravel + SQLite = SQLSTATE[HY000]General Error: 8 attempt to write a readonly database
- How to access files owned by a user in an application
- How do I open a .py file in IDLE for editing without starting a fresh interpreter session?
- compile gcc for armv7l from debian in linux
- How to make C++ be as economical with memory as C, while still using STL?
- Java Threads, Blocking I/O, and Scheduling
- I am creating a bash script to organize files in my Downloads folder, how can I iterate using "For" loop
- "configure: error: libnl and libnl-genl are required but were not found"
- Cannot fix Internal server error after upgrading PHP and then downgrading it again
- How to use Puppeteer in 2nd gen Cloud Functions?
- Persistent volume and claims in kubernetes workspace
- sed command with -i option failing on Mac, but works on Linux
- PyCharm Linux (flatpack) exception with os.stat on system files
- How to cut first n and last n columns?
- Dealing with struck-through and non-struck-through characters using Python on Linux and/or MacOS
- How to avoid using printf in a signal handler?
- TWS API Linux - Segmentation fault - __bid64_to_string
- insmod: ERROR: could not insert module HelloWorld.ko: Operation not permitted
- Delete lines in file if they contain current working directory
- Kernel bypass for UDP and TCP on Linux- what does it involve?
- Linux Kernel generate compile-commands.json for module
- How can I detect if multiple keyboard keys are being pressed at the same time in C++, in Linux, from the terminal?
- What's wrong with lsusb | awk '{print $6}' | xargs --null lsusb -s
- Qt 6.8 linux (gcc) webengine is missed
- How to reverse the output of the grep command?
- Can yum tell me which of my repositories provide a particular package?