1
vote
0answers
806 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? ...
2
votes
2answers
1k views

Change line endings and delimiter format (permanently) when saving to CSV from Excel

I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to "," Is there ...
1
vote
1answer
132 views

How can I make Excel NOT ask about saving to a specific file format?

We have a VBScript called from desktops that writes start / end times to a tab delimited file (with an .xls extension) as a timelog. When someone opens this file in Excel, and then wants to close it, ...
-1
votes
3answers
6k views

How do you save an Excel document as a Word document?

I was hoping someone could tell me how to save a Microsoft Office Excel document to the Microsoft Office Word document format?
2
votes
2answers
436 views

Excel version confusion

I got an Excel file, actually it's a zip file which contains many folders and files including sheets in XML format. When I try to open it, Excel 2003 says "The file is not in a recognizable format" ...
11
votes
2answers
5k views

True difference between Excel CSV and Standard CSV

What is the true difference between an Excel CSV and a standard CSV? For example, when handling columns with line breaks inside one cell, how do they encode it differently?
2
votes
1answer
218 views

Is Workbook.FileFormat available to the Excel UI (specifically when the file type can't be saved)

As a programmer I eventually located the file type of a .d extension file loaded successfully by Excel 2007 by interrogating Workbook.FileFormat via VBA, but can a normal user determine it is a DBF4 ...
3
votes
4answers
1k views

Export to csv options using Numbers

I'm using Numbers on my Mac at the moment and exporting to a CSV file. Is there a way to enclose every value with ""? For example I'm getting the csv file like this: 1,2,3,4,5,6,7,8,9 When I ...
-1
votes
3answers
839 views

Convert file for XLS to TXT format

I renamed a .xls file to .txt file but the .txt file shows like this: ...