| 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 | . | |||||