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
0
votes
1 answer

create a pdf of all bar-line plots appended together

i've created a series of plots using proc gbarline and I wish to export all plots to one pdf instead of just the first plot, I am having two issues: the plot does not export to pdf unless I print the first plot twice, hence why I use the…
user5572129
0
votes
1 answer

SAS proc report RTF table column widths not aligning with specified widths

When generating a SAS table in format .rtf using proc report, the column widths are not aligning to their specified widths. This is resulting in column headings taking up multiple lines, and a few values being truncated, which I want to avoid. Using…
MBorg
  • 1,345
  • 2
  • 19
  • 38
0
votes
0 answers

How to write ods latex template in SAS

Based on this document: https://support.sas.com/resources/papers/proceedings14/2033-2014.pdf I created the attached result and using the attached code, enter image description here but I want to produce my own template that creates output as this…
Sasadomo
  • 1
  • 1
0
votes
2 answers

SAS ODS not to open output

In the following code, I would like to print an excel sheet and do not open it once the code ends, does anyone know how to do this because the ods excel close does not work. There is an option in the SAS 9.4 platform to not open the output but when…
Tazz
  • 85
  • 1
  • 10
0
votes
2 answers

I don't know why I cannot import the .ods file

I cannot use Python package "xlrd". I wanted to deal with an excel data and prepared ods file and save in the directory where there is this python's file. I was trying to import an ods file, but an error below occurred. Python code import…
TONIA
  • 17
  • 1
  • 2
0
votes
0 answers

Read the content of file .ods

I'm creating an application with android studio that analyze datas in a file on google drive (.ods). I have already transformed this file .ods in json. Now i need how to connect this file with the application.
bolzy9
  • 31
  • 5
0
votes
1 answer

SAS Macro Query

I am having trouble with the following %macro for a regression. Basically, I want it to run whenever i=j, and i=1 to 12 and j=1 to 12. %macro reg(num=); %do i=1 %to # %do j=1 %to # proc reg data=ccy.eur; *Specify Currency Data…
CISCO
  • 539
  • 1
  • 4
  • 14
0
votes
1 answer

Header cell with same length as underlying cells in OpenTBS

I want to have length of header cell (composed of merged cells) equal to amount of underlying generated cells [ header value ] [cell value 1][cell value 2][cell value 3][cell value 4][cell value…
koxt
  • 683
  • 7
  • 16
0
votes
1 answer

SAS 9.4 - Re-activate Results Viewer after ODS HTML CLOSE but suppress writing HTML Body File

When I need to export to Excel in SAS 9.4, I typically run a code like this: ods html close; ods html file="C:\folder\filename.xls"; ods html close; ods html; /*with this I'm trying to send my output back to the results viewer once more*/ However,…
LRS
  • 7
  • 1
0
votes
1 answer

export file head line has extra row

I want to export odsfile like this but I really got export is this(head line has extra word) here is my code,Thanks for any suggestion @RequestMapping(value = "/export", method = RequestMethod.POST) public @ResponseBody void exportOds(Long…
user7189675
0
votes
0 answers

soffice converted .ods file ,Failed to read .ods file using jOpenDocument API

I have converted .xls file to .ods by using below command in terminal COMMAND : soffice --headless --convert-to ods abcd.xls After conversion I am not able to read fileName.ods using SpreadSheet API of jOpenDocument1.3.jar. When ever I try to read…
Rajesh Hatwar
  • 1,843
  • 6
  • 39
  • 58
0
votes
2 answers

lists in ods template with XDocReport and freemarker

Have a simple, ods template. Just want to iterate a list and display the data in the columns Is working in ODT format, where I have this in the first character of a table: @table:table-row [#list booksList! as book] @/table:table-row [/#list] This…
kandan
  • 715
  • 2
  • 12
  • 39
0
votes
1 answer

php - PHPExcel setReadDataOnly(true) is not working with ODS

Enter 12:00 in an ODS cell and get default Time format, setReadDataOnly(true) then getValue(), the value is 25569.5, if format the cell as number then getValue(), the value is 0.5. How can I see 12:00 in ODS and getValue()= 0.5?
W. Nel
  • 1
  • 3
0
votes
0 answers

SAS Proc UCM ODS tables output for multiple iterations

I am trying to run multiple iterations(5400) of various combinations of predictors in Proc UCM. The SAS code with all combination of variables has been sequentially generated using an external programming code like csharp etc. I think this can be…
paops
  • 1
  • 1
0
votes
1 answer

ODS Excel vs ODS Tagsets.excelxp options SAS

I am trying to use the new ODS EXCEL instead of ODS Tagsets.Excelxp since I need .XLSX file. Everything works fine but I am getting trouble with the font: The code I used is: ods Excel file="c/Profitability_ttm.xlsx" style=…
shankar
  • 63
  • 1
  • 8
1 2 3
…
12 13