Questions tagged [xls]
xls is the file extension of the standard format of Microsoft Excel through version 11 (Excel 2003).
26
questions
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 ...
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 ?
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 ...
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 ...
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 ...
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?
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 ...
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
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 ...
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
...
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?
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?
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.
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 = "...
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 ...
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?
...
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 ...
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 ...
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 ...
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....
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 ...
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 ...
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 ...
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$...
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....
-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 ...