Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [xls]

xls is the file extension of the standard format of Microsoft Excel through version 11 (Excel 2003).

1
vote
1answer
35 views

Can't change txt files to open with anything but wordpad [duplicate]

I want to change txt files to open with a specific .xls it used to work but for some reason now it won't save anymore when I set the .xls program as the default. It's a serious pain to have to open ...
0
votes
1answer
80 views

Problems sharing .xls spreadsheet via WhatsApp

I've saved a spreadsheet in the old format .xls on my MacBook and shared it via WhatsApp. Some of the recipients have informed me that the file is not usable both by Android and iPhone smartphones....
0
votes
0answers
27 views

How can I convert SAS data files into something simple like Excel data using Perl?

I am new to Perl.I know how to do the same thing using R and Python but I am unable to do so in Perl. My requirement says it has to be specifically in Perl.
1
vote
1answer
3k views

Convert xls to pdf using command prompt

I have to convert a lot of .xls and .xlsx files to .pdf files. Is there a way to convert faster all the files using the command prompt?
1
vote
4answers
51 views

Whats the simplest way to add lines to an Excel XLS?

I have a list of 300 items in an Excel XLS. One item per row. I would like to have 5 items for each row. So, for example, my current system is : Item 1 Item 2 Item 3 I would like to make it Item ...
0
votes
1answer
1k views

Excel 2013 .xlsx files won't open

I am trying to open a file that I have created myself via a web API that I made for PHP. The file is created and downloads successfully but when I go to open it, I get this error: Excel cannot open ...
-2
votes
1answer
67 views

Convert XLS file to TXT with desired spaces

I want to convert XLS file to a TXT file with desired spaces. I have an xls file with a large number of rows and a few number of columns. Here is a sample file I need as the output file after ...
1
vote
3answers
3k views

Need a batch script to copy data from A.csv to B.xls

I'm a newbie to batch scripting and need help. I want to copy the contents of a csv file A.csv to the first worksheet named "GenData" in a existing XLS file B.xls. B.xls contains some macros in it's ...
1
vote
1answer
3k views

using powershell, is it possible to convert an XLSX file to XLS?

As the title states, is this possible? I found some scripts for XLS to XLSX, but not the other way around. Can this be done with powershell? Thanks
17
votes
5answers
94k views

How do I stop Excel from converting value 0503E000 to 5.03E+02 automatically?

Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV I tried to convert it to text number and general but after i save it and reopen it again it goes back to 5.03E+02 How do I ...
0
votes
1answer
555 views

xls how can SUMPRODUCT handle boolean?

i have a formula here =sumproduct((sheet1!$A$2:$A$3000=$A69)*(sheet1!$E$1:$F$1=$D69)*(sheet1!G$2:G$3000)*(sheet1!$E$2:$F$3000)) it produce some value, BUT when i execute this =(sheet1!$A$2:$A$...
1
vote
3answers
4k views

Microsoft Office 2010 Excel will not open two xls

I am using Windows 7 and Windows 8 and I see the following behavior with Microsoft Office 2010. Create two Excel files, say a.xls and b.xls Open a.xls by double clicking it. After the file is ...
3
votes
0answers
10k views

How to create a vcf file from xls file containing mobile contacts

I need to transfer contacts from my old phone to the new one. I have an xls file from my contacts, but my new phone only imports vcf files. What can I do to convert the xls file to vcf?
1
vote
0answers
1k views

Why recovered .xls and .doc files show as symbols?

I formatted an NTFS drive (and re-installed windows) which had some important .doc and .xls files, I used 2 recovery software and both recovered my files but seem to be corrupt, when opened they ...
2
votes
2answers
760 views

By use of what could an .xlsx file be collaboratively edited?

This question comes from a question asked yesterday here, the comments of which lead me to believe this separate question might be appropriate. To explain again: a small group of individuals have ...
0
votes
1answer
211 views

Publish XLS document that has visual basic code to a web site

I have a requirement that was asked of me. We have an Excel document that has visual basic code attached to it and it does some computing. The user wants to publish this document onto an intranet site....
0
votes
0answers
2k views

Open source, command-line tool to convert Excel .xls to .xlsx without Excel

I'm looking for an open source, command-line tool to convert files from the old, binary Excel ".xls" format to the new (Excel 2007) Open XML .xlsx, without Excel installed, on a Windows PC. Ideas? ...
1
vote
2answers
1k views

Table exported in XLS format doesn't show anything in Libre-Calc

A web application exports some tabular data in XLS format. The XLS file shows the content alright when opened in MS-Office but shows blank sheet when opened in Libre-Calc. My versions: Ubuntu 11.10 ...
1
vote
1answer
3k views

Batch XLS to CSV Converter

Using Windows, I need a script to convert all the (xls) files of a directory to csv.
2
votes
2answers
1k views

unable to open excel sheet in linux

I am not able to open excel file which is generated from java web application in Linux. The file is opening in Windows but not in Linux. I am not using Open Office. I have two different applications ...
1
vote
2answers
24k views

Color drop down in Excel cell (with no text)? e.g. bgcolor = Red-Green-Amber-unknown

I have an Excel sheet that I'm using to keep track of the status of certain things. I want to have a column which consists of cells containing a repeated drop down that allows you to select (as ...
1
vote
2answers
1k views

Dutch Excel displaying dates in different formats even though they are in the same format in the file - is there a way to ensure consistency?

We create files with dates in them in the form dd/mmm/yyyy. These spreadsheet files are in html format with extension .xls (Further info: created via HttpContext.Current.Response.ContentType = "...
14
votes
5answers
121k views

Difference between CSV and XLS files?

What are CSV and XLS(Microsoft or OpenOffice) files ? What is the main difference between these two files ?
1
vote
1answer
3k views

Convert Microsoft Works database files to something that can be read in Excel

I have many .wdb files created with Microsoft Works. I need to open them but I don't have Microsoft Works. Can anyone recommend a way to open the files in Excel?
0
votes
1answer
7k views

Possible to attach XLS inside DOC file?

Not sure if this is possible in a .DOC (I hope it is). I have seen this done it .PPTs I would like to include reference .XLS documents inside one .DOC file, doing an INSERT > FILE only inserts ...
3
votes
2answers
5k views

Convert XLS to CSV in Unix

Is there an easy to compile plain C XLS (Excel sheet(s)) to CSV (or other text delimited format) converter for Linux or the BSDs that doesn't rely on Perl and installing a bunch of module perl modules ...