An issue that has plagued me for a long time was the writing of a dataset to
an array and using that array to write to an excel spreadsheet. For too long
I relied on writing the dataset cell by cell which is fine for small amounts
of data but is horrible when large amounts of data are involved.
The example for writing the data to an array and sending it to a spreadsheet
at http://support.microsoft.com/default...b;EN-US;306022 is great
and where my thinking on this began. It was inadequate however to deal with
datasets and the problems encountered in dynamic data. In all fairness that
was not its intention to teach this in their array example.
Some of my coworkers get angry when I share like in this forum. But if
everyone had that attitude I would have never learned anything.
Most of you experienced guys on here don't need this but arrays in .NET (as
this was my first language I dont know first hand) are confusing to the
beginner. I know they were me for sure.
I am also open to improvements on the code. I will be the first to admit I
don't know everything. There may be mistakes. I wrote it this weekend.
Anyway here is a link that may or may not help you acomplish writing a
dataset via an array to an excel spreadsheet.
I would appreciate knowing if this helped anyone.
Many thanks for all the help the vets there have given me in the last year.
http://www.kjmsolutions.com/datasetarray.htm
