Questions tagged [xls]

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

Filter by
Sorted by
Tagged with
29 votes
8 answers
179k 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 ...
CrashOverride's user avatar
14 votes
5 answers
123k 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 ?
Puru's user avatar
  • 767
3 votes
2 answers
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 ...
dlamblin's user avatar
  • 10.7k
2 votes
2 answers
4k 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 ...
user avatar
2 votes
2 answers
794 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 ...
eichoa3I's user avatar
  • 1,522
2 votes
0 answers
11k 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?
Mehdi Haghgoo's user avatar
1 vote
2 answers
30k 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 ...
adolf garlic's user avatar
  • 2,057
1 vote
1 answer
9k 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
jes516's user avatar
  • 145
1 vote
1 answer
87 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 ...
Matt's user avatar
  • 11
1 vote
2 answers
2k 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 ...
Sri's user avatar
  • 141
1 vote
1 answer
4k 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?
Kwang Mark Eleven's user avatar
1 vote
1 answer
13k 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?
S. Comu's user avatar
  • 85
1 vote
1 answer
4k views

Batch XLS to CSV Converter

Using Windows, I need a script to convert all the (xls) files of a directory to csv.
Isaac Kleinman's user avatar
1 vote
2 answers
2k 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 = "...
Paul H's user avatar
  • 161
1 vote
0 answers
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 ...
Pierre's user avatar
  • 153
1 vote
0 answers
3k 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? ...
Dr. Gianluigi Zane Zanettini's user avatar
1 vote
4 answers
65 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 ...
John Bravo's user avatar
1 vote
3 answers
6k 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 ...
Vink's user avatar
  • 113
0 votes
1 answer
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 ...
Jakub's user avatar
  • 3,171
0 votes
1 answer
876 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....
G. Carbone's user avatar
0 votes
1 answer
2k 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 ...
Can O' Spam's user avatar
0 votes
1 answer
2k views

Accessing a Password-Locked 1997-2003 .XLS?

My father passed away close to a decade ago and I'm trying to access a master file of his that appears to be a 97-2003 password-locked .XLS notebook. None of his known passwords have worked, and I've ...
Medmankms's user avatar
0 votes
3 answers
7k 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 ...
Abby's user avatar
  • 9
0 votes
1 answer
902 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$...
user965347's user avatar
0 votes
1 answer
219 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....
vsmal's user avatar
  • 281
-2 votes
1 answer
399 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 ...
Nilesh Bhoir's user avatar