/*-----------------------------------------------------------
| Tutorial 14
|
| This tutorial shows how to create an Excel file in C++.NET
| having a sheet and conditional formatting for cell ranges.
----------------------------------------------------------*/using namespace System;
using namespace System::Drawing;
using namespace EasyXLS;
using namespace EasyXLS::Constants;
int main()
{
Console::WriteLine("Tutorial 14\n----------\n");
// Create an instance of the class that exports Excel files having one sheet
ExcelDocument ^workbook = gcnew ExcelDocument(1);
// Get the table of data for the first worksheet
ExcelWorksheet ^xlsTab = safe_cast<ExcelWorksheet^>(workbook->easy_getSheet("Sheet1"));
ExcelTable ^xlsTable = xlsTab->easy_getExcelTable();
// Add data in cellsfor (int i=0;i<6;i++)
{
for (int j=0;j<4;j++)
{
if((i<2)&&(j<2))
xlsTable->easy_getCell(i, j)->setValue("12");
elseif((j==2)&&(i<2))
xlsTable->easy_getCell(i, j)->setValue("1000");
else
xlsTable->easy_getCell(i, j)->setValue("9");
xlsTable->easy_getCell(i, j)->setDataType(DataType::NUMERIC);
}
}
// Set conditional formatting
xlsTab->easy_addConditionalFormatting("A1:C3", ConditionalFormatting::OPERATOR_BETWEEN,
"=9", "=11", true, true, Color::Red);
// Set another conditional formatting
xlsTab->easy_addConditionalFormatting("A6:C6", ConditionalFormatting::OPERATOR_BETWEEN,
"=COS(PI())+2", "", Color::Bisque);
xlsTab->easy_getConditionalFormattingAt("A6:C6")->getConditionAt(0)->setConditionType(
ConditionalFormatting::CONDITIONAL_FORMATTING_TYPE_EVALUATE_FORMULA);
// Export Excel file
Console::WriteLine("Writing file C:\\Samples\\Tutorial14 - conditional formatting in Excel.xlsx.");
workbook->easy_WriteXLSXFile("C:\\Samples\\Tutorial14 - conditional formatting in Excel.xlsx");
// Confirm export of Excel file
String ^sError = workbook->easy_getError();
if (sError->Equals(""))
Console::Write("\nFile successfully created. Press Enter to Exit...");
else
Console::Write(String::Concat("\nError encountered: ", sError, "\nPress Enter to Exit..."));
// Dispose memory
delete workbook;
Console::ReadLine();
return 0;
}
C++ without .NET Framework This tutorial is valid for C++ applications that can use .NET Framework. For applications that does not have .NET Framework integrated, a similar code sample is available.