Stack Overflow
Stack Overflow

Questions tagged [ods]

ODS, OpenDocument Spreadsheet, is an extension of spreadsheet files in Open Document Format for Office Applications (ODF).

195 questions
20
votes
5 answers

Error: libXext.so.6: cannot open shared object file: No such file or directory

I am getting the error below when running a java file that tries to open an ods file. Exception in thread "main" java.lang.UnsatisfiedLinkError: /opt/software/jdk1.6.0_45/jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file:…
Green
  • 653
  • 3
  • 6
  • 13
20
votes
3 answers

How to import .ods?

I'm trying to import data (.ods file) and I know how to import .csv, .xls etc. but I strand all the time. I tried it with the package Gnumeric but R tells me that the required program 'ssconvert' cannot be found.
Thomas
  • 1,392
  • 3
  • 22
  • 38
12
votes
7 answers

spreadsheet to python dictionary conversion

I am working on python and I want to read an *.ods file and convert it to a python dictionary. The key will be the first column value and the value will be second column value. How can I do it? I used xlrd but it does not read *.ods files.
Lalit Chattar
  • 704
  • 4
  • 10
  • 24
11
votes
2 answers

Convert ODS to CSV using command line when Libreoffice instance is running

I'm working with an ODS file in LibreOffice, and every now and then I want to convert it to CSV from the command line. I have found two tools for this: libreoffice --headless --convert-to csv and unoconv -f csv but none of them works when there is…
foolo
  • 804
  • 12
  • 22
7
votes
2 answers

Python convert Excel File (xls or xlsx) to/from ODS

I've been scouring the net to find a Python library or tool that can converts an Excel file to/from ODS format, but haven't been able to come across anything. I need the ability to input and output data in either format. We don't need to worry…
Ashwin Balamohan
  • 3,303
  • 2
  • 25
  • 47
6
votes
3 answers

How to convert image to table

I have an image of a table (in my case .gif) and want to extract the table it was (ideally, .ods). Is there any way to do so? (doing it manually is discarted, since the table has more than 1000 rows and 6 columns) Here is a part of the image /…
Masclins
  • 230
  • 3
  • 19
5
votes
2 answers

Generate OpenOffice calc files using PHP

I have been trying to find a simple way to create OpenOffice calc files with no success. I have tried: openTBS - Seems to work writing an xml and a template file but can't find anything about how the xml file format. Ods php generator - I tried this…
Victor
  • 359
  • 1
  • 4
  • 15
4
votes
1 answer

Create ODS worksheets from CSV files

I have a set of CSV files, which I need to convert to a single ODS (or even excel) spreadsheet with multiple tabbed worksheets. Currently I'm using the pyexcel library for python, but it's buggy and horribly slow. Libreoffice has a nice file…
Rachie
  • 433
  • 1
  • 6
  • 17
4
votes
2 answers

How do you read a cell's value from an OpenOffice Calc .ods file?

I have been able to read an Excel cell value with xlrd using column and row numbers as inputs. Now I need to access the same cell values in some spreadsheets that were saved in .ods format. So for example, how would I read with Python the value…
user329257
  • 43
  • 1
  • 3
3
votes
1 answer

Error while loading .ods sheet into Octave

I am trying to read a column of integers in a spreadsheet into Octave using the code A = odsread('Data.ods', 'Sheet1', 'A1:A946'); But it fails and I get a message with warnings and errors as : > unzip: cannot find or open Data.ods, Data.ods.zip…
Syed Saad
  • 705
  • 5
  • 15
3
votes
2 answers

Open .odp, .odt, .ods files using WebView

I'm using an UIWebView for viewing .pdf, .txt, .xls, .ppt files. I used webView loadRequest method for viewing these files and its working fine. I need to view files such as .odp, .odt, .ods etc, but its showing only blank page in UIWebView. Is…
Vishnu Kumar. S
  • 1,797
  • 1
  • 15
  • 35
3
votes
1 answer

Why is varnum stopping proc contents in sas?

I have the following code ods select Variables; proc contents data=xmlout.&XML_DSET; run; The ods pdf open statement is earlier in the code ods pdf file="&exceldir\README.pdf" startpage=never; title 'README FILE'; This takes…
Jason Rogers
  • 667
  • 1
  • 6
  • 19
3
votes
0 answers

View ODF file on a website

Good Day, I have created an .ods file. How can i view the whole spreadsheet on my website? I have searched for odf-php, WebODF and a few other but i dont know how to implement it. I'm creating a custom website and I want users to view the .ods file…
user3426235
  • 61
  • 1
  • 3
3
votes
1 answer

ODF Toolkit: Get string value from cell without the comment from ods or odf dodument

ODF Toolkit provides the method getStringValue() to get the cell string content. If the cell has or even had a comment the getStringValue() returns the existing or former existing comment + the cell content. Cell cell =…
user3530890
  • 31
  • 2
2
votes
3 answers

C++ class to read and write opendocument spreadheets (*.ods)

I was looking for a Qt implementation (since Qt already support export of rich text to odt) but found none of them. Then I was astonished that I can't find any C++ class to read/write ods files. I need to import/export tables with basic formating…
Julien M
  • 657
  • 3
  • 10
  • 40
1
2 3
…
12 13