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

How to parse Excel (XLS) file in Javascript/HTML5

I am able to read Excel file via FileReader but it outputs text as well as weird characters with it. I need to read xls file row-wise, read data in every column and convert it to JSON. How to read xls file row by row?
ducktyped
  • 4,354
  • 4
  • 26
  • 38
179
votes
22 answers

How do I create a readable diff of two spreadsheets using git diff?

We have a lot of spreadsheets (xls) in our source code repository. These are usually edited with gnumeric or openoffice.org, and are mostly used to populate databases for unit testing with dbUnit. There are no easy ways of doing diffs on xls files…
neu242
  • 15,796
  • 20
  • 79
  • 114
149
votes
13 answers

Reading/parsing Excel (xls) files with Python

What is the best way to read Excel (XLS) files with Python (not CSV files). Is there a built-in package which is supported by default in Python to do this task?
qrbaQ
  • 1,547
  • 2
  • 11
  • 4
148
votes
10 answers

converting CSV/XLS to JSON?

Does anyone know if there is application that will let me convert preferably XLS to JSON? I'll also settle for a converter from CSV since that's what I'll probably end up having to write myself if there is nothing around.
mkoryak
  • 57,086
  • 61
  • 201
  • 257
133
votes
1 answer

What is the easiest way to convert an Excel spreadsheet with tabular data to JSON?

I want to convert spreadsheet data from Excel or Open Office saved as *.xls to *.json Data is not sensitive File is not very large
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
100
votes
16 answers

Importing Excel files into R, xlsx or xls

Please can someone help me on the best way to import an excel 2007 (.xlsx) file into R. I have tried several methods and none seems to work. I have upgraded to 2.13.1, windows XP, xlsx 0.3.0, I don't know why the error keeps coming up. I…
nolyugo
  • 1,451
  • 3
  • 12
  • 12
84
votes
10 answers

Is there a coalesce-like function in Excel?

I need to fill a cell with the first non-empty entry in a set of columns (from left to right) in the same row - similar to coalesce() in SQL. In the following example sheet --------------------------------------- | | A | B | C | D…
Fabian
  • 2,822
  • 1
  • 17
  • 22
76
votes
1 answer

VS Code C# - System.NotSupportedException: No data is available for encoding 1252

I am trying to use ExcelDataReader to read an .xls file on Ubuntu. I am using VS Code with C#. Here is the code: var stream = File.Open(filePath, mode: FileMode.Open, access: FileAccess.Read); var reader = ExcelReaderFactory.CreateReader(stream); I…
Dalton Cézane
  • 3,672
  • 2
  • 35
  • 60
58
votes
9 answers

Export to xls using angularjs

I am working on angular js app and I stuck in a situation in which I have to export data to Xls using angular js. I have searched a lot on the internet for export functionality or any library for angular js so I can do that or at least I can get the…
w3uiguru
  • 5,864
  • 2
  • 21
  • 25
57
votes
14 answers

xls to csv converter

I am using win32.client in python for converting my .xlsx and .xls file into a .csv. When I execute this code it's giving an error. My code is: def convertXLS2CSV(aFile): '''converts a MS Excel file to csv w/ the same name in the same…
Lalit Chattar
  • 1,914
  • 8
  • 27
  • 49
52
votes
3 answers

.NET Excel Library that can read/write .xls files

I'm looking for an Excel library which reads/writes .xls (not .xlsx) files. I'm using excellibrary but it's very buggy and I can't seem to open the files I create. The issue has been known for almost a year and hasn't been fixed yet. I've seen in…
Ozzah
  • 10,631
  • 16
  • 77
  • 116
48
votes
9 answers

Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))

I am trying to convert a .xls file to an .xlsx file on the server-side using Microsoft.Office.Interop.Excel.Workbook class as follows: workBook.SaveAs("FILENAME_HERE", XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, Type.Missing,…
Tamas Ionut
  • 4,240
  • 5
  • 36
  • 59
40
votes
3 answers

Converting JSON to XLS/CSV in Java

Does anyone have any sample Java code to convert a JSON document to XLS/CSV file? I have tried to search on Google but to no avail.
BachLover2342
  • 417
  • 1
  • 4
  • 3
35
votes
2 answers

Reading from src/main/resources gives NullPointerException

In my Maven project, I have a xls file in src/main/resources. When I read it like this: InputStream in = new FileInputStream("src/main/resources/WBU_template.xls"); everything is ok. However I want to read it as InputStream with…
dutchman79
  • 483
  • 2
  • 6
  • 13
34
votes
5 answers

How to convert Excel XLS to CSV using PHP

Can anyone guide me how to convert XLS to CSV using PHP? I have excel spread sheet which contains a list of documents, I want to convert this with CSV format using PHP.
RAAAAM
  • 3,378
  • 19
  • 59
  • 108
1
2 3
…
99 100