C++ 保存Excel文件（带密码保护）

最近有客户需求报表保存为xls的功能，需要保存的文件设置密码保护，特进行尝试！

Workbook.SaveAs method (Excel)

参数详情：https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas

 C++ Code 

1
2
3
4
5
6

void SaveAs(VARIANT &Filename, VARIANT &FileFormat, VARIANT &Password, VARIANT &WriteResPassword, VARIANT &ReadOnlyRecommended, VARIANT &CreateBackup, long AccessMode, VARIANT &ConflictResolution, VARIANT &AddToMru, VARIANT &TextCodepage, VARIANT &TextVisualLayout, VARIANT &Local)
{
static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
InvokeHelper(0x785, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, AccessMode, &ConflictResolution, &AddToMru, &TextCodepage, &TextVisualLayout, &Local);
}

调用实例：

 C++ Code 

1
2
3
4
5
6
7
8
9
10
11
12
13
14

BOOL bReadOnlyRecommended = TRUE;
BOOL bCreateBackup = TRUE;
BOOL bLocal = TRUE;
CString strXlsPath = _T("C:\\test.xls");
m_book.SaveAs(  _variant_t(strXlsPath),                         // Filename
                _variant_t(-4143)/*xlWorkbookNormal*/,          // FileFormat
                _variant_t(_T("123")),                          // Password
                _variant_t(_T("123")),                          // WriteResPassword
                _variant_t(bReadOnlyRecommended),               // ReadOnlyRecommended
                _variant_t(bCreateBackup),                      // CreateBackup
                _variant_t(2)/*xlShared*/,                      // AccessMode
                _variant_t(2)/*xlLocalSessionChanges*/,         // ConflictResolution
                vtMissing, vtMissing, vtMissing,
                _variant_t(bLocal));                            // Local