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
0
votes
1 answer

xlswrite overwrite existing file

I have 53 xls table (ch_1, ch_2, ...) and then use them as a input for Neural Network. After that write the NN result in a new xls and csv. clc clear all files=dir('*.xls'); for i=1:length(files(:,1)) aa=xlsread(files(i).name); …
Hase
  • 11
  • 3
0
votes
0 answers

Opening xls files using xlrd without pathname

Usually the xlrd library uses pathname/filename to read the file as follows workbook = xlrd.open_workbook('some_filename.xls') But in my flask project i am dealing with an uploaded file.So i got the file as xlsfile = request.files['file'] So how…
nidhinpd
  • 93
  • 1
  • 4
0
votes
1 answer

Changing the algorithm from writing to reading .txt or .xls to JTable

Could you tell me how can I load JTable from .txt or .xls file? I used the algoriithm below to save JTable content as .xls: public void saveTable()throws Exception { BufferedWriter bfw = new BufferedWriter(new FileWriter("Data.xls")); for(int…
KumarHero
  • 3
  • 1
  • 1
0
votes
0 answers

PHPexcel Read single cell in xlsx

Ive been trying to wrap my head around using PHPexcel and would like ot know if there is any other simpler solution. Using PHPexcel i am able to load a standard .xsl file and pick the exact cell i need to import. $code = $data->val(2,2,0); echo…
renfley
  • 146
  • 1
  • 8
0
votes
1 answer

Xlsread returning zero values....?

I am getting zero values while using xlsread command in MATLAB.I am using a real world dataset taken from UCI repository which has got both integer and float values. [Train,textData,rawData] =…
Pooja
  • 59
  • 3
  • 8
0
votes
1 answer

phpexcel-generated xls file open as plain xml linux

I'm developing a site using YII, PHP. I've been using PHPexcel in some part of my web and it works just fine. In most cases the file created by phpexcel can be opened by libreoffice. But in one controller it generate a fine xls file. The file can…
Ebed Kharistian
  • 82
  • 1
  • 7
0
votes
1 answer

Writing table contents to xls from vb.net

I have a program with an option to write db contents to an excel spreadsheet. This functionality is contained on a page called 'Search_aspx'. Response.ClearContent() Response.Charset = "" Response.ContentType =…
mrwienerdog
  • 815
  • 3
  • 18
  • 35
0
votes
0 answers

/test.xlsx: open failed: EROFS (Read-only file system)

I am developing an android application where I need to pass some records to .xls or .xlsx file. I did everything to pass values from my java class to excel sheet in android. But when I run the application I am getting this error /test.xlsx: open…
Naresh Kumar Koppera
  • 417
  • 1
  • 6
  • 18
0
votes
1 answer

Why is my XSL stylesheet for-each not functioning, repeats text

I have reviewed the questions that may already have your answer section, and the solutions did not work. I am pretty new to XML stylesheets, I have an XSL and within my for each loop, the data keeps repeating, when I am trying to get all the text…
Onlytito
  • 167
  • 1
  • 2
  • 17
0
votes
1 answer

PHP returning result in binary format

I'm exporting data from php array to xls file. Everything works great if I'm just writing them into file with echo like this: function toExcel($arrayOfData) { $data = null; $rowCounter = 0; if(is_array($arrayOfData) === true) { …
Michal Takáč
  • 1,005
  • 3
  • 17
  • 37
0
votes
1 answer

Copy, paste and save as a .xls file

I need to define cell ranges to copy and paste in new worksbook under the name of column B (i.e. Alda.xls). How can I do it in VBA? Thanks in advance. A B C D E F G H I 1999 ALDA 1/14/1999 12:00…
user3408139
  • 197
  • 1
  • 12
0
votes
1 answer

mysqli export to xls issue

I have troble geting this work and I can't figure it out what is the issue. I download a xls file, but it doesent opens. I had a mysql script like this, working, and I tried to convert it into mysqli and probably something is wrong... Thanks in…
Robert Rouge
  • 259
  • 1
  • 2
  • 9
0
votes
0 answers

PHPExcel Writer .xls file generates Excel error ... how can I change the extension to .csv?

I'm using a Wordpress plugin, wpdatatables, that uses PHPExcel to produce pdf, csv, and Excel file exports. Anyway, when downloading an .xls file from my website, when I open it .. Excel gives me the error “The file format and extension of…
user45867
  • 887
  • 2
  • 17
  • 30
0
votes
1 answer

add column with cvs.writer

I have a script which opens a cvs and writes it out again (with a different name) without some columns I don't need. source = outname with open(source, "rb") as source: rdr = csv.reader(source) with open("import2SFDC.csv", "wb")…
f0rd42
  • 1,429
  • 4
  • 19
  • 30
0
votes
4 answers

Python - read xls -> manipulate -> write CSV

im trying to archive the following: input: xls file output: csv file I want to read the xls and do some manipulations (rewrite the headers (original: customernumer, csv needs Customer_Number__c), removing some columns, etc. Right now I'm already…
f0rd42
  • 1,429
  • 4
  • 19
  • 30
1 2 3
…
99
100