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
14
votes
3 answers

How to export an Excel sheet range to a picture, from within R

We are trying to automate the creation of some picture files within an R Script. We have the Excel files looking the way that we want them to, but now need to make a JPG or PNG picture-copy of those excel tables for easier web posting. We've…
Anthony Damico
  • 5,779
  • 7
  • 46
  • 77
14
votes
2 answers

How do I append data from a data frame in R to an Excel sheet that already exists

I have created dozens of data frames in R and would like to append them all to one sheet in an Excel file. Here are two of the pages I have looked at in an attempt to find an answer (I don't have 10 reputations so I can't paste all four webpage…
Regulus
  • 147
  • 1
  • 1
  • 6
14
votes
5 answers

java.lang.ClassNotFoundException: org.apache.poi.xssf.usermodel.XSSFWorkbook

when i tried to create a workbook in normal java class it is creating but when i tried to run the same on servlet it is throwing exceptions Normal java class import java.io.File; import java.io.FileInputStream; import…
Rajasekhar
  • 787
  • 6
  • 13
  • 31
14
votes
4 answers

R-Project: xlsx package installation failure (due to java issues)

I was trying to install the xlsx package, unfortunately, there is an issue with Java, which I am unable to solve. Please find below the output produced when trying to install the package xlsx. Here's the output: R version 3.1.1 (2014-07-10) --…
tamasp
  • 171
  • 1
  • 1
  • 6
14
votes
4 answers

Set xlsx to recalculate formulae on open

I am generating xlsx files and would like to not have to compute the values of all formulae during this process. That is, I would like to set to 0 (or omit it) for cells with an , and have Excel fill in the values when it is opened. One…
OrangeDog
  • 36,653
  • 12
  • 122
  • 207
14
votes
2 answers

Read xlsx file with POI (SXSSFWorkbook)

I'm trying to do my first tests of reading large xlsx file with POI, but to do a simple test with a small file I fail to show the value of a cell. Someone can tell me what is my mistake. All the suggestions are welcome. Thanks. Test.java: import…
alditis
  • 4,633
  • 3
  • 49
  • 76
13
votes
6 answers

Date in XLS sheet not parsing correctly

I am trying to read a XLS file using 'XLSX' node-module with a column having dates. After parsing the file what I found is that the dates are of few dates back from that of the dates in the sheet. This is what I a doing. var workbook =…
Piyush Kumar
  • 481
  • 1
  • 6
  • 17
13
votes
4 answers

How can I see the formulas of an excel spreadsheet in pandas / python?

I would like to read in an excel spreadsheet to python / pandas, but have the formulae instead of the cell results. For example, if cell A1 is 25, and cell B1 is =A1, I would like my dataframe to show: 25 =A1 Right now it shows: 25 25 How…
ThrowAway23948238
  • 83
  • 2
  • 2
  • 12
13
votes
4 answers

Apply styles while exporting to 'xlsx' in pandas with XlsxWriter

I use the .to_excel method of pandas to write a DataFrame as an Excel workbook. This works nice even for multi-index DataFrames as index cells become merged. When using the pure XlsxWriter I can apply formats to cells what also works nice. However I…
Nikita
  • 429
  • 2
  • 6
  • 14
13
votes
1 answer

Is there anyway in PHPExcel to hide values in an export?

I would like to be able to get the ID of my record in my sql statement: $result = $db->query("select id,FQDN, ip_address, ....."); However, I don't want it to show up in the export using headings: $headings = array('Name (FQDN)','Management IP…
user3120521
  • 141
  • 1
  • 2
  • 4
13
votes
7 answers

List xlsx sheetnames with R

Is it possible to generate a list of sheetnames within an xlsx file? Or perhaps, can I check if a sheet name exists, and if not, proceed with some designated function?
user1664455
  • 131
  • 1
  • 1
  • 3
12
votes
5 answers

Java Excel/POJO Mapping in POI

Java 8 here using Apache POI 4.1 to load Excel (XLSX) files into memory, and write lists of Java beans/POJOs back to new Excel files. To me, an Excel file (at least the ones I'm working with) is really a list of POJOs, with each row being a…
hotmeatballsoup
  • 385
  • 6
  • 58
  • 136
12
votes
5 answers

Read Xlsx file in PhpSpreadsheet

I want to read an xlsx file that was created in Microsoft Excel, but when I run the following code... $Source_File = "test.xlsx"; $Spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($Source_File); ...I receive the following error: Fatal error:…
Arya
  • 566
  • 2
  • 9
  • 22
12
votes
4 answers

How to convert xls file to xlsx file using C#?

I was developing an application which read data from an excel file, but when I try to open it, an exception  was thrown if the source file is saved with the xls format (File contains corrupted data error when opening Excel sheet with OpenXML).…
Hamzatovic
  • 121
  • 1
  • 1
  • 3
12
votes
3 answers

JavaScript - Convert CSV to XLSX (Preferably Without Use of Library(s))

As the title says, I currently have a CSV file created from SharePoint list data and in order to display this information as a spreadsheet, I want to convert it to an Excel XLSX file. I prefer to do this without relying on a third-party library. …
LaLaLottie
  • 393
  • 1
  • 4
  • 17
1 2 3
…
99 100