Exporting To Excel

[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.

 

[Brian P. Hammer]

Do you have any code that goes along with this post?

Brian Hammer

 

[pouya]

-----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.
.

 

[Marc Scheuner [MVP ADSI]]

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.

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