对Excel的Table排序如何多线程

hoolooday 2012-11-19 10:08:38

  Parallel.ForEach(listSheets, (xlWorkSheet1) =>

                {









                    //  Excel.Worksheet xlWorkSheet1 = (Excel.Worksheet)excelbk.Worksheets["Sheet1"];

                    xlRange = (Excel.Range)xlWorkSheet1.Cells[xlWorkSheet1.Rows.Count, 1];

                    lock (xlRange)

                    {

                        //   nRows = (long)xlRange.get_End(Excel.XlDirection.xlUp).Row;

                        nRows = xlWorkSheet1.UsedRange.Cells.Rows.Count;

                        xlRange = (Excel.Range)xlWorkSheet1.Rows["5:" + nRows, Type.Missing];

                        xlRange.Sort(xlRange.Columns[clnum1, Type.Missing], Excel.XlSortOrder.xlAscending,

                                                xlRange.Columns[clnum2, Type.Missing], Type.Missing, Excel.XlSortOrder.xlAscending,

                                                Type.Missing, Excel.XlSortOrder.xlAscending,

                                                Excel.XlYesNoGuess.xlNo, Type.Missing, Type.Missing,

                                                Excel.XlSortOrientation.xlSortColumns,

                                                Excel.XlSortMethod.xlStroke,

                                                Excel.XlSortDataOption.xlSortTextAsNumbers,

                                                Excel.XlSortDataOption.xlSortNormal,

                                                Excel.XlSortDataOption.xlSortNormal);



                        Console.WriteLine("Sheet{0} have been sorted", xlWorkSheet1.Name);

                    }

                });