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.

learn more… | top users | synonyms

0
votes
0answers
35 views

Semicolon delimated CSV in WPS Spreadsheet

I am using WPS Spreadsheet to work on xls, xlsx files. WPS offers CSV conversion but only as "Comma delimited CSV". Can i use semicolon (;) as separator instead of comma(,). Some of my fields contain ...
0
votes
1answer
61 views

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 ...
9
votes
1answer
579 views

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,...
0
votes
1answer
765 views

Unable to open xls file in Openoffice calc

I am unable to open an xls file in Open Office 4.1.1. The same file is getting opened in Microsoft Excel. But in this, when I open the file, it is showing blank.
2
votes
1answer
405 views

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 ...
2
votes
2answers
163 views

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 ...
1
vote
1answer
372 views

Redirecting shell script output to a spreadsheet in sharepoint portal

I need to write a shell script that takes some statistics related to system and those values should be redirected to a spreadsheet in share point which then presented as a graph. Which is the best way ...
6
votes
1answer
15k views

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 ...
4
votes
1answer
7k views

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.
9
votes
2answers
4k views

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 - ...
3
votes
2answers
3k views

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 ...