Questions tagged [excel]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
1
vote
3answers
50 views

Convert shell results into Excel File in columns

I am running a shell script that gives the below result, and I want to store the result in Excel in different columns (HOST, Status, Expires, Days). How can I convert into Excel? Host ...
0
votes
0answers
130 views

Recover overwritten CSV files with multiple worksheets

I have a CSV file with one worksheet. After editing with Libre Office, I saved it and opened it with Libre Office again. I created a new sheet in the Libre Office. I saved it and opened it with ...
0
votes
1answer
468 views

How to find spreadsheet files that contain a word

Something like the answer here: https://superuser.com/questions/313187/search-text-in-multiple-excel-files but on linux mint.. xlsx files within a folder that contain the string
0
votes
1answer
1k views

Is it possible to run excel macros in linux?

Ideally this is a python-specific question but my findings so far are negative. So I would like to generalize it to seek a way to run Excel VBA macros in linux environment. What are the actual ...
1
vote
2answers
418 views

Convert Excel file to PDF using Perl CGI

I'm trying to convert an xlsx file to pdf using Perl CGI (Mason). Since I did not find a way to convert a file using pure perl, I'm using soffice to perform the job. This works fine until I do it ...
1
vote
1answer
773 views

convert an excel file to pipe delimiter file in Linux using script

Need to convert an excel file to pipe delimiter file in Linux using shell script. pls help I'm new to shell script. I saw a post to convert comma to pipe using the below code... awk '{for(i=1; i<...
4
votes
1answer
78 views

How can i add Write protected access to an excel in linux

I have a ETL job that creates the excel file and puts into one of the unix directory. I have an unix "mailx -s" command to send that excel as an attachemnt. I am looking for a way to extend my ...
1
vote
2answers
935 views

How to convert a space-separated file into an Excel file in Linux?

I have a file which looks like this: ID avedebv debv2019 ebv2018 gebv2018 number avecvlean 7063993 1.06109 0.5325 0.7420 1.5084 206 66.5962 7076247 1.67947 2.1066 2.8630 3.0629 460 67.6856 7076881 -0....
1
vote
0answers
37 views

Can I manipulate .xls workbooks in linux (tcsh)

I have 2 Excel Workbooks, A and B. Workbook A.xls has 2 worksheets, Sheet1 and Sheet2. Workbook B.xls also has Sheet1 and Sheet2. Without opening the workbooks, I would like to delete Sheet2 in A....
0
votes
1answer
4k views

view excel files in linux command line without installing any packages

I am connected to a server where I don't have sudo privileges to install packages such as Libreoffice. I only want to view an excel file might be .xlsx or .xls on linux terminal with a command line, ...
0
votes
1answer
133 views

Formula to convert UTC date time string to date/string in different timezone

I am getting date with time in UTC format. 2018-12-13T03:36:11+00:00 2018-12-10T19:26:48+00:00 I want to convert it to date in different timezone. So take above example and the target timezone is ...
0
votes
1answer
747 views

Transform xlsx to csv in AIX when there is no tool to do it [closed]

I need to transform xlsx to csv in AIX but there isn't any command installed to do so and it can´t be installed. To make it worse perl don´t have spreadsheet library and python isn't even installed. ...
0
votes
1answer
1k views

how to compare text file datas with excel sheet values

For Example : in my username.txt file ravi peri perl phython in my .xls file i have two columns named as user name and email username email ravi ravi@...
14
votes
2answers
9k views

Convert xlsx to xls in linux shell script

I need to convert ".xlsx" file to ".xls" using shell command. At my work we are currently using xlsx2csv command but now requirement has been changed and we need to convert all ".xlsx" files to ".xls"...
0
votes
1answer
829 views

Perl script to format .xls file in Linux [closed]

All I have is a linux command (I don't know what's behind the command, the script or what formats the command output), so what I can do is to pull the data [which is in table form with invisible ...
2
votes
2answers
2k views

Script to compare to excel files and print differences

Is there any script handy to compare 2 excel sheets and print only their differences?
1
vote
1answer
827 views

How to convert sc spreadsheet to Excel?

The spreadsheet calculator sc is based on rectangular tables much like a financial spreadsheet. When invoked it presents you with a table organized as rows and columns of ...
0
votes
1answer
38 views

Copying a text file into a calculation sheet with a script

I would like to create a script that can write up from a text file a LibreOfficeCalc or equivalent table with the same columns than the following those from the following lines from a text file : [1] ...