Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
Copy Data Between Spreadsheets | VBScript
CopyDataBetweenSpreadsheets.vbs:
VB
' Create and activate two Spreadsheet objects Set srcDocument = CreateObject("Bytescout.Spreadsheet.Spreadsheet") srcDocument.RegistrationName = "demo" srcDocument.RegistrationKey = "demo" Set dstDocument = CreateObject("Bytescout.Spreadsheet.Spreadsheet") dstDocument.RegistrationName = "demo" dstDocument.RegistrationKey = "demo" ' Load exported data srcDocument.LoadFromFile ".\sample.csv" ' Load destination document dstDocument.LoadFromFile ".\destination.xlsx" ' Get worksheets Set srcWorksheet = srcDocument.Worksheet(0) Set dstWorksheet = dstDocument.Worksheet(0) ' Copy data from source to destination For row = 0 To 3 For column = 0 To 3 dstWorksheet.Cell(row, column).Value = srcWorksheet.Cell(row, column).Value Next Next ' Recalculate formulas dstDocument.Workbook.Calculate ' Save modified document as "result.xls" dstDocument.SaveAs ".\result.xls"