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
2
votes
2 answers

sas proc pdf doesn't export the files

I am trying to export to a specific location a set of about 15 PDF files, using the ODS PDF. While using the same code but exporting with ODS EXCEL - I get excellent results. With the ODS PDF - I get no results. INITIAL PROC: PROC SQL ; SELECT…
Eyal Marom
  • 281
  • 4
  • 18
2
votes
2 answers

Pandas ExcelWriter(...,engine='odf') - no module named odf

I'm confused as to why I'm unable to save my data to a .ods document, with the provided error. I've looked at the documentation for pandas.ExcelWriter() and it clearly states to use engine='odf' to be able to save as a .ods. Code: import pandas as…
maertsoi
  • 103
  • 7
2
votes
1 answer

Specify col_types in readODS::read_ods

I want to read in R a range from an ods file, of which first column must be character, and the other 40 columns must be doubles. How do I specify the col_types? col_types = paste0("c", paste(rep("d", times = 40), collapse = "")) does not work, I get…
MartineJ
  • 591
  • 5
  • 16
2
votes
2 answers

SAS problem with curvelabelpos and xaxis in PROC SGPLOT

I am currently trying to use PROC SGPLOT in SAS to create a series plot with five lines (8th grade, 10th grade, 12th grade, College Students, and Young Adults). The yaxis is a percentage of prevalence in drug use ranging from 0-100. The xaxis is the…
Scott F
  • 37
  • 7
2
votes
0 answers

Saving .ods as .xls file through Excel macro

I'm trying to convert multiple .ods files in .xls format. Because of the reasons I can't use Workbook.SaveAs nor Workbook.Open methods, so currently I'm stuck at this: Public FileName As Variant Sub Choose() Set FileName= Nothing ChDrive…
AntiDrondert
  • 1,128
  • 8
  • 21
2
votes
0 answers

How to add a value to any column in ods file via python?

I've a file .ods with 10 rows in each row a number from 0 to 9. I need to assert a certain value for each row like whether this number is even or odd. I wrote some code like this: import pyexcel_ods as pe from pyexcel_ods import save_data from…
TAM.G
  • 85
  • 1
  • 9
2
votes
0 answers

How to read opendocument spreadsheet .ods file from SSIS

I need to create a package in ssis that reads data from opendocument spreadsheet (ODS). Columns in ODS file are dynamic. For example, for this month source file (.ODS) will arrive with columns like T1,T2,T3 Next Month, Source file (.ODS) will arrive…
dev
  • 21
  • 1
2
votes
2 answers

Specify table/column/cell widths in Outlook email from SAS

Is it possible to specify table/column/cell widths of a HTML table in Outlook using proc print? I've tried defining templates and specifying via styles and the tagattr option. Using the style= option on proc print.
Robert Penridge
  • 8,424
  • 2
  • 34
  • 55
2
votes
0 answers

how to get ods file format data in php

I am upload .ODS file in that file there are 6 fields & 1 row but when i am using below code email not fetch but other data display. $inputFileName = 'uploads/' . basename($_FILES['file']['name']); $inputFileType =…
dev1
  • 231
  • 2
  • 5
  • 12
2
votes
1 answer

Making QQ Plots, Histograms and Scatterplots using SAS

I have this dataset: data flu; input FluShotStatus age HealthAwareIndex gender; datalines; 0 59 52 0 0 61 55 1 1 82 51 0 0 51 70 0 0 53 70 0 0 62 49 1 1 51 69 1 0 …
oxnot
  • 55
  • 5
2
votes
1 answer

Importing ODS file to MySQL

I am trying to import an ODS file in an MySQL database with phpMyAdmin. I clicked on the desired table (table1) on the left and clicked on the 'Import' tab. The data in the file matchs the one of the table. I checked the option to specify that the…
Robin_
  • 131
  • 2
  • 9
2
votes
1 answer

add a sheet to an ods file via python

I started with the package simpleodspy and it worked fine until I wanted to add an new sheet to an ods file. Than I figured out that simpleodspy is just an better wrapper for odfpy to simpliy the api. So I guess they scipted the adding an sheet…
Peter
  • 1,629
  • 2
  • 25
  • 45
2
votes
2 answers

Editing `ods` file in C++ code

I need to edit LibreOffice Calc document programmatically in C++. I know that there is odfkit library, which uses webodf, but it looks like it doesn't support editing .ods files. Is there any alternative that can deliver me this feature?
Krzysztof Stanisławek
  • 1,267
  • 4
  • 13
  • 27
2
votes
1 answer

Generate OpenDocument Spreadsheets with PHP

I'm trying to generate OpenDocument Streadsheets using PHP. This is my code: $content_xml = '
esviko
  • 250
  • 1
  • 3
  • 15
2
votes
0 answers

Reading files with long lines in lua

I would like to read an .ods file line by line using lua on Windows. The code I used to do that worked on another platform but failed on Windows. So I changed the code to see what is going on: local fhandler =…
Michael Gerbracht
  • 173
  • 2
  • 16
1
2
3
…
12 13