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

xlsxwriter and LibreOffice not showing formula's result

I'm trying to create an Excel file with a simple formula: import xlsxwriter workbook = xlsxwriter.Workbook('testxlsx.xlsx', {'strings_to_numbers': True}) ws = workbook.add_worksheet() ws.write('A2', 'Number one') ws.write('B2', '1') ws.write('A3',…
Luc
  • 173
  • 1
  • 6
17
votes
2 answers

"read_excel" in a Shiny app

I have a Shiny app that uses the read.xlsx function from package xlsx. All works fine, but I want to change to read_excel from readxl, hoping it would be faster and able to cope with large files. ui part: fileInput("inputFile","Upload…
polTo
  • 290
  • 1
  • 4
  • 12
17
votes
7 answers

Unreadable content in Excel file generated with EPPlus

I'm having a little problem when I generate an Excel file from a template, using the EPPlus library. The file has a first spreadsheet that contains data that is used for populating pivot tables in the following sheets. When I open the generated…
ZipionLive
  • 722
  • 1
  • 12
  • 23
16
votes
3 answers

xlsx to json with empty cells

I'm converting a file from xlsx format to json, I can do it correctly, but I could not get it to show the cells that are empty, just ignore them. I am using the XLSX library. This is the code with which I do the parsing. const workbook =…
kmilo93sd
  • 791
  • 1
  • 15
  • 35
16
votes
2 answers

Is there any .NET Core compatible library for reading excel spreadsheet file?

I need to parse xlsx file on Linux from .NET Core Console application. However, I couldn't find any library for parsing Microsoft Office files that is supported by .NET Core 5 framework.
Štěpán Beneš
  • 189
  • 1
  • 1
  • 4
16
votes
6 answers

Convert .csv to .xls in Java

Does anyone here know of any quick, clean way to convert csv files to xls or xlsx files in java? I have something to manage csv files already in place and I need the extra compatibility for other programs. Sample code in addition to package names…
Justian Meyer
  • 3,623
  • 9
  • 35
  • 53
16
votes
2 answers

What does the "s" attribute signify in a cell tag in XLSX

In the XML of a worksheet in an XLSX file (Excel 2007) cell tags that have a "t" attribute equal to "s" are string types. The value tag inside the c needs to be looked up and converted via the sharedStrings document. But, some cells have s="237"…
chugadie
  • 2,786
  • 1
  • 24
  • 33
16
votes
5 answers

List of data.frame's to individual excel worksheets - R

I have a list of data.frame's that I would like to output to their own worksheets in excel. I can easily save a single data frame to it's own excel file but I'm not sure how to save multiple data frames to the their own worksheet within the same…
Barnaby Hussey-Yeo
  • 647
  • 2
  • 8
  • 15
15
votes
4 answers

JasperReports export to xlsx, not xls

I can't find how to export a file in .xlsx in JasperReports 4.1.1. The class: JRXlsExporter has not a Xlsx equivalent. And i can't find a parameter to set the output format from xls to xlsx.
AgostinoX
  • 7,477
  • 20
  • 77
  • 137
15
votes
2 answers

How download Excel file in Vue.js application correctly?

I'm struggling to download an Excel file in xlsx format in my Vue.js application. My Vue.js application make post request to the Node.js application which download that Excel file from remote SFTP server. Backend application works without any…
Nurzhan Nogerbek
  • 4,806
  • 16
  • 87
  • 193
15
votes
5 answers

How to export an HTML table as a .xlsx file

I have a question about exporting an HTML table as an xlsx file. I did some work and now I can export it as an xls, but I need to export it as an xlsx. Here is my jsFiddle: https://jsfiddle.net/272406sv/1/ Here is my HTML:
Erdeniz Korkmaz
  • 303
  • 1
  • 5
  • 11
15
votes
3 answers

Pandas: Always selecting the first sheet/tab in an Excel Sheet

I know how to get the list of sheet names. The excel file I am using has multiple sheets. How do I select the first one sequentially ? I don't know the name of the sheet but I need to select the first one. How would I go about this ?
Meghdeep Ray
  • 5,262
  • 4
  • 34
  • 58
15
votes
2 answers

How to extract plain text from a DOCX file using the new OOXML support in Apache POI 3.5?

On September 28, 2009 the Apache POI project released version 3.5 which officially supports the OOXML formats introduced in Office 2007, like DOCX and XLSX. Please provide a code sample for extracting a DOCX file's content in plain text, ignoring…
Robert Campbell
  • 6,848
  • 12
  • 63
  • 93
14
votes
5 answers

Pandas mode='a', if_sheet_exists='overlay' not working

Even using the code below, the content on each sheet of the .xlsx file is overwritten, not appended. What is missing? writer = pd.ExcelWriter(excelfilepath, engine='openpyxl', mode='a', if_sheet_exists='overlay') df1.to_excel(writer,…
Victor Faraon
  • 151
  • 1
  • 4
14
votes
4 answers

Apache POI for Excel: Setting the cell type to "text" for an entire column

I need to generate an .xls (Excel) file, using the Java library Apache POI for spreadsheets. The file will contain a list of phone numbers in column A, formatted as "0221...." or "+49221..." - so Excel by default interprets them as numeric cells.…
Chris Lercher
  • 37,264
  • 20
  • 99
  • 131
1 2 3
…
99 100