Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [excel]

Relevant examples of questions include:

  • converting files to import data into/export data from other spreadsheets programs running on UNIX-based systems,
  • getting to run Microsoft® Excel® on a UNIX-based system (for example using Wine on a GNU/Linux system),
  • programmatically generating Microsoft® Excel® files with UNIX utilities,
  • etc.
21 questions
16
votes
2 answers

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" files for further calculation. For that, Some…
Prem Joshi
  • 437
  • 1
  • 3
  • 10
4
votes
1 answer

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 program or script to make the Excel file write protected…
Arya
  • 306
  • 1
  • 4
  • 13
2
votes
1 answer

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, is there an easy way to do that?
kutlus
  • 345
  • 2
  • 5
  • 18
2
votes
2 answers

Script to compare to excel files and print differences

Is there any script handy to compare 2 excel sheets and print only their differences?
Sandosh Kumar P
  • 347
  • 1
  • 5
  • 14
2
votes
1 answer

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 cells. If invoked without a file …
zotherstupidguy
  • 287
  • 1
  • 2
  • 9
1
vote
3 answers

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 Status Expires …
pavan
  • 13
  • 1
  • 3
1
vote
2 answers

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 through browser. The code responsible for conversion…
Bart
  • 2,151
  • 1
  • 10
  • 26
1
vote
1 answer

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<=NF; i+=2) gsub(",","|",$i)}1' FS=\" OFS= file how…
user3844609
  • 11
  • 2
1
vote
2 answers

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.236859 -2.6794 0.8820 1.9994 282 66.1557 7126254…
zara
  • 1,313
  • 3
  • 14
  • 24
1
vote
0 answers

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.xls, and replace it with Sheet2 from B.xls. It is…
ZakS
  • 285
  • 1
  • 4
  • 13
0
votes
0 answers

Binary Search Libreoffice Calc

Does anybody know of a way to organize a binary search in LibreOffice Calc? To take a simple example, say I have column A with the numbers 1-16 listed, sorted in ascending order: (1,2,3,...); and column B which lists names of widgets; and I want to…
Mychal Simonian
  • 1
0
votes
0 answers

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 Sublime Text. I couldn't see the data from both…
Sai Nikhil
  • 101
  • 3
0
votes
1 answer

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
malaki106
  • 3
  • 4
0
votes
1 answer

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 limitations if it is impossible?
henrywongkk
  • 119
  • 1
  • 5
0
votes
1 answer

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 IST(GMT+5:30) then I should get date for each as…
Amit Patel
  • 111
  • 3
1
2