Created By  inflectra.adam Monday, November 16, 2015
The built-in Spreadsheet object in Rapise makes it easy to read data from an MS-Excel spreadsheet. What happens if you want to write data back to the Excel sheet?
The solution is to use the OLE / ActiveX interface for Microsoft Excel:
var ExcelApp = new ActiveXObject("Excel.Application");
ExcelSheet = new ActiveXObject("Excel.Sheet");
// Make Excel visible through the Application object.
ExcelSheet.Application.Visible = true;
// Place some text in the first cell of the sheet.
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1";
// Save the sheet.
// Close Excel with the Quit method on the Application object.

For further reading we recommend:
Article Info
  • Last Updated: 11/16/2015
  • Article ID: KB175
  • Views: 1965