Ranorex Forum

Code: Select all

 /*
 * Created by Ranorex
 * User: Drake
 * Date: 4/19/2016
 * Time: 6:00 AM
 * 
 * To change this template use Tools | Options | Coding | Edit Standard Headers.
 */
using System;
using System.Collections.Generic;
using System.Text;
using System.Text.RegularExpressions;
using System.Drawing;
using System.Threading;
using WinForms = System.Windows.Forms;
using Ranorex;
using Ranorex.Core;
using Ranorex.Core.Testing;
using Microsoft.Office.Interop.Excel;

namespace lab
{
    /// <summary>
    /// Description of ExcInt.
    /// </summary>
    [TestModule("418266C8-4FB9-4B06-A823-044A2DFEFBDF", ModuleType.UserCode, 1)]
    public class ExcInt : ITestModule
    {
        /// <summary>
        /// Constructs a new instance.
        /// </summary>
        public ExcInt()
        {
            // Do not delete - a parameterless constructor is required!
        }

        /// <summary>
        /// Performs the playback of actions in this module.
        /// </summary>
        /// <remarks>You should not call this method directly, instead pass the module
        /// instance to the <see cref="TestModuleRunner.Run(ITestModule)"/> method
        /// that will in turn invoke this method.</remarks>
        void ITestModule.Run()
        {
            Mouse.DefaultMoveTime = 300;
            Keyboard.DefaultKeyPressTime = 100;
            Delay.SpeedFactor = 1.0;
            
            String dtPath = "d:\\ranorexTutorial\\dtLab.xlsx";
            String dtSheet = "labSheet01";

            Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook objBook = objExcel.Workbooks.Open(dtPath);
            var objSheet = objBook.Worksheets[dtSheet];
            System.Windows.Forms.MessageBox.Show(objSheet.Cells(2, 2).Text);
        }
    }
}

Code: Select all

            String dtPath = "d:\\ranorexTutorial\\dtLab.xlsx";
            String dtSheet = "labSheet01";
            Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook objBook = objExcel.Workbooks.Open(dtPath);
            Excel.Worksheet objSheet = (Excel.Worksheet)objBook.Worksheets[dtSheet];
            Excel.Range objRange = (Excel.Range)objSheet.Cells[2,2];
            System.Windows.Forms.MessageBox.Show(objRange.Value.ToString());
            objBook.Close();