How create and excel file from cpp with Win32 or COM

Question

Hi,

I'm working on the Winui3 desktop app in cpp. I have a table of data and I want to export it to Microsoft Excel format(.xlxs),

How to create a new Excel file and export data to it with Cpp without using 3rd party libs?

Thank You

Answer 1

With C++ CLR integration you can use Microsoft.Office.Interop.Excel Namespace https://learn.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel?view=excel-pia

Answer 2

See Microsoft's Open XML SDK for Office

Answer 3

A way is with Excel Interop.

Minimal test with Office 2016 in C++/Win32=>

At beginning :

#import "C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\OFFICE16\mso.dll" rename("RGB", "MSRGB") rename("DocumentProperties", "WordDocumentProperties")  
#import "C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB" raw_interfaces_only, rename("Reference", "ignorethis"), rename("VBE", "testVBE")  
#import "C:\Program Files (x86)\Microsoft Office\root\Office16\Excel.exe" exclude("IFont", "IPicture") rename("RGB", "ignorethis"), rename("DialogBox", "ignorethis"), rename("VBE", "testVBE"), rename("ReplaceText", "EReplaceText"), rename("CopyFile","ECopyFile"), rename("FindText", "EFindText"), rename("NoPrompt", "ENoPrompt")

Test :

Excel::_ApplicationPtr pExcel;
HRESULT hr = pExcel.CreateInstance(L"Excel.Application");
if (SUCCEEDED(hr))
{
				// pExcel->PutVisible(0, true);

				Excel::_WorkbookPtr pWorkbook = pExcel->Workbooks->Add(static_cast<long>(Excel::xlWorksheet));
				Excel::_WorksheetPtr pWorksheet = pExcel->ActiveSheet;						
				pWorksheet->PutName(L"Sheet Name");
				Excel::RangePtr pRange = pWorksheet->Cells;
				pRange->Item[1][1] = L"Test";

				pWorksheet->SaveAs("E:\\Temp\\test.xlsx");
				pWorkbook->Close();
				pExcel->Quit();
}