08-02-2008, 07:23 PM
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
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
;;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