My Computer Forum Computer Science Forum

Go Back   My Computer Forum > Computer Forum > Computer Software

Computer Software Computer Software - Microsoft Windows, Apple OS X, Microsoft Office, Adobe Creative Suite, AntiVirus Software, etc.


Reply
 
LinkBack Thread Tools Display Modes
August 26th, 2011, 02:17 PM   #1
Site Founder
 
julien's Avatar
 
Joined: Dec 2007
Posts: 414
Convert OpenOffice files to Excel files

Hello everybody,

Could anyone please tell me if there is any reliable way to convert an openoffice file (.odt) into an Excel file (.xlsx) without any loss of data ? I've already tried to save my OpenOffice files as Excel files (it's proposed by OpenOffice) but I lose information (mostly spreadsheet formatting) every time ...
Any idea ?
julien is offline  
 

My Computer Forum is free to register and we welcome everyone!

September 16th, 2011, 11:27 AM   #2
 
Joined: Sep 2011
Posts: 13
Re: Convert OpenOffice files to Excel files

Quote:
Originally Posted by julien
Hello everybody,

Could anyone please tell me if there is any reliable way to convert an openoffice file (.odt) into an Excel file (.xlsx) without any loss of data ? I've already tried to save my OpenOffice files as Excel files (it's proposed by OpenOffice) but I lose information (mostly spreadsheet formatting) every time ...
Any idea ?

I thought it was simple a matter of saving it. However, if it doesn't work well perhaps try writing a script to convert it. Not sure if it would be best to run the script in openoffice, power shell or excel. My preference would be powershell but working externally won't give as many features to aid coding.
John Creighton is offline  
October 4th, 2011, 11:53 PM   #3
Site Founder
 
julien's Avatar
 
Joined: Dec 2007
Posts: 414
Re: Convert OpenOffice files to Excel files

Well, I guess the most difficult would not be to learn the powershell but rather to understand the structure of Excel files and write the mapping OpenOffice documents -> Excel files
julien is offline  
Reply

  My Computer Forum > Computer Forum > Computer Software

Tags
convert, excel, files, openoffice



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving files/adding text to files (VB/*.bat) Doug4347 Computer Science 0 December 17th, 2012 11:04 AM
In Excel, workbook that can be used by windows based pc? ? Lizzz Computer Software 1 July 29th, 2011 01:35 PM
openoffice is good yes? bakedpotato Computer Software 8 November 9th, 2010 01:42 PM
.bat files not apearing on comp when i save with notepad?? cyber snake Tech Support 1 May 6th, 2010 03:10 AM





Copyright © 2017 My Computer Forum Forum. All rights reserved.