MS Excel Spreadsheets and UNIX

Dev Shed Forums Sponsor:

September 19th, 2001, 01:16 PM

devman

Junior Member

Join Date: Jul 2001

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

MS Excel Spreadsheets and UNIX

Hi,
I have a UNIX nightly process that needs to email a report to Windows users. Does anyone now how to generate an excel spreadsheet on the UNIX platform??

September 19th, 2001, 01:50 PM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 8th Plane (8500 - 8999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 8,527

Time spent in forums: 3 Months 1 Week 1 Day 3 h 19 m 49 sec
Reputation Power: 537

I think that the best way should be to generate a flat file (or better an xml file) and then import the data in excel/access thru a macro.
On sourceforge there is a php class that generates excel files from mysql, maybe you can adapt it.
Hope this helps, and please report about your experience!

__________________
My blog
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)

Viewing: Dev Shed Forums > Other > Dev Shed Lounge > MS Excel Spreadsheets and UNIX

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump