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   .
Afin.ExcelObjects   RefreshAll   . Without "object" parameter the active AFinScript workbook is used as default.
Afin.ExcelObjects TestWorkbook.xlsx RefreshAll Sht=Sheet1 . This refreshes a sheet specified only.
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=0 . This doesn't save a workbook while closing
Afin.ExcelObjects C:\path\File.xml ConvertToXlsx   . Default: It saves to '{OrginalFullName}_converted.xlsx'
Afin.ExcelObjects C:\path\File.xml ConvertToXlsx SaveAs=c:\AnotherPath\File.xlsx .
Afin.ExcelObjects C:\path\Page.html ConvertToXlsx SaveAs=c:\AnotherPath\File2.xlsx .
Afin.ExcelObjects C:\path\OOSpreadSheet.ods ConvertToXlsx SaveAs=c:\AnotherPath\File3.xlsx .