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

Fast way to read xlsx files into R

It is a follow-up question to this one. What is the fastest way to read .xlsx files into R ? I use library(xlsx) to read in data from 36 .xlsx files. It works. However, the problem is that this is very time consuming (well over 30 minutes),…
LaTeXFan
  • 1,136
  • 4
  • 14
  • 36
22
votes
1 answer

C# OPENXML XLSX Custom Column width

C# newbie here! I need to create a small console application to convert CSV files into XLSX files. I have all my styles and data working, but I want to set a different (from default) width on some columns. And after a day of searching and reading I…
Zankul
  • 247
  • 1
  • 3
  • 7
22
votes
4 answers

Django: openpyxl saving workbook as attachment

Hi I have a quick question. I didn't find answer in internet maybe someone of you can help me. So i want to save workbook as attachment but I don't know how lets see an example : from openpyxl import Workbook from openpyxl.cell import…
Silwest
  • 1,620
  • 1
  • 15
  • 29
21
votes
1 answer

How to fix OutOfMemoryError (Java): GC overhead limit exceeded in r?

I have to read a file in a list of folders and save data in R. I use following code for my test data and it works. When I use the code for the actual data then I get this error Error: OutOfMemoryError (Java): GC overhead limit exceeded Called from:…
poshan
  • 3,069
  • 5
  • 20
  • 30
21
votes
1 answer

How to avoid writing a row.names column when saving a data.frame using the xlsx package

I have a data frame like this one below and I really want to remove the row names when I export it to a excel file using the xlsx package. bd <- data.frame(id = 1:200, A = c(rep("One", 100), rep("Two", 100)), B = c(rep(1,50), rep(0,…
Davi Moreira
  • 943
  • 3
  • 10
  • 23
20
votes
5 answers

EPPlus - How to use a template

I have recently discovered EPPlus (http://epplus.codeplex.com/). I have an excel .xlsx file in my project with all the styled column headers. I read on their site that you can use templates. Does anyone know how or can provide code sample of how to…
Baxter
  • 5,633
  • 24
  • 69
  • 105
20
votes
12 answers

User Defined Functions NOT recalculating

I recently took a large, stable XLSM file, and split it apart into an XLAM and XLSX. Thousands of cells in the XLSX call (udfs) functions in the XLAM, and each such udf begins with the statement "Application.Volatile" (overkill, to force…
tpascale
  • 2,516
  • 5
  • 25
  • 38
20
votes
3 answers

export data frames to Excel via xlsx with conditional formatting

I want to export data frames to Excel and highlight cells according to certain rules. I don't think this answer to a similar question is correct. I think it is possible, and I think I get close using the CellStyle functions of the xlsx…
Eric Green
  • 7,385
  • 11
  • 56
  • 102
20
votes
6 answers

Import an XLSX file into a PHP array

Is it possible to import each line of an XLSX file to a row in a PHP array?
ddfgdfdfgdfgdfgfdgfdgdg
  • 335
  • 1
  • 3
  • 8
19
votes
2 answers

Formatting percentages in R-package openxlsx

R3.2.3/openxlsx 3.0.0 I have several dataframes that I'm writing to an Excel-workbook with openxlsx. One of the dataframes contains values such as 0.07. With createStyle(numFmt='PERCENTAGE') I get 7.00% as output in the workbook. So far so good.…
Jack Random
  • 191
  • 1
  • 4
19
votes
9 answers

Which gem support Import/Export to xlsx file in ruby

I need to read and write to Excelx file with ruby code, Tried with spreadsheet it does not support xlsx format, Roo is also to read the file and not write to xlsx. Is there any gem/plugin which will write to Excelx?
user569445
  • 231
  • 1
  • 3
  • 5
19
votes
3 answers

Creating Excel (.xlsx) files in Cocoa

I'm writing a Cocoa application and I'm trying to export to the Excel XML format (ISO/IEC 29500-1) which is basically a zip file with a bunch of XML files in it named with a .xlsx extension. I've tried generating AppleScript and using NSAppleScript…
Austin
  • 4,638
  • 7
  • 41
  • 60
19
votes
7 answers

xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors

I have an xlsx file that I generate using SSIS. The data to this file is written through a data flow task where the xlsx file is the oledb destination. I have used the following connection string as an expression for the OLEDB…
trailblazer
  • 1,421
  • 5
  • 20
  • 43
18
votes
2 answers

Read Data from XLSX in c#

I am new to c# and am trying to read an XLSX file in c# with the following code: string Connection = "Provider=Microsoft.ACE.OLEDB.12.0;DataSource=c:\\Temp\\source.xlsx;Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\";"; //code to read the content…
RRZ Europe
  • 954
  • 3
  • 14
  • 31
17
votes
6 answers

Parsing an Excel file in C#, the cells seem to get cut off at 255 characters... how do I stop that?

I am parsing through an uploaded excel files (xlsx) in asp.net with c#. I am using the following code (simplified): string connString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel…
naspinski
  • 34,020
  • 36
  • 111
  • 167
1 2
3
…
99 100