数据导入Excel 生成图表，出现乱码, 急!!!!

cynthiabx 2009-02-23 11:31:30

是这样的
我要将一段sql的执行结果导入到Excel中并生成图表
但是在导出后面坐标轴上文字会出现乱码，我的机器是好的，但是到了测试环境就会出问题，请问是什么原因呢？谢谢
代码如下：



            ApplicationClass myApplication = null;

            Workbook myWorkBook = null;

            Worksheet mySheet = null;

            string OLDDBConnectionString = @"OLEDB;Provider=MSDAORA.1;Password={0};Persist Security Info=True;User ID={1};Data Source={2};

                    Current Language=us_english;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;

                Workstation ID=***[我的机器名];Use Encryption for Data=False;Tag with column collation when possible=False";



           OLDDBConnectionString = string.Format(OLDDBConnectionString,

                this.m_ImageInfo.DataSource.Password,

                this.m_ImageInfo.DataSource.UserName,

                this.m_ImageInfo.DataSource.Database);

            try

            {

                myApplication = new ApplicationClass();

                myWorkBook = myApplication.Workbooks.Open(this.m_ImageInfo.TemplateFileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);                

                mySheet = (Worksheet)(myWorkBook.Worksheets[1]);



                OLEDBConnection myOLEDBConnection = myWorkBook.Connections[1].OLEDBConnection;



                myOLEDBConnection.BackgroundQuery = false;

                myOLEDBConnection.CommandText = this.m_ImageInfo.DataSource.Sql;

                myOLEDBConnection.CommandType = XlCmdType.xlCmdSql;

                myOLEDBConnection.Connection = OLDDBConnectionString;

                myOLEDBConnection.RefreshOnFileOpen = false;

                myOLEDBConnection.SavePassword = false;

                myOLEDBConnection.SourceConnectionFile = "";

                myOLEDBConnection.ServerCredentialsMethod = XlCredentialsMethod.xlCredentialsMethodStored;

                myOLEDBConnection.AlwaysUseConnectionFile = false;





                myWorkBook.Connections[1].Refresh();

                // Set multi-language title.

                PivotTable myPivotTable = (PivotTable)mySheet.PivotTables(1);



                for (int i = 0; i < this.m_ImageInfo.TitleLanguageList.Count; i++)

                {

                    ((PivotItem)(myPivotTable.DataPivotField.PivotItems(i + 1))).Caption = this.m_ImageInfo.TitleLanguageList[i];

                }

                imageName = Guid.NewGuid().ToString() + "." + this.m_ImageInfo.ImageType.ToLower();

                // Check output directory.

                if (!Directory.Exists(this.m_ImageInfo.ImageFilePath))

                    Directory.CreateDirectory(this.m_ImageInfo.ImageFilePath);





                Chart activeChart = ((ChartObject)mySheet.ChartObjects(1)).Chart;

                Axis valueAxis = (Axis)(activeChart.Axes(XlAxisType.xlValue, XlAxisGroup.xlPrimary));

                if (valueAxis.HasTitle)

                {

                    valueAxis.AxisTitle.Text = this.m_ImageInfo.YAxisTitle;

                }

                Axis categoryAxis = (Axis)activeChart.Axes(XlAxisType.xlCategory, XlAxisGroup.xlPrimary);

                if (categoryAxis.HasTitle)

                {

                    categoryAxis.AxisTitle.Text = this.m_ImageInfo.XAxisTitle;

                }

                

                ((ChartObject)mySheet.ChartObjects(1)).Width = this.m_ImageInfo.ImageWidth;

                

                ((ChartObject)mySheet.ChartObjects(1)).Chart.Export(this.m_ImageInfo.ImageFilePath + @"\" + imageName, this.m_ImageInfo.ImageType, Missing.Value);