topic Re: APIDo_SaveID - saving to .xls from schedule in Archicad C++ API

APIDo_SaveID - saving to .xls from schedule

Anonymous — Tue, 04 Jul 2023 12:07:02 GMT

Hello
I am trying to save a interactive schedule as a .xls file using APIDo_SaveID function.
I have been able to open the interactive schedule view and now I want to be able to do a save as.

There is no excel fileTypeID to apply to the API_FileSavePars.fileTypeID structure

//code------
//save file as excel
API_FileSavePars savePara;
std::string newXcelFilename = "exportExcelTest.xls";

BNZeroMemory(&savePara, sizeof(API_FileSavePars));
savePara.fileTypeID = APIFType_TabListFile;

IO::Location folderLoc;
API_SpecFolderID specID = API_UserDocumentsFolderID;
ACAPI_Environment(APIEnv_GetSpecFolderID, &specID, &folderLoc);
savePara.file = new IO::Location(folderLoc, IO::Name(newXcelFilename.c_str()));

err = ACAPI_Automate(APIDo_SaveID, &savePara, nullptr);

I hope someone can help ...please !

Archicad 22
Dev Kit 22.3004
Windows 8

Re: APIDo_SaveID - saving to .xls from schedule

leilei — Thu, 27 Sep 2018 07:57:07 GMT

Hi
Maybe you can look at the Do_ExportWallsToExcel function in Database_Control test .

Re: APIDo_SaveID - saving to .xls from schedule

Tibor Lorantfy — Thu, 27 Sep 2018 13:03:57 GMT

Using ACAPI_Automate(APIDo_SaveID,...) the content of the current window cannot be saved to Excel file.
As leilie said, you can find an example in Database_Control Example Add-On for writing Excel files. In that way you can write any data into the Excel file, but you have to collect those informations first.