Can we use Excel file in zap-fix?
- This topic has 1 reply, 2 voices, and was last updated 10 years, 7 months ago by
Sasha ZAP.
Viewing 1 post (of 1 total)
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.
Hello BarbJack,
Thank-you for your question.
Basically in our latest Zap-fix Standalone versions there is already the following Excel file’s feature:
Datatable.ImportCSV(<path>) – Imports Datatable to CSV during runtime.
To read from a runtime Excel datatable:
x = Datatable.Value("Name of the Spreadsheet")
To write into a runtime Excel datatable:
Datatable.Value("Name of the Spreadsheet") = x
Our R&D Department works to implement the Export method as well.
Until the new method will be published in teh next build you can use the following VBScript code to importexportreadwrite into and Excel file:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Open("C:Test.xls")
Set objWorksheet = objWorkbook.Worksheets(1)
‘Write into Excel Worksheet
objWorksheet.Cells(1, 1).Value = "Number"
objWorkbook.Save()
‘Read from Excel Worksheet
value = objWorksheet.Cells(1,1).Value
objExcel.Quit
Set objWorksheet = Nothing
Set objWorkbook = Nothing
Set objExcel = Nothing
Please contact Zap for further help.
Thanks,
Sasha
Already have an account? Login
Check you SPAM folder if you do not see the email.
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |