Export Excel without having Excel

[tbohon]

Are there any tools out there, free or to be purchased, that will allow me to export an Excel file to, e.g., CSV format without having a copy of Excel installed?

 

[bkclaw113]

If you have Microsoft Access you should be able to import the data into access and then export it back out in a different format

 

[tbohon]

I do but the system we're working with - a Citrix farm - would then have to have Access licenses for each of the 32+ processors - same as for Excel.

Problem is that reports from the software are displayed in Excel - we need some way to read them without having to buy 32+ licenses for Excel. If we could guarantee that only x number of people viewed and could somehow direct them to specific processors, it wouldn't be so bad ... but, in a load balanced Citrix farm with up to 100 folks accessing the system at random times ... I 'spect it's gonna get expensive for the boss! <g>

Thanks for the input - appreciate it.

 

[FredPeters]

I may be splitting hairs here, but in order to export something, don't you have reside there.
In order to export an Excel file, don't you have to be in Excel?
How did you open the excel file?
you should be able to open it in any good word processing program and save it as a delimited file.
Fred

 

[ETID]

You could request from whoever is generating the excel file, to please save your copy in text or csv format.

 

[tbohon]

All good comments ... however, the program generating the Excel report from their (very large) database system can only send it out in Excel format - a design decision which the company who wrote it isn't likely to change right now.

As to residing within Excel, perhaps I mis-spoke. What I need to do is find a tool which can read an .XLS file and export it into something else (Word document, etc.) so that individual users who don't have Excel on their workstations connected to this database system can see the report. What I DON'T want to do is have to purchase Excel licenses for some 200+ folks who &quot;might&quot; be using the Citrix farm at any given time ... it'll probably be more like 5-10 but which 5-10 ... ?????

Am looking at StarOffice 6.0 - basically free and we might be able to use it in a limited fashion (if management lets us use 'non standard' software for this application).

Again, thanks for the comments and ideas.

Tom

 

[Guest_imported]

Buy one license, put it on the server and write a script that automatically reads the file and drops it to another format.

/Y

 

If all machines have Word, then you should be able to open the excel sheets with Word.


Have you tried to open these files with Word?

right click on the icon and choose open with....then select word from the list. check the always open with this application check box.