Stack Overflow
Stack Overflow

Questions tagged [xls]

xls is the file extension for files created using the default format of Microsoft Excel (prior to Excel 2007).

xls is the file extension for files created using the default format of Microsoft Excel (prior to Excel 2007). An Excel file uses the BIFF (Binary Interchange File Format) format. Documentation for the format has been made publicly available by Microsoft, and can be found on MSDN

1871 questions
17
votes
2 answers

Reading numeric Excel data as text using xlrd in Python

I am trying to read in an Excel file using xlrd, and I am wondering if there is a way to ignore the cell formatting used in Excel file, and just import all data as text? Here is the code I am using for far: import xlrd xls_file =…
Brian
  • 1,703
  • 3
  • 17
  • 23
17
votes
11 answers

Application not quitting after calling quit

I have a small problem that I can't seem to figure out. I am saving a DataGridView (it's contents) to an xls file. I have no problem in doing so except in my task manager its still showing up that it's running. I have called: …
Trevor
  • 7,777
  • 6
  • 31
  • 50
16
votes
4 answers

Combine multiple csv files into a single xls workbook Python 3

We are in the transition at work from python 2.7 to python 3.5. It's a company wide change and most of our current scripts were written in 2.7 and no additional libraries. I've taken advantage of the Anaconda distro we are using and have already…
Tobias Wright
  • 183
  • 1
  • 1
  • 6
16
votes
2 answers

Python - Validate if a sheet exists in my document xls

I am trying to design a small program on my free time which loads an xls file, then select a sheet in the document to be scanned. Step 1: the user imports an .xls file . After importing the program checks whether the file exists. (That I can do…
Loman
  • 173
  • 1
  • 1
  • 5
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
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
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
2 answers

How to use POI SXSSF to read a large spreadsheet

I am trying to read an xls file by using SXSSF. I have read about SXSSF, but do not understandexactly how to use it. So I am running into some problems. Can anybody help me with the java code for reading large xls files (some 100,000 rows and 7-8…
abhi
  • 1,584
  • 5
  • 17
  • 25
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
14
votes
3 answers

Convert XLS to XLSB Programmatically?

I have a customer that needs to convert XLS files to XLSB. Has anyone done this programmatically, (with or without an add-on --- doesn't matter --- just need to be able to automate it)? I'm looking for a way to automate this. As a side note, the…
John Cruz
  • 1,562
  • 4
  • 14
  • 32
14
votes
1 answer

Angular 6 ResponseContentType

I'm trying to download some xls from my api rest, but to no avail, do I need something to use ResponseContentType? [ts] O módulo '"/home/dev/Documentos/JAVA-TUDO/SIMPLUS/simplus-cliente/node_modules/@angular/common/http"' não tem nenhum membro…
Junior Osho
  • 173
  • 1
  • 1
  • 9
14
votes
6 answers

Safari adding .html to download

I have a little function, that creates .xls document(using PHPexcel) and then sends it to php://output. Then user download it. Everything works fine, except that safari on mac os x adds .html extension for some reason. So the resulted file is named…
Davinel
  • 940
  • 4
  • 10
  • 20
14
votes
1 answer

Exporting HTML tables to Excel (.xls) in a separate sheet

I've got a simple HTML page (generated by an external application) that contains a table view. I am trying to scrape off the tables from the page and put them in an Excel workbook. I have managed to put the whole HTML contents in a workbook by…
Nasco Bozhkov
  • 467
  • 1
  • 8
  • 17
13
votes
4 answers

Create a password protected Excel file using Apache POI?

I am developing a simple Java program to create an Excel file using (Apache POI) API. I am using Oracle 10g as a database and using the ojdbc14 JAR file. I have a table called USERINFO, having three columns, namely USERNAME, PASSWORD, and NAME. Now…
vikiiii
  • 9,246
  • 9
  • 49
  • 68
13
votes
7 answers

How to check if .xls and .csv files are empty

Question 1: How can I check if an entire .xls or .csv file is empty.This is the code I am using: try: if os.stat(fullpath).st_size > 0: readfile(fullpath) else: print "empty file" except OSError: print "No file" An empty…
bob marti
  • 1,523
  • 3
  • 11
  • 27
1 2
3
…
99 100