コード例 #1
0
ファイル: main.cs プロジェクト: divyang4481/dotnetabt
        private void addNewFileToolStripMenuItem_Click(object sender, EventArgs e)
        {
            AddFile1 newFile = new AddFile1();

            //newFile.labelX3.Text = newFile.labelX3.Text + "-" + treeViewproject.SelectedNode.Text;
            newFile.ShowDialog();
            main main = new main();

            Excel.Application xlApp = default(Excel.Application);
            Excel.Workbook xlWorkBook = default(Excel.Workbook);
            Excel.Worksheet xlWorkSheet = default(Excel.Worksheet);

            FileTreeNode treeNode = new FileTreeNode();
            treeNode.Text = newFile.txtName.Text + "." + newFile.cboType.Text;
            treeNode.Tag = CurrentProjectPath + @"\" + treeViewproject.SelectedNode.Text + @"\" + treeNode.Text;
            treeNode.Name = "File";
            treeNode.ImageIndex = newFile.cboType.SelectedIndex;
            newFile.Close();
            if (newFile.txtName.Text != "")
            {
                treeViewproject.SelectedNode.Nodes.Add(treeNode);
                treeViewproject.SelectedNode.ExpandAll();
                //@new new1 = new @new();
                //string path = new1.ProjectPath;
                //string fName = path + @"\" + treeViewproject.SelectedNode.Tag + @"\" + treeNode.Tag;
                string fName = treeViewproject.Nodes[0].Tag + @"\" + treeViewproject.SelectedNode.Text + @"\" + treeNode.Text;
                 //const string fName =@"F:\abc.xls";
                try
                {
                    object misValue = System.Reflection.Missing.Value;
                    xlApp = new Excel.Application();
                    xlWorkBook = xlApp.Workbooks.Add(misValue);
                    xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
                    xlWorkBook.SaveAs(fName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
                    xlWorkBook.Close(true, misValue, misValue);
                    xlApp.Quit();
                    releaseObject(xlWorkSheet);
                    releaseObject(xlWorkBook);
                    releaseObject(xlApp);
                }
                finally
                {
                    if (xlApp != null)
                        releaseObject(xlApp);
                    if (xlWorkBook != null)
                        releaseObject(xlWorkBook);
                    if (xlWorkSheet != null)
                        releaseObject(xlWorkSheet);
                }
                //if (System.IO.File.Exists(fName))
                //{
                //    //if (System.Windows.Forms.MessageBox.Show("Would you like to open the excel file?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                //    //{
                //        //try
                //        //{
                //        //    System.Diagnostics.Process.Start(fName);
                //        //}
                //        //catch (Exception ex)
                //        //{
                //        //    System.Windows.Forms.MessageBox.Show("Error opening the excel file." + Environment.NewLine +
                //        //      ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
                //        //}
                //    //}
                //}

               //CompoundDocument _doc = CompoundDocument.Open(fName);
            }
        }
コード例 #2
0
        private void addNewFileToolStripMenuItem_Click(object sender, EventArgs e)
        {
            AddFile1 newFile = new AddFile1();

            //newFile.labelX3.Text = newFile.labelX3.Text + "-" + treeViewproject.SelectedNode.Text;
            newFile.ShowDialog();
            main main = new main();

            Excel.Application xlApp       = default(Excel.Application);
            Excel.Workbook    xlWorkBook  = default(Excel.Workbook);
            Excel.Worksheet   xlWorkSheet = default(Excel.Worksheet);

            FileTreeNode treeNode = new FileTreeNode();

            treeNode.Text       = newFile.txtName.Text + "." + newFile.cboType.Text;
            treeNode.Tag        = CurrentProjectPath + @"\" + treeViewproject.SelectedNode.Text + @"\" + treeNode.Text;
            treeNode.Name       = "File";
            treeNode.ImageIndex = newFile.cboType.SelectedIndex;
            newFile.Close();
            if (newFile.txtName.Text != "")
            {
                treeViewproject.SelectedNode.Nodes.Add(treeNode);
                treeViewproject.SelectedNode.ExpandAll();
                //@new new1 = new @new();
                //string path = new1.ProjectPath;
                //string fName = path + @"\" + treeViewproject.SelectedNode.Tag + @"\" + treeNode.Tag;
                string fName = treeViewproject.Nodes[0].Tag + @"\" + treeViewproject.SelectedNode.Text + @"\" + treeNode.Text;
                //const string fName =@"F:\abc.xls";
                try
                {
                    object misValue = System.Reflection.Missing.Value;
                    xlApp       = new Excel.Application();
                    xlWorkBook  = xlApp.Workbooks.Add(misValue);
                    xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
                    xlWorkBook.SaveAs(fName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
                    xlWorkBook.Close(true, misValue, misValue);
                    xlApp.Quit();
                    releaseObject(xlWorkSheet);
                    releaseObject(xlWorkBook);
                    releaseObject(xlApp);
                }
                finally
                {
                    if (xlApp != null)
                    {
                        releaseObject(xlApp);
                    }
                    if (xlWorkBook != null)
                    {
                        releaseObject(xlWorkBook);
                    }
                    if (xlWorkSheet != null)
                    {
                        releaseObject(xlWorkSheet);
                    }
                }
                //if (System.IO.File.Exists(fName))
                //{
                //    //if (System.Windows.Forms.MessageBox.Show("Would you like to open the excel file?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                //    //{
                //        //try
                //        //{
                //        //    System.Diagnostics.Process.Start(fName);
                //        //}
                //        //catch (Exception ex)
                //        //{
                //        //    System.Windows.Forms.MessageBox.Show("Error opening the excel file." + Environment.NewLine +
                //        //      ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
                //        //}
                //    //}
                //}



                //CompoundDocument _doc = CompoundDocument.Open(fName);
            }
        }