QATTS Technical Docs
2.0.0 Main
2.0.0 Main
  • QATTS Product Documentation
  • Getting Started
    • About QATTS
      • A Quick Tour of QATTS
      • Terminology
      • Relationship
    • Dashboard
  • Getting to know
  • Administration
    • Product
      • How to Add Product
      • Configure Test Data Repository
    • Code Branch
      • How to Add Code Branch
    • Feature
    • Client
      • How to Add Client
    • Deployment
      • How to Add Deployment
      • Database Config
      • Email Config
    • Node
      • Streaming Configuration
      • How to register node for streaming
      • Status And Actions
    • Agent
    • User
    • Role
  • Studio
    • UI Elements
      • text_box
        • Properties Library
        • Trouble Shoot
      • loader
        • Trouble Shoot
      • date
      • button
      • drop_down
        • Trouble Shoot
        • Properties Library
      • label
      • check_box
      • radio_button
      • link
      • Shadow
      • Trouble Shoot
      • Properties Library
      • Pre and Post Actions
      • table
        • Example
        • Trouble Shoot
      • form
      • toogle_button
      • file
      • alert
  • Automation
    • Objects
      • UI Element
        • Drop Down
        • Radio Button
        • Multi Elements
        • table
        • form
      • Product Element
        • Advanced Data Types
          • QIntegerArray
          • QStringArray
          • QArray
          • QData
        • Basic Data Types
      • API
      • Query
      • Smarty
        • Excel: Read data from excel
        • File: Reads file Data
        • EmailRead
        • EmailSend
        • SiteScan
        • PDF Utils
      • New Group
    • Test Case
    • Function
    • Data Table
  • Execution
    • Test Case
      • Clients Summary
      • Search and Manage
      • Context Parameters
      • Details by Functionality
        • Sync
    • Test Suite
      • Create Suite
    • Test Run
      • Schedule Test Run
      • Untitled
    • Test Result
      • Results by Clients
      • Results by Fuctionality
    • Build No
    • Reports
      • All Failed Test Cases
      • Recently Failed Test Cases
  • Others
    • Milestone
  • Settings
    • Builds
    • Milestone
  • Site Scan
  • Using QATTS
    • Guide to API Automation
      • Adding API
      • Request
      • Response
        • Writing Response Schema
    • Guide to Web Automation
      • Performing Web Automation
    • Guide to setup agent-service
  • Advanced Data Types
    • QData
  • Methods
  • Standard Actions Methods
    • Execute Methods
  • UI Action Methods
    • extractGroup
  • File Action Methods
  • UI Element Advanced
  • UI Checks
  • Extraction Rules
  • Assertion Operations
  • Error Codes : Automation
  • Error Code: Execution
  • JSpreadSheetUtil Methods
  • Functions
    • Primitive
      • CONCATENATE
    • Date & Time
    • Text
  • Other Information
    • FAQ
    • Troubleshooting
      • UI Methods
Powered by GitBook
On this page

Was this helpful?

JSpreadSheetUtil Methods

JSpreadSheetUtil.java class comes under com.ibaseit.core.util package from ibcore library to evaluate functions

PreviousError Code: ExecutionNextFunctions

Last updated 2 years ago

Was this helpful?

Mock Data to test:

In evaluating data, QATTS gives you various useful and simple to evaluate.

method: eval(Map<String, Object> inputData, Map<String, String> inputDataTypes)

inputData:

{ "prodElement19": "=IF(23+0.0825>=prodElement15,prodElement8,23+0.0825)", "prodElement18": "=IF(prodElement4<="Yes",23+0.0825,prodElement8)", "prodElement10": "=DATE(2017,1,12)+1", "prodElement13": "=DATEVALUE("12/12/2017","dd/MM/yyyyy")", "prodElement2": "=prodElement1+" "+prodElement3+" "+prodElement4", "prodElement16": "=prodElement11+1", "prodElement11": "=TODAY()+1", "prodElement14": "=TIMEVALUE("10:10 AM")", "prodElement7": "=MID("Anel Clamp-on O'Connor 150mm - 80 mm", 1,4)", "prodElement6": "=TRIM(" Hello World !")", "prodElement8": "=LOWER(TRIM(" Hello World !")+""+FIND("AJAY KUMAR","K"))", "prodElement9": "=FIND("AJAY KUMAR","K",7)", "prodElement1": "Hello", "prodElement3": "World", "prodElement4": "!", "prodElement5": "=UPPER(LOWER(LOWER(prodElement1)+""+UPPER(prodElement3)+LEN(prodElement3)))", "prodElement15": "=36/6*3+4-8", "prodElement12": "=NOW()+1", "prodElement17": "[ddfd]" }

inputDataTypes:

{ "prodElement9": "string", "prodElement7": "string", "prodElement8": "string", "prodElement5": "string", "prodElement6": "string", "prodElement3": "string", "prodElement4": "string", "prodElement1": "string", "prodElement2": "string", "prodElement11": "date", "prodElement10": "date", "prodElement13": "date", "prodElement12": "date", "prodElement15": "integer", "prodElement14": "date", "prodElement19": "string", "prodElement18": "string" }

Result:

{"prodElement19":"hello world5","prodElement18":23.0825,"prodElement10":1484245800000,"prodElement13":1513017000000,"prodElement2":"Hello World !","prodElement16":1654885800000,"prodElement11":1654799400000,"prodElement14":16800000,"prodElement7":"Anel","prodElement6":"Hello World","prodElement8":"hello world5","prodElement9":-1,"prodElement1":"Hello","prodElement3":"World","prodElement4":"!","prodElement5":"HELLOWORLD5","prodElement15":14.0,"prodElement12":1654841554624,"prodElement17":"[ddfd]"}

functions