Delphi用ExcelApp操作03Excel表格,如果Excel是07的不兼容
如:在03中隐藏工具栏和状态栏在07中就不行.
fXLSApp.CommandBars['Standard'].Visible:=false;
fXLSApp.CommandBars['Formatting'].Visible:=false;
fXLSApp.CommandBars['Reviewing'].Visible:=false;
fXLSApp.CommandBars['Cell'].Enabled := False;
//ShowMessage(fXLSApp.CommandBars.count);
mnuSys := fXLSApp.CommandBars['Worksheet Menu Bar'];
for i := 1 to mnuSys.Controls.count do
mnuSys.Controls.Item[i].Visible := False;
fXLSApp.CommandBars['Worksheet Menu Bar'].Enabled := False;
fXLSApp.CommandBars['toolbar list'].Enabled := False;
fXLSApp.DisplayFormulaBar := False;
fXLSApp.DisplayStatusBar := False; //状态栏
fXLSApp.ActiveWorkbook.ReadOnlyRecommended := True;
fXLSApp.ActiveWindow.DisplayWorkbookTabs := False;//sheet选项卡
fXLSApp.ActiveWindow.DisplayHeadings := False; //隐藏行,列标号
fXLSApp.Application.DisplayFormulaBar := False;//隐藏编辑栏
各位大大有办法吗?
[解决办法]
CreateOleObject
还是用OLE吧，这个受版本影响比较小
[解决办法]
http://www.ecma-international.org/publications/standards/Ecma-376.htm
[解决办法]
支持1楼的方法
