| Admin |
| Отправлено: 03.02.2005, 22:30 |
|
Владимир
Группа: Администратор
Сообщений: 1190
|
Вопросы от посетителей сайта: (dina)
как программно задать формат листа,т.е. А3 или А4 и
поворот листа альбомный или книжный устанавливать в C++Builder 6
я пробовала написать
| CODE |
Variant VarExcel,ws,wb,range;
VarExcel=CreateOleObject("Excel.Application");
VarExcel.OlePropertySet("Visible",true);
.
.
.
.
ws=VarExcel.OlePropertyGet("WorkSheets").OlePropertyGet("Item",1);
ws.OlePropertyGet("PageSetup").OlePropertySet("Orientation","xlLandscape");
выдает ошибку.
|
|
|
| AVC |
| Отправлено: 04.02.2005, 09:13 |
|
Ветеран
Группа: Модератор
Сообщений: 1583
|
| CODE |
include\vcl\excel???.h
typedef enum XlPageOrientation
{
xlLandscape = 2,
xlPortrait = 1
} XlPageOrientation;
typedef enum XlPaperSize
{
xlPaper10x14 = 16,
xlPaper11x17 = 17,
xlPaperA3 = 8,
xlPaperA4 = 9,
xlPaperA4Small = 10,
xlPaperA5 = 11,
xlPaperB4 = 12,
xlPaperB5 = 13,
xlPaperCsheet = 24,
xlPaperDsheet = 25,
xlPaperEnvelope10 = 20,
xlPaperEnvelope11 = 21,
xlPaperEnvelope12 = 22,
xlPaperEnvelope14 = 23,
xlPaperEnvelope9 = 19,
xlPaperEnvelopeB4 = 33,
xlPaperEnvelopeB5 = 34,
xlPaperEnvelopeB6 = 35,
xlPaperEnvelopeC3 = 29,
xlPaperEnvelopeC4 = 30,
xlPaperEnvelopeC5 = 28,
xlPaperEnvelopeC6 = 31,
xlPaperEnvelopeC65 = 32,
xlPaperEnvelopeDL = 27,
xlPaperEnvelopeItaly = 36,
xlPaperEnvelopeMonarch = 37,
xlPaperEnvelopePersonal = 38,
xlPaperEsheet = 26,
xlPaperExecutive = 7,
xlPaperFanfoldLegalGerman = 41,
xlPaperFanfoldStdGerman = 40,
xlPaperFanfoldUS = 39,
xlPaperFolio = 14,
xlPaperLedger = 4,
xlPaperLegal = 5,
xlPaperLetter = 1,
xlPaperLetterSmall = 2,
xlPaperNote = 18,
xlPaperQuarto = 15,
xlPaperStatement = 6,
xlPaperTabloid = 3,
xlPaperUser = 256
} XlPaperSize;
|
|
|
|
