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