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

learn more… | top users | synonyms

-2
votes
1answer
13 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
73 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
1answer
253 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
4answers
261 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
46 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 ...
1
vote
3answers
410 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 ...
1
vote
0answers
1k 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?
0
votes
0answers
39 views

xls2csv skipping bool values when converting

I'm attempting to use catdoc -> xls2csv on an Ubuntu 14.04.1 OS to convert and .xls file to a .csv file. All of the values are converting correctly except in the last column which contain TRUE/FALSE ...
0
votes
0answers
56 views

How do I make an xls sheet into a xml doc?

How do I make an xls sheet into a xml doc? I need to upload an xml attachment into an smart pdf (for declaring corporate income tax purposes) The extension created when filling the form (pdf) is an ...
1
vote
0answers
674 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
486 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
176 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 ...
0
votes
0answers
1k 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
1k 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
964 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
10k 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
1answer
906 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 = ...
3
votes
7answers
4k views

How do I convert .txt into .xls?

I have a .txt file which holds some links for a website. It's about 560 links. I'm trying to convert my .txt file into an Excel file with a column name. If you have suggestions please reply.
5
votes
5answers
56k 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 ?
2
votes
1answer
2k 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 utility, converter or procedure to open the files in Excel?
0
votes
1answer
5k 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
4k 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 ...