07-24-2023, 10:09 AM
I'm trying to transfer the values stored in a JScript matrix to Excel. The problem is how I should initialize the current Excel Workbook that is opened.
For previous works, in python the code is:
import clr
clr.AddReference("Microsoft.Office.Interop.Excel")
import Microsoft.Office.Interop.Excel as Excel
from System.Runtime.InteropServices import Marshal
ex = Marshal.GetActiveObject("Excel.Application")
ex.Visible = True
wb = ex.ActiveWorkbook
ws_data = wb.Worksheets('name')
So my intention is "translate" this code into Jscript to set the values of my matrix in Excel
For previous works, in python the code is:
import clr
clr.AddReference("Microsoft.Office.Interop.Excel")
import Microsoft.Office.Interop.Excel as Excel
from System.Runtime.InteropServices import Marshal
ex = Marshal.GetActiveObject("Excel.Application")
ex.Visible = True
wb = ex.ActiveWorkbook
ws_data = wb.Worksheets('name')
So my intention is "translate" this code into Jscript to set the values of my matrix in Excel