Exporting To Excel

  • Thread starter Thread starter Paul Cavacas
  • Start date Start date
P

Paul Cavacas

I have a routine that takes a DataTable and exports it to
Excel. Works fine and dandy on my machine, which has the
Office 11 Beta on it. But it of course doesn't work on
anybody else's machine because the have Office 2000 on
there machine. How can I make this export function work
with Office 2000.
 
-----Original Message-----
I have a routine that takes a DataTable and exports it to
Excel. Works fine and dandy on my machine, which has the
Office 11 Beta on it. But it of course doesn't work on
anybody else's machine because the have Office 2000 on
there machine. How can I make this export function work
with Office 2000.
.
Click to expand...
 
I have a routine that takes a DataTable and exports it to
Excel. Works fine and dandy on my machine, which has the
Office 11 Beta on it. But it of course doesn't work on
anybody else's machine because the have Office 2000 on
there machine. How can I make this export function work
with Office 2000.
Click to expand...

You can do two things:

1) Cheap'n'ditry: why don't you just create a tab-delimited text file,
and give it an .xls extension? As long as you don't need any special
formatting, this is the quickest way to export your data to Excel.
Excel (any version!) will happily load the "fake" .xls and display
your data, no hassle, no fuss

2) IF you need more power, e.g. control over layout and other stuff,
you'll probably need to revert to some third-party tools, such as
"ExcelWriter" by SoftArtisans:

http://excelwriter.softartisans.com/

They work even without having Excel installed on that machine, and
they create native .XLS files directly - again, you can target any
version you might need to support.

Marc
================================================================
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch
 
Back
Top