！壞人必需做好事！

把 Epplus 的 example5 翻成 c++.net

其實我本來想用 native c++ call 的
可是 System.IO.FileIO 一直無法初始化？
mscorlib.dll 一直 load 的有錯誤，
所以還是乖乖吃 .net 套餐吧！

// clr_call_epplus.cpp: 主要專案檔。
 
#include "stdafx.h"
 
using namespace System;
using namespace System::IO;
using namespace OfficeOpenXml;    
using namespace OfficeOpenXml::Drawing;
using namespace OfficeOpenXml::Drawing::Chart;
using namespace System::Drawing;
 
int main(array<System::String ^> ^args)
{
        FileInfo^ templateFile = gcnew FileInfo(L"c:\\temp\\SampleApp\\sample1.xlsx");
        FileInfo^ newFile = gcnew FileInfo(L"c:\\temp\\SampleApp\\sample5.xlsx");
        if (newFile->Exists)
        {
                newFile->Delete();  // ensures we create a new workbook
                newFile = gcnew FileInfo(L"c:\\temp\\SampleApp\\sample5.xlsx");
        }
        ExcelPackage^ package = gcnew ExcelPackage(newFile, templateFile);
        {
                //Open worksheet 1
                ExcelWorksheet^ worksheet = package->Workbook->Worksheets[1];
                worksheet->InsertRow(5, 2);
 
                worksheet->Cells["A5"]->Value = "12010";
                worksheet->Cells["B5"]->Value = "Drill";
                worksheet->Cells["C5"]->Value = 20;
                worksheet->Cells["D5"]->Value = 8;
 
                worksheet->Cells["A6"]->Value = "12011";
                worksheet->Cells["B6"]->Value = "Crowbar";
                worksheet->Cells["C6"]->Value = 7;
                worksheet->Cells["D6"]->Value = 23.48;
 
                worksheet->Cells["E2:E6"]->FormulaR1C1 = "RC[-2]*RC[-1]";                
 
                ExcelNamedRange^ name = worksheet->Names->Add("SubTotalName", worksheet->Cells["C7:E7"]);
                name->Style->Font->Italic = true;
                name->Formula = "SUBTOTAL(9,C2:C6)";
 
                //Format the new rows
                worksheet->Cells["C5:C6"]->Style->Numberformat->Format = "#,##0";
                worksheet->Cells["D5:E6"]->Style->Numberformat->Format = "#,##0.00";
 
                ExcelPieChart^ chart = (ExcelPieChart^)(worksheet->Drawings->AddChart("PieChart", eChartType::Pie3D));
 
                chart->Title->Text = "Total";
                //From row 1 colum 5 with five pixels offset
                chart->SetPosition(0, 0, 5, 5);
                chart->SetSize(600, 300);
 
                ExcelAddress^ valueAddress = gcnew ExcelAddress(2, 5, 6, 5);
                ExcelChartSerie^ ser = (ExcelPieChartSerie^)(chart->Series->Add(valueAddress->Address, "B2:B6"));
                chart->DataLabel->ShowCategory = true;
                chart->DataLabel->ShowPercent = true;
 
                chart->Legend->Border->LineStyle = eLineStyle::Solid;
                chart->Legend->Border->Fill->Style = eFillStyle::SolidFill;
                chart->Legend->Border->Fill->Color = System::Drawing::Color::Red;
 
                //Switch the PageLayoutView back to normal
                worksheet->View->PageLayoutView = false;
                // save our new workbook and we are done!
                package->Save();
        }
 
 
    Console::WriteLine(L"Hello World");
    return 0;
}