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

How to delete Row while printing into excel format

I have simple code written in python. while writing into an excel file. I found additional rows get added each time. How can I skip the empty row added each time. and print data one after the other in an excel file import csv from datetime import…
user3551354
  • 39
  • 1
  • 7
0
votes
2 answers

How to check if an online Excel file is in use by another user?

I have a Microsoft Excel file on OneDrive. When my Python script saves anything to the file and the file is already open, OneDrive raises an error, telling me there is a sync issue. If the file is closed(not in use by another user), everything works…
mclogan
  • 35
  • 5
0
votes
1 answer

Error: openxlsx can only read .xlsx files while reading .xslm file in R

library(tidyverse) library(openxlsx) library(lubridate) library(readxl) source("global_config.R") inputFile <- "../data/census.xlsm" peopleData <-read.xlsx(inputFile, sheet = "peopleData", startRow = 16 ) view(peopleData) I am getting the…
RasK
  • 51
  • 6
0
votes
1 answer

Setting up a cell-to-cell hyperlink

I would like to know if it was possible to set up a link that redirects me to cell id1 sheet b (A1, B1, ect.) when I click on cell 1 sheet a (A2, A3, ect.) ? (Or must better create a link from line 2,3,ect. sheet a to column A,B,ect. sheet b )…
problème0123
  • 841
  • 2
  • 9
  • 23
0
votes
0 answers

Adding a dataframe to a newly created sheet in multi-sheet excel file using openxlsx

I am trying to create and fill an excel sheet. First, I load a huge xlsx file with many sheets (test4.xlsx). Afterwards I create an empty sheet and than fill it out with a relatively large DataFrame (5000 rows and 80 columns). The first three lines…
And_R
  • 1,647
  • 3
  • 18
  • 32
0
votes
1 answer

openpyxl 'Worksheet' object has no attribute 'write'(python)

Sorry for my English. I need to open a xlsx document and write in the last position new values. But I don't understand how to do it. My algorithm works like this: Open xlsx l_workbook = load_workbook(old_log_tmp_path) Get all value from…
r1299597
  • 609
  • 3
  • 10
  • 20
0
votes
1 answer

Append data to different sheets in an excel in R

I have a dataframe like All_DATA ID Name Age 1 xyz 10 2 pqr 20 5 abc 15 6 pqr 19 8 xyz 10 9 pqr 12 10 abc 20 54 abc 41 Right now I have code which works for subsetting the data based on Name and the putting them into…
Domnick
  • 509
  • 8
  • 25
0
votes
1 answer

Template issue with openxlsx using R

My goal is to construct an Excel spreadsheet that contains all of the formatting for my data and to only use openxlsx via R to write dataframes to the file. However, when I tried to do so, the formatting in the file is overwritten. I am calling…
John Smith
  • 51
  • 6
0
votes
0 answers

OutOfMemoryError (Java): Java heap space

I'm using XLConnect with Java on a 64 bit platform. Even after adding options(java.parameters = "-Xmx4g") I'm unable to load a 22MB file with extension .xlsx in R. Some people have suggested openxlsx package but as far as I know, it makes use of…
pooja yadav
  • 29
  • 1
  • 2
0
votes
0 answers

read.xlsx cannot find Excel file

I want to read a bunch of excel files all located in the same directory and store them in different sheets in a consolidated Excel file. I initially tried using XLConnect but kept getting the error GC overhead limit exceeded. I stumbled upon this…
DotPi
  • 3,977
  • 6
  • 33
  • 53
0
votes
0 answers

Remove List syntax from Dictionary in Python

I have a dictionary that has multiple keys and each key has multiple values. However the values in each key are syntaxed with brackets which makes the program think each key is a list of values. d = {'Select Income REIT': ['SIR', '25.19', '25.41',…
Deuce525
  • 77
  • 1
  • 2
  • 10
0
votes
1 answer

Filtering a Dictionary with mutiple keys and multiple values per key

I have a question regarding how to filter a dictionary using a loop. Here is an example of the dictionary: d = {'beta': ['ABC', '1', '5', '10', '15'], 'lambda': ['DEF', '3', '30', '22.2', '150'], 'omega': ['RST','15', '54.4', '150',…
Deuce525
  • 77
  • 1
  • 2
  • 10
0
votes
0 answers

Creat a data frame from mutiple xlsx files with multiple sheets using openxlsx

In followup to this post: Import multiple excel sheets using openxlsx , I would like to import multiple sheets from multiple xlsx files into one R data frame using openxlsx (or any other package that isn't sported by Java due to memory problems).…
Elisah
  • 115
  • 1
  • 1
  • 6
0
votes
1 answer

Launch excel in client machine

I have a excel file in server in the following directory. C:/test.xls I used the following method to directly open the server excel file in client machine. Desktop.getDesktop().open( new File("C:/test.xls") ); But the above method…
manikandan shankar
  • 1
  • 3
0
votes
0 answers

OpenXLS: how to set the Font of a Chart?

I'm using Java and OpenXLS to write out an Excel spreadsheet. I want to set the font of a chart. I used the setFontChart() method but it does not work. Can anybody help me, please? :)
Rostand Richard
  • 31
  • 3
1
2