Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel]

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

1
vote
2answers
44 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
25 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
178 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
47 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
400 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
783 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
6k 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
593 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
547 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
30 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] ...