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
1
vote
3 answers

Unspecified Error when trying to read xlsx info via Microsoft.ACE.OLEDB driver

I have an application which has been upgraded from Visual Studio 2010 (running on Windows Server 2003) to Visual Studio 2013 (now running on Windows Server 2008). One aspect of the app allows the user to upload an xlsx sheet to a folder, and a…
mrwienerdog
  • 815
  • 3
  • 18
  • 35
1
vote
2 answers

Python split string(',') issue on a csv field

I have an issue where I am reading a csv file as a file ( easier for me to get results that reading as csv) that is exported from an application. I have my code working to read that file and import it into a list. Then I iterate through the list and…
user1385511
  • 17
  • 3
1
vote
0 answers

R issue while loading library xlxs - Error : cannot allocate vector of size 3.6 Gb

I am trying to load library(xlsx) in R but getting below mentioned error: Loading required package: rJava Error : cannot allocate vector of size 3.6 Gb In addition: Warning messages: 1: package ‘xlsx’ was built under R version 3.1.3 2: package…
rohan goel
  • 11
  • 1
1
vote
1 answer

Read .xlsx Excel File error

Hi I've Error while reading .xlsx Excle file. I'm using Excel.dll and when I'm trying to read data from my worksheet I'm getting error "End of Central Directory record could not be found." Here's sample code foreach (var worksheet in…
komluk
  • 437
  • 4
  • 18
1
vote
0 answers

Why do I get the below error while loading the xlsx package in R?

> library(xlsx) Error : .onAttach failed in attachNamespace() for 'xlsx', details: call: .jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook") error: java.lang.NoClassDefFoundError Error: package or namespace load failed for ‘xlsx’ Is there any…
sunitprasad1
  • 768
  • 2
  • 12
  • 28
1
vote
0 answers

How to manage merged cells in BIRT?

I am using BIRT 3.7.2 with Spudsoft emitter to create xlsx output from a report. If I merge 2 cells in the report designer, the output file xl/worksheets/sheet1.xml contains this:
Tamas G.
  • 677
  • 3
  • 21
  • 38
1
vote
1 answer

How can i write the value from DateTime.Now into Excel

I am working on a school project and im using microsoft visual studio 2010 language c# (I have teached only C and a little bit of C++). I am making an Excel file. I'm using something like "add reference", .COM and add library from excel. I can make…
Marcel
  • 33
  • 2
1
vote
0 answers

Converting an xlsx file to a csv file c++

I am trying to read an xlsx file and write to a csv file using LibOPC. The xlsx file contains various data types and the structure of the file is important. I have used the following code to read the sharedstrings, but I'm not sure how to relate…
Jak
  • 471
  • 5
  • 20
1
vote
2 answers

Number of spreadsheets in workbook in python

how to check the quantity of the spreadsheets in xlsx workbook in python? Is there any command under win32com library?
Andrey Pokul
  • 17
  • 3
1
vote
0 answers

Error Message after creating XLSX file using java

I am using apache poi to create a simple xlsx file using java as follows String date = "2014/12/29"; XSSFWorkbook w = ADPFidessa.createExcelWorkbook(date); response.reset(); response.setContentType("application/xlsx"); …
AbtPst
  • 7,778
  • 17
  • 91
  • 172
1
vote
2 answers

UIWebview - could not open the password protected .xlsx,.docx and .ppt

I have tried to open (using loadData/loadRequest methods of webview) the password protected files in my web view controller. I can open the password protected pdf and zip files. it works fine. But When I tried to open the other password protected…
Finder
  • 8,259
  • 8
  • 39
  • 54
1
vote
1 answer

While using JRXlsxExporter, the file is not getting generated with proper extension

I am trying to generate the report in .xlsx format and for that I have written this code: fileExtension = ".xlsx"; file = this.getTempFileOutput(xnetMetaDB, fileExtension); JRXlsxExporter exporter =…
Aakash Sathawane
  • 21
  • 4
1
vote
0 answers

HowTo filter Rows in XLSX's J?

I am using SheetJS / XSLX / J to extract and parse JSON from Excel documents. 1.) I am facing the issue that in an Excel file I need to parse, I need to discard the 6 first rows. 2.) As an aside I am also facing the issue of extracting only the…
Stephan Kristyn
  • 15,015
  • 14
  • 88
  • 147
1
vote
1 answer

how to automatically rename a sheetname in a for loop (xlsx)

I am trying to construct a loop which automatically subsets a dataset, makes alot of computations, and prints the results for each group as seperate sheets to a xlsx-workbook-file. It should work along the lines of the following…
grrgrrbla
  • 2,529
  • 2
  • 16
  • 29
1
vote
1 answer

Perl write excel to create charts with cells containing formulas in various worksheets

Is it possible to use Excel::Writer::XLSX module of perl and create charts with cells containing formulas? Here is what I am doing: 1) Created an xlsx file with multiple worksheets - no issues 2) Created charts in one worksheet with constant values…
raj_arni
  • 959
  • 2
  • 15
  • 29
1 2 3
…
99
100