不 能 用 ? ? ExcelApp.ActiveSheet.PageSetup.Orientation := xlLandscape;

Hi alpha317,    試試

(ExcelApp.ActiveSheet as _WorkSheet).PageSetup.Orientation := xlLandscape;

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman

//--Delphi 6 (Excel 2003) ExcelApp.ActiveSheet.WorkSheets.PageSetup.Orientation := xlLandscape; [Error]Undeclared identifier: "xlLandscape" 还是不能用 ^_^" ExcelApp.ActiveSheet as _WorkSheet).PageSetup.Orientation := xlLandscape; [Error]Undeclared identifier: "xlLandscape" [Error]Undeclared identifier: "_WorkSheet" 偶是新手请帮帮忙.....

AND 谢谢你的回复

Hi alpha317,    參考這一篇文章    http://delphi.ktop.com.tw/topic.php?topic_id=43788 uses Excel2000 試試！ ---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman

cannot use ExcelApp.ActiveSheet.WorkSheets.PageSetup.Orientation := xlLandscape; This can use ExcelApp.ActiveSheet.WorkSheets.PageSetup.Orientation := 2; //--2 = xlLandscape and so 1 = xlPortrait

alpha317: Fishman的意思應該是在uses那段加上Excel2000,醬子Delphi才看得懂xlLandscape代表什麼意思,我也是新手啦,所以我猜你有可能是會錯意 我的範例如下 unit MakeExcelFile; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs,ComObj, StdCtrls, Excel2000; ^^^^^^^^^^ 是在加在這裡哦 :P 不過我也不知道我有沒有猜對,有猜對的話試試唄