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 42 43 44
|
//---------------------------------------------------------------------------
#include <vcl.h>
#pragma hdrstop
#include "Unit1.h"
#include "Excel_xp.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
: TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TForm1::Button1Click(TObject *Sender)
{
Variant vMSExcel,vXLWorkbooks,vXLWorkbook,vWorksheet,vCell,vRow;
vMSExcel = Variant::CreateObject("Excel.Application");
vMSExcel.OlePropertySet("DisplayAlerts", false);
vMSExcel.OlePropertySet("ScreenUpdating", false);
vMSExcel.OlePropertySet("Visible", true);
vMSExcel.OlePropertySet("Interactive", false);
vXLWorkbooks = vMSExcel.OlePropertyGet("Workbooks");
vXLWorkbook = vXLWorkbooks.OleFunction("Add");
Variant vWsPos = 1; //premiere feuille par defaut
vWorksheet = vXLWorkbook.OlePropertyGet("Worksheets", vWsPos);
try{
vCell = vWorksheet.OlePropertyGet("Evaluate","A5");
vCell.OlePropertySet("Value",StringToOleStr("Ligne1\nLigne2"));
vCell.OlePropertySet("VerticalAlignment",xlDistributed);
vRow = vWorksheet.OlePropertyGet("Rows",5);
vRow.OlePropertySet("RowHeight", 60);
}catch(EOleError &er){
ShowMessage(er.Message);
}
vMSExcel.OlePropertySet("ScreenUpdating", true);
vMSExcel.OlePropertySet("Interactive", true);
}
//--------------------------------------------------------------------------- |
Partager