Sorting an excel spreadsheet

  • Thread starter Thread starter Dwight
  • Start date Start date
D

Dwight

The place I'm working for has a need to sort an excel spread sheet the
contains data from bill of materials. The spreadsheets can be up to
60,000 records.

We had a process that did it in a macro but didn't do it correctly.
Another developer wrote a program in VB.net and did a recursive
hieartical sort. This worked fine for small files, but large files it
took over an hour. The sorting is based on different criteia for each
record type in BOM.

Anyone done something similar or have ideas on how to make this work
quicker?

Thanks
 
Hi Dwight,

I think you are being a little too vague on your problem to get an
effective response. Could you provide a more detailed information of
what you are doing. For instance what are the fields (names, types),
their hierarchy and the respective criteria for ordering (or comparers,
if you have defined some, for instance in the VB program). And what
about the output, is it to be written to excel or can it be written to
a database (access, sqlserver, etc..). Unless you have a remarkably
large number of fields, it should not take more than a few seconds to
do the ordering (this also depends on the ordering algorithm which is
used). It probably takes longer to write back the records... Probably
it would also be useful to take a look at the program you have been
using so far...

-tom

Dwight ha scritto:
 
Back
Top