Stack Overflow
Stack Overflow

Questions tagged [xlsx]

xlsx is the file extension for files created using the default format of Microsoft Excel 2007 or higher.

xlsx is the file extension for files created using the default format of Microsoft Excel 2007 or higher. This is the Microsoft Office Open XML SpreadsheetML format. This format is based around a zipped collection of eXtensible Markup Language (XML) files. Microsoft Office Open XML SpreadsheetML is mostly standardized in ECMA 376 and ISO 29500.

Resources

3538 questions
12
votes
4 answers

xlsx generation in nodejs, along with graphs

I need to create Excel Sheet report in nodejs, along with some pie/bar charts. The Packages like https://github.com/SheetJS/js-xlsx and https://github.com/guyonroche/exceljs doesn't provide the facility to create charts. Can anyone suggest any…
Kshitij Mittal
  • 2,698
  • 3
  • 25
  • 40
12
votes
2 answers

Dynamically converting a list of Excel files to csv files in R

I currently have a folder containing all Excel (.xlsx) files, and using R I would like to automatically convert all of these files to CSV files using the "openxlsx" package (or some variation). I currently have the following code to convert one of…
costebk08
  • 1,299
  • 4
  • 17
  • 42
12
votes
1 answer

What is the meaning of t="shared" in a formula element?

When inspecting a cell element in XLSX file, I find the following formula element: What is the meaning of such a formula element?
alancc
  • 487
  • 2
  • 24
  • 68
11
votes
3 answers

Reading .xlsx format in python

I've got to read .xlsx file every 10min in python. What is the most efficient way to do this? I've tried using xlrd, but it doesn't read .xlsx - according to documentation he does, but I can't do this - getting Unsupported format, or corrupt file…
Djent
  • 2,877
  • 10
  • 41
  • 66
11
votes
3 answers

Use R and Openxlsx to output a list of dataframes as worksheets in a single Excel file

I have a set of CSV files. I want to package them up and export the data to a single Excel file that contains multiple worksheets. I read in the CSV files as a set of data frames. My problem is how to construct the command in openxlsx, I can do it…
Technophobe01
  • 8,212
  • 3
  • 32
  • 59
11
votes
2 answers

R - xlsx package - how to add cell color without changing border

I'm trying to export a table to Excel with a layout. I found a lot of information about the xlsx package and how to use it but there's still still something wrong with my script. I don't know how to fill a cell with color, without modifying the…
PBSH
  • 111
  • 1
  • 3
11
votes
3 answers

Creating Transform stream using ExcelJS for writing xlsx

I'm using ExcelJS module and writing wrapper for my purposes, which implements Transform Stream API (yes, node version is 0.10.40). ExcelJS has a stream API and according to example in ExcelJS module we can use one like this (execute node index.js >…
cassln
  • 722
  • 2
  • 6
  • 18
11
votes
2 answers

Write dataframe to excel with a title

I would like to print out a dataframe in Excel. I am using ExcelWriter as follows: writer = pd.ExcelWriter('test.xlsx') df = DataFrame(C,ind) # C is the matrix and ind is the list of corresponding indices df.to_excel(writer, startcol = 0,…
Hamed
  • 757
  • 3
  • 10
  • 17
11
votes
2 answers

Possible to write Excel formulas or data validation using R?

I am trying to write a R data frame to Excel and want to add additional cells/columns that have Excel formulas and/or data validation values (e.g. using the Data/Validation menu in Excel to provide drop-down lists of allowable values for a…
Mac471
  • 423
  • 5
  • 16
11
votes
3 answers

Excel Cell Coloring using xlsx

Initial code: Lets assume we're using this command to create the dummy data: Data <- data.frame( X = paste(c(sample(1:10),sample(1:10)), collapse=";"), Y = sample(c("yes", "no"), 10, replace = TRUE) ) Output: …
alap
  • 646
  • 1
  • 11
  • 24
11
votes
2 answers

Import password-protected xlsx workbook into R

How can I import a worksheet from a password-protected xlsx workbook into R? I would like to be able to convert an Excel worksheet into a csv file without having to go through Excel itself. It is possible for xls workbooks using the perl-based…
user1922462
  • 111
  • 1
  • 3
11
votes
2 answers

How to read XLSX file of size >40MB

I am using XSSF of apache-POI to read the XLSX file. I was getting an error java.lang.OutOfMemoryError: Java heap space. Later, increased the heap size using -Xmx1024m for the java class still the same error repeats. Code: String filename =…
Avinash
  • 113
  • 1
  • 1
  • 7
11
votes
2 answers

How convert stream excel file to datatable C#?

I use Epplus to reading xlsx files from stream. It has a bug , it cant read some columns in my workbook.How can read xlsx files from stream to datatable without epplus ? my older code: public static DataSet ReadExcelFile(Stream stream) { …
Mennan
  • 4,451
  • 13
  • 54
  • 86
11
votes
2 answers

iterating over a range of rows using ws.iter_rows in the optimised reader of openpyxl

I need to read an xlsx file of 10x5324 cells This is the gist of what i was trying to do: from openpyxl import load_workbook filename = 'file_path' wb = load_workbook(filename) ws = wb.get_sheet_by_name('LOG') col = {'Time':0 ...} for i in…
Ali Haroon
  • 198
  • 1
  • 1
  • 11
10
votes
6 answers

Why showing error message while opening .xls file

In my asp.net, C# application we are generating and downloading .xls file. But when I'm trying to open, it's giving a message "The file you are trying to open, 'filename.xls', is in a different format than specified by the file extension. Verify…
Sukanya
  • 1,041
  • 8
  • 21
  • 40
1 2 3
…
99 100