Roger,
Just noticed something. Had a client running a process at night on server using the scheduler, no excel installed or available. Sending an excel file to his customer on daily activity via email. We were using csv but he did not like the non-formatted fields. We just tried just sending the dbf file, but renamed it to .xls format. Excel opened without a problem with the proper formatting.
Never knew we could do that by just renaming, although in our system the user normally want to open the spreadsheet when created.
Fred
Omni
Excel
-
Eugene Lutsenko
- Posts: 1649
- Joined: Sat Feb 04, 2012 2:23 am
- Location: Russia, Southern federal district, city of Krasnodar
- Contact:
Re: Excel
You don't even have to rename it. Excel just opens dbf. It has its own Converter. Versions of Excel before 2007 and recorded the xls file as dbf (save as), and later versions cannot.
Re: Excel
Knew that, but emailing it to a 3rd party could be an issue, but at the least it would be confusing..they would not know what a dbf file is, and unsure if their email would block it. Or, if they clicked to open their windows system would not know what to open it with
Fred
Fred
-
Eugene Lutsenko
- Posts: 1649
- Joined: Sat Feb 04, 2012 2:23 am
- Location: Russia, Southern federal district, city of Krasnodar
- Contact:
Re: Excel
That is interesting to know that a DBF can be renamed as XLS and Excel will open it. Thanks.
The eXpress train is coming - and it has more cars.