Afin.ExcelObjects   AfinScript AFIN 2016
  Start: [F5] or [Ctrl+Q]
<<< Parameters   Info: 5 columns (A:E = 'COCPI..T') from the #11 row are reserved for the AfinScript's program.
e.g. Path = C:\AnyPath      
e.g. Database =        
e.g. Period =        
()        
         
         
Class (Vendor) Object Command Parameters Info The rest: Comments, calculations, row parameters
Afin.ExcelObjects commands       .
.       .
Afin.ExcelObjects   Info   OK, but it stops the program.
Afin.ExcelObjects MyNewWorkbook.xlsx CreateAndSaveAs Path=C:\AnyPath\   While the file extension is .xlsx, .xlsb, .xlsm, .xls, .csv, FileFormat is given automatically
Afin.ExcelObjects MyNewWorkbook.xlsx CreateAndSaveAs Path=C:\AnyPath; FileFormat=36   FileFormat from the standard VBA file format list (-> MSDN)
Afin.ExcelObjects TestWorkbook.xlsx OpenAWorkbook Path=C:\AnyPath\Tests .
Afin.ExcelObjects TestWorkbook.xlsx AddASheet Sht=NewSheet; After=Sheet1 .
Afin.ExcelObjects TestWorkbook.xlsx SetAValue Sht=Sheet1; Rng=A1; Value=My text value .
Afin.ExcelObjects TestWorkbook.xlsx SetAValue Sht=Sheet1; Rng=A1; Value=123 .
Afin.ExcelObjects TestWorkbook.xlsx DeleteASheet Sht=Sheet1 .
Afin.ExcelObjects TestWorkbook.xlsx RefreshAll Sht=Sheet1 .
Afin.ExcelObjects TestWorkbook.xlsx SaveAWorkbook   .
Afin.ExcelObjects TestWorkbook.xlsx SaveAWorkbookAs FileName=C:\AnyPath\Tests\MyWorkbook.xlsx . FileFormat argument as in "Create and save as"
Afin.ExcelObjects TestWorkbook.xlsx CloseAWorkbook   . Default: Save=1
Afin.ExcelObjects TestWorkbook.xlsx CloseAWorkbook Save=1 .