Questions tagged [excel]
18
questions
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@...
1
vote
3answers
73 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
189 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
587 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
2k 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
456 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
808 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
82 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
1answer
844 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 ...
1
vote
2answers
1k 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
5k 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
850 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 ...
0
votes
1answer
145 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
772 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.
...
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"...
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?
0
votes
1answer
39 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] ...
