Stack Overflow
Stack Overflow

Questions tagged [openxls]

OpenXLS is a Java spreadsheet SDK that allows you to read, modify and create Java Excel spreadsheets from your Java applications.

OpenXLS is the open source version of ExtenXLS -- a Java spreadsheet SDK from Extentech that allows you to read, modify and create Java Excel spreadsheets from your Java applications.

Extentech released the source under LGPL a year or so ago, and has since dropped maintenance and support for OpenXLS. The code is now under active maintenance on Github:

-- Feb 2014

30 questions
10
votes
5 answers

Generate office open XML excel file from javascript

Is there a way to generate an .xslx file from javascript and allow the user to download it by javascript? This page is geared towards being run offline in html 5 with no internet connectivity.
Shawn Mclean
  • 56,733
  • 95
  • 279
  • 406
3
votes
2 answers

R - Adding a total row in Excel output

I want to add a total row (as in the Excel tables) while writing my data.frame in a worksheet. Here is my present code (using openxlsx): writeDataTable(wb=WB, sheet="Data", x=X, withFilter=F, bandedRows=F, firstColumn=T) X contains a data.frame…
Arani
  • 753
  • 1
  • 9
  • 23
3
votes
4 answers

Choosing an excel java api

All I need to do is open an MS excel sheet - not sure which kind yet (2003, 2007, etc.) - and parse the information in each row into an object. I'm performing only readonly operations. out of Apache POI, JExcelAPI, or OpenXLS which is best for this…
Victor
  • 5,697
  • 6
  • 34
  • 41
2
votes
2 answers

openxlsx: Where is the data located in the workbook object

library(openxlsx) wb <- createWorkbook() addWorksheet(wb, "iris") writeData(wb, "iris", iris) Where can I find the data/tab data for iris in wb? EDIT: I would like to see the data in a R session and export it back as a R object to see what it…
MLEN
  • 2,162
  • 2
  • 20
  • 36
2
votes
3 answers

Export data frames in list to xlsx with named sheets

I need to create an xlsx file with my list of data frames. I came across this solution openxlsx solution, see below (or 5th Answer by Syed). However, my list has 51 named data frames, what changes do I make to below for a long list of data frames?…
pyeR_biz
  • 986
  • 12
  • 36
2
votes
1 answer

Lock specific cells in an Excel file from R while preserving formatting

I'm trying to lock a block of cells in a series of Excel files, protect each file, and save them in their original location. I have the code working in every way except that locking the columns strips those cells of all formatting. I can't recreate…
criticwhocounts
  • 31
  • 5
2
votes
1 answer

Replace specific values in openpyxl

I have a excel file that looks like this: 1984 1 1 1985 1 1 I want to change all of the values in column 2 to 0 but I am not sure how to loop through rows. I have tried: import…
Stefano Potter
  • 3,467
  • 10
  • 45
  • 82
1
vote
1 answer

Set Excel Worksheet Zoom Level from R (openxlsx)

If I add a worksheet to an Excel workbook using R I am able to set its zoom level via: openxlsx::addWorksheet(wb = wb, sheetName="foo", zoom = "bar") But how do I set the zoom level to an existent sheet? openxlsx provides a similar option to row…
Dan
  • 1,711
  • 2
  • 24
  • 39
1
vote
1 answer

How do I modify an existing sheet in Excel using openxlsx (with same lay-out)?

Lets say I create the following Excel file: library(openxlsx) library(writexl) writexl::write_xlsx(list(iris = iris, mtcars = mtcars), "example_modify_exceltab.xlsx") Then I would like to modify an existing sheet in this file. I use the answer…
mharinga
  • 1,708
  • 10
  • 23
1
vote
1 answer

Creating and saving multiple .xlsx files using for loop openxlsx

I am attempting to create save multiple formatted Excel files, each of which are subsetted from a certain data frame by a factor. This is an example of what I have tried so far # Create data df <- data.frame(category = rep(c("a","b","c","d"),times =…
Che Diaz
  • 55
  • 5
1
vote
0 answers

How can I run a program, that uses the openxlsx package, from another computer using shinyapps.io?

What happened is this: I built a program using Shiny. But in this program, I am also using openxlsx in order to print my results in an excel file using write.xlsx(). So at the very top of my server.R file, I wrote this piece of…
Rodrigo Guinea
  • 328
  • 4
  • 16
1
vote
4 answers

display .xls file data in a browser as a web content

I am trying to display display .xls file data in a browser(prefer ie,ff,chrome and safari) as a web content. The thing is i have an .xls file in my computer where i'll all the data manipulations in the xls file and want the data in it to b displayed…
vinay
  • 11
  • 1
  • 2
1
vote
1 answer

(OpenXML) Add data pages to xml package without framework

lately I've been into combining multiple OpenXML speadsheets via PHPExcel which showed me that this framework has certain issues which makes it pretty much unusable for what I want to do (my related SO question). To make it short: it's hard to…
KB22
  • 6,899
  • 9
  • 43
  • 52
1
vote
4 answers

Writing a formula to a cell with OpenXLS

I'm using Java and OpenXLS to write out an Excel spreadsheet. I want to set a formula for a cell but I haven't got a clue how to do it. Can anybody help me, please? :) (Can't tag this with "openxls" because I'm a new user...)
Brian Beckett
  • 4,742
  • 6
  • 33
  • 52
0
votes
0 answers

How can i insert 1 row en sheet excel from R?

I´m new using the packages "xlsx": wb <- xlsx::loadWorkbook(file = "test.xlsx") sheets <- getSheets(wb) sheet <- sheets[['0923301_']] rows <- getRows(sheet)#all rows cells <- getCells(rows)#all cols i want insert a row update values into…
nose
  • 1
  • 1
1
2