Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Row selection
#2
Apparently this doesn't work in the QM Beta 2.3.0.1 yet. I'm sure Gint. will shed some insight. Maybe it is just the computer I'm on, or something else I did, but I get:
Error (RT) in "Exell /443"oExell: 0x80010105, The server threw an exception.

Heres the code that worked in QM Version 2.2.1
Function Exell
Code:
Copy      Help
;;All of this will run hidden...
;;so you won't see a thing happen
;;except for outputting variables in QM.

;;Declares the filepath for Excel file to use
str sfile="$desktop$\Test.xls"

;;Declares the name of the sheet to use
;;Make sure the name of the sheet is correct!!
str sheet="Sheet 1"

;;Works the Magic...doesn't seem to work in QM Beta 2.3.0.1...or I have the something wrong?!?
Excel.Application app._create
Excel.Workbook book=app.Workbooks.Open(_s.expandpath(sfile))
ExcelSheet es.ws=book.Worksheets.Item(sheet)

;;Declare the variable you want for data in QM
str Variable

;;Gets data from Sheet in cell row 1 column 1 and puts it to "Variable"
es.GetCell(Variable 1 1)

;;Puts "New Data" into cell row 1 column 1
es.SetCell("New Data" 1 1)
out Variable

;;Saves the Excel sheet
book.Save

;;Closes the Excel
book.Close


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)