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
0
votes
2 answers

How can I open a .xlsx file from ASP.Net Server?

I'm trying to open up .xlsx files generated from our servers because I've been requested to change the files from .xls to .xlsx. There was no problem with the old version, they just wanted to upgrade. I've tried and I've searched many tips and sites…
user2105171
  • 11
  • 1
  • 1
  • 6
0
votes
1 answer

PHPExcel - Combine two file in one

I have two xlsx files: first.xlsx and second.xlsx, I would combine this two files in one and color the second part of the last file appended(second.xlsx). What can I do?
Carme
  • 13
  • 1
  • 3
0
votes
2 answers

Force Output from SOLR Query to Download as CSV

I'm using SOLR with a Flask (python) wrapper that makes queries via localhost / HTTP GET. Flask then passes the result back to the user on the net. I'd like to be able to offer users the ability to download their query as a .csv file (instead of…
Josh Usre
  • 674
  • 1
  • 12
  • 35
0
votes
1 answer

How to extract data from one of the sheets in XLS file using POIFS API?

I understand how to use POI API (User Model). However, presently, this is not helpful to me as I'm dealing with XLS files larger than 200 MB in size. In one of the questions here on stack overflow, I learned that I need to use an Event-Driven…
Bharat Nanwani
  • 653
  • 4
  • 11
  • 27
0
votes
1 answer

Create a graphic with xls using Pylab in Python

I'm using Python 3.4.1. I want to create a graphic using xls files instead of csv. How can I do ? Can I create a graphic using xls files without converting them ? from pylab import* name = [] value = [] readFile = open('fichier_test.xls',…
0
votes
2 answers

Loss of bytes and corruption of data while inserting image, xls files into blob using byte array

I wanted to create a generic upload code,which could insert all data ,be it text,images,video files etc into a blob field and retrieve data from the same. I had assumed that converting the file into bytes and then uploading it, and using similar…
I_am_Batman
  • 895
  • 9
  • 21
0
votes
2 answers

Downloading .xls file with Response.WriteFile downloads file with webpage content

I have a simple ASP.NET webpage using VB with a file upload control. The user will upload a .xls and a new .xls file is created in the project directory with a new format and some calculations. This file saves, opens, and displays without an issue.…
H--
  • 95
  • 3
  • 14
0
votes
2 answers

Generate array from CSV file selected by input type file

I want to read the CSV file that I upload using input type file and feed its data into an array. I'm using Angularjs with input type file to read a CSV, xls or xlsx file as follows: HTML:
Tarun Dugar
  • 8,921
  • 8
  • 42
  • 79
0
votes
1 answer

Handling xls & xml in same DGV

My winform application is having a DataGridView (DGV), I'm populating it from an xml file by using ReadXml() and displaying the contents into DGV: 23 Jun 2010 0 Some name of…
gsvirdi
  • 406
  • 2
  • 7
  • 22
0
votes
0 answers

Using Java and Apache POI customizing image size within excel cell

i am using apache poi to extract certain data in xls format. The cell size of each column has been fixed. Now my data is being fetched to each respective cell perfectly,but i want to change the scale of my image being fetched in one cell. I want to…
Sidh
  • 1
  • 2
0
votes
1 answer

xls form for conducting survey using android phone

Am working on an xls survey form which when I loaded onto ODK to look for errors it produced this error"You must have a sheet named(case-sensitive):survey"which I dont quite understand.
0
votes
1 answer

Best way to deal in reading very old xls files

I'm coming across transferring and old app to a new one, some of the reports are generated by some very old desktop app running on old xls files, the new app is build with rails 3.x but the only problem I have is that it keeps on getting an OLE…
Berimbolo
  • 293
  • 2
  • 12
0
votes
1 answer

What are MACROs in CSV or XLS files?

What are Macros in CSV or XLS files ? How to enable or disable them ?
Puru
  • 8,913
  • 26
  • 70
  • 91
0
votes
1 answer

Why does my Excel gets corrupted every time I insert more than 21 users by typing XML or through C#?

I wrote a program than can extract usernames and add them to an excel sheet through xml; however, every time there's more than 21 users, the excel becomes corrupted. If I edit the .xls file through notepad, I can fix it or corrupt it by simply…
Pokarface
  • 41
  • 1
  • 5
0
votes
2 answers

How to find tabular data in Excel sheet

I have a excel file named abc.xls in my c: drive (local computer) , now in that excel file in the first sheet itself there is a table as shown below, TradeRef TMS Deal Date B/S 12 45 DRT 23/97/2014 RTY 23 36 …
erertg ghg
  • 89
  • 1
  • 2
  • 11