Ask Ubuntu
Ask Ubuntu

Questions tagged [xls]

XLX (and XLSX) are the file formats used by Microsoft Office's Excel spreadsheet program. These formats can also be opened by office programs on Ubuntu such as Openoffice or Libreoffice.

The XLS data is stored in the "Binary Interchange File Format" (BIFF) file format. Details of this format are given in Excel 97-2007 Binary File Format Specification.

The XLSX format is the Office Open XML (OOXML) format used by Excel 2007 and later.

The main advantage of the XLSX format over the XLS format is that it allows a larger number of rows and columns in a worksheet.

22 questions
14
votes
1 answer

Is there a way, ideally using the command line, to convert multiple .csv files to one multi-sheet .xls spreadsheet?

Is there a way, ideally using the command line, to convert multiple .csv files to one multi-sheet .xls spreadsheet? If there isn't a cli solution, it'd be good to know if there's an API that works in, ideally, AWK or Pascal, but, failing that, in…
Peter Brooks
  • 313
12
votes
2 answers

How can I print sheetnames of a spreadsheet using Linux command-line?

I am aware of using in2csv to save a particular worksheet as a .csv: in2csv --sheet "sheet name" file1.xls > sheet-name.csv But are there any other tools to just print the sheetnames? Perhaps there are options with Perl?
csheth
  • 431
10
votes
4 answers

Convert .xls/.xlsx spreadsheets to multiple .csv's based on a list

I need to convert all sheets of a single .xls/.xlsx file to a .csv. This will be done on all .xls files in all directories and sub-directories (recursively). Step 1: Get the sheetnames of all .xls into a .csv using: for file in $(find . -name…
csheth
  • 431
10
votes
2 answers

How do I save all images from .xls file?

I've got a xls file with exactly 167 images that I must save and post on a website. The sheer number itself is painful, but what complicates things is that you can't directly save images from Calc - you need to copy it to Writer first and then save.…
Oxwivi
  • 18,499
9
votes
3 answers

How to split an ODS spreadsheet file into csv files per sheet on the terminal?

I would like to split a spreadsheet (ods or xlsx) into multiple csv files, one for each sheet in the spreadsheet. I would like to do this without launching a graphical app and preferably in a one liner. Any ideas? Though the linked duplicate…
Bruni
  • 11,099
8
votes
1 answer

How to create Excel xlsx files from a script?

I'm looking for packages available in Ubuntu main/universe repositories able to create Excel 2007+ xlsx files from a script (python or perl) My requirements: 100% compatible Excel XLSX files. Solid and comprehensive documentation and a wide variety…
Sylvain Pineau
  • 63,229
8
votes
4 answers

From XML to CSV with command line

if I have a XML file on local disk, which command is need to convert file in CSV? And from XLSX or XLS to CVS? Thanks.
Noyzware
  • 81
4
votes
1 answer

Can't open .xlsx file with LibreOffice

.xlsx files are not opening in LibreOffice 3.4.3 in Ubuntu 11.10. Could not open "ABC.xlsx" Archive type not supported.
Deepak Rajput
  • 7,057
3
votes
3 answers

How do you convert many files from .xlsx to .xls?

What is a way to convert a batch of .xlsx files to .xls format? I would prefer it to be a command-line solution, but anything is better than opening each manually, and manually saving in the new format. ~~Edit~~ So is there a way to get around…
David Oneill
  • 12,614
2
votes
3 answers

Bash script to edit excel files

I have multiple excel files in this format. They are clock in and clock out date and time. --------------------------------- | Name | Time | --------------------------------- | Person A | 03-Jul-17 8:15 AM | | Person A |…
Parto
  • 15,647
2
votes
1 answer

LibreOffice 4.2.7.2: This document contains macros

I'm trying to open an .xls document in LibreOffice 4.2.7.2 and getting this error message. This document contains macros. Macros may contain viruses. Execution of macros is disabled due to the current macro security setting in Tools - Options -…
MYaseen208
  • 653
2
votes
2 answers

how to check spreadsheet for input errors

I was generating large XLS (Microsof Ofice Excel spreadsheet) file for a client with XML. The file has 72MB and when I try to open it in LibreOffice it crush on "General input/output error" yet when I check the XML with xmllint myfile.xls the XML…
equivalent8
  • 561
  • 2
  • 5
  • 12
2
votes
1 answer

How to convert Microsoft Office XML formated spreadsheet to .xls file

I have an Microsoft Office XML that starts with:
Sashko Lykhenko
  • 303
1
vote
1 answer

xls/xlsx extentions not associated properly (considered as archives)

For some reason, xls/xslx files are associated with file-roller app (for archives) and cannot be associated separately with WPS. As I understand, these extentions are same MIME types with different extentions. How to associate these with different…
Sebastian
  • 1,238
1
vote
1 answer

compare two xls file to remove duplicate rows

I have two xls files of 8MB and 10MB. I have to merge them and remove duplicate rows. (Both files have unique rows but after merging there will be duplicate rows). I have tried merging the files, but the two files won't merge because of large…
vidal
  • 111
1
2