private void SalesBudget(ExcelCF tt, Excel.Worksheet ws, string item, string PeriodID)
        {
            ws = tt.GetWorksheet(tt.wb, item);            if (ws != null)
            {
                object[,] valuein = null;
                int x = tt.GetY(ws, "*$col");//获取colX轴
                int y = tt.GetX(ws, "*$row");//获取rowY轴                System.Data.DataTable dt = null;
                dt = DevicePutInOutInfoUtility.Instance.DeviceSalesBudget(PeriodID);                if (x != 0 || y != 0)
                {
                    Excel.Range r = null;
                    r = (Range)tt.GetCellsRangeforXY(ws, 4, 1, y - 1, x - 2);
                    valuein = r.Formula;
                    for (int i = 1; i < y - 3; i++)
                    {
                        if (valuein[i, 3] != null && valuein[i, 3] != "")
                        {
                            DataRow[] arrayDR = dt.Select("Item = '" + valuein[i, 3] + "'");                            foreach (DataRow arr in arrayDR)
                            {
                                valuein[i, 3] = arr[1].ToString();
                                valuein[i, 4] = arr[2].ToString();
                                valuein[i, 5] = arr[3].ToString();
                            }
                        }
                        if (valuein[i, 8] != null && valuein[i, 8] != "")
                        {
                            DataRow[] arrayDR = dt.Select("Item = '" + valuein[i, 8] + "'");                            foreach (DataRow arr in arrayDR)
                            {
                                valuein[i, 8] = arr[1].ToString();
                                valuein[i, 9] = arr[2].ToString();
                                valuein[i, 10] = arr[3].ToString();
                            }
                        }
                    }
                }
                tt.SetCellsValue(ws, valuein, 4, 1, y - 4, x - 2);
            }
        }本地没错误,放服务器就报错