-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdate_dados_excel.cpp
41 lines (32 loc) · 1.09 KB
/
update_dados_excel.cpp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
#include <iostream>
#include <windows.h>
#include <atlbase.h>
#import "C:\\Program Files\\Microsoft Office\root\\Office16\\EXCEL.EXE\\EXCEL.EXE" no_namespace
int main()
{
// Inicialize o COM (Component Object Model)
CoInitialize(NULL);
try
{
// Crie uma instância do Excel
Excel::_ApplicationPtr pExcel;
pExcel.CreateInstance(__uuidof(Excel::Application));
// Abra o arquivo do Excel que contém a consulta Power Query
Excel::WorkbooksPtr pWorkbooks = pExcel->Workbooks;
Excel::WorkbookPtr pWorkbook = pWorkbooks->Open(L"C:\\Caminho\\Para\\Seu\\Arquivo.xlsx");
// Atualize todas as conexões de consulta Power Query no arquivo
pWorkbook->RefreshAll();
// Salve as alterações e feche o arquivo
pWorkbook->Save();
pWorkbook->Close();
// Feche o Excel
pExcel->Quit();
}
catch (const _com_error &e)
{
std::cerr << "Erro: " << e.ErrorMessage() << std::endl;
}
// Libere recursos do COM
CoUninitialize();
return 0;
}