By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,534 Members | 950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,534 IT Pros & Developers. It's quick & easy.

Sorting an excel spreadsheet

P: n/a
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

Mar 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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:
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


Mar 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.