首页 > 单独文章 > 正文

office帮助文件查看办法大全

时间:2009-01-12 21:02:22 作者:officeba 【认证】

OFFICE系统中的帮助文件是大家经常学习的好工具好教程,有时在使用当中经常就是直接按这F1就出来调用查看相关帮助了。有时只是纯粹打开学习一下,就没必要开着OFFICE。对于旧版本例如OFFICE2003之类的帮助文件就直接打开安装目录下的帮助文件即可查看,如:C:\Program Files\Microsoft Office\Office\2052下就有很多CHM文件就是帮助文件。但OFFICE2007采用了HEMLP2.0格式编码帮助文件就不能直接查看了。那是不是就没办法了,当然有。OFFICEba就为大家收集了很多方法!
1、去下载Office2007帮助help文件直接查看工具。officeba.com.cn已提供本地下载。有这个工具你就可以用了直接查看OFFICE2007的帮助文件了。
2、命令提示符下,键入命令:

"C:\Program Files\Microsoft Office\Office12\CLVIEW.EXE" "excel" "microsoft office excel"

其中的“C:\Program Files\Microsoft Office\Office12\”就是你安装office的路径。

而在Windows中,你可以创建一个快捷方式,然后在其项目的位置中,填入是面的内容,而后就可以通过这个快捷方式,来直接打开Excel的帮助文件了,这样,查看Excel2007的帮助文件

3、做了个批处理,直接运行即可.

也可手工注册:
1.把hxvz.dllCopy到
C:\Program Files\Common Files\Microsoft Shared\Help\hxvz.dll
2.开始菜单-运行:
regsvr32 C:\Program Files\Common Files\Microsoft Shared\Help\hxvz.dll
4、最后一个:MATLAB帮助文件中读取EXCEL的帮助M文件

function actx_excel                                             
% Copyright 2005 The MathWorks, Inc.
% Use Excel as a data server for MATLAB
exl = actxserver('excel.application');

%% Load data from an excel file
% Get Workbook interface and open file
exlWkbk = exl.Workbooks;
exlFile = exlWkbk.Open([docroot '/techdoc/matlab_external/examples/input_resp_data.xls']);

% Get interface for Sheet1 and read data into range object
exlSheet1 = exlFile.Sheets.Item('Sheet1');
rngObj = exlSheet1.Range('A1:G1500');

% Read data from excel range object into MATLAB cell array
exlData = rngObj.Value;

% Create a second Excel server and
% Add another workbook for saving
% the graph to an Excel file
exl2 = actxserver('excel.application');
exlWkbk2 = exl2.Workbooks;
wb = exlWkbk2.Add;
graphSheet = wb.Sheets.Add;
Shapes = graphSheet.Shapes;

%% Extract column data
% Time:1, inptAil:2, inptEle:3, inptRud:4, respAil:5, respEle:6, respRud:7
for ii = 1:size(exlData,2)
    matData(:,ii) = reshape([exlData{2:end,ii}],size(exlData(2:end,ii)));
    lBoxList{ii} = [exlData{1,ii}];
end
lbs = '';
tme = matData(:,1); % Time data
%% ------------ GUI layout ---------------
% Use system background color for GUI components
panelColor = get(0,'DefaultUicontrolBackgroundColor');
%% Set up the figure and defaults
f = figure('Units','characters',...
         'Position',[30 30 120 35],...
         'Color',panelColor,...
         'HandleVisibility','callback',...
         'IntegerHandle','off',...
         'Renderer','painters',...
         'Toolbar','figure',...
         'NumberTitle','off',...
         'Name','Excel Plotter',...
         'PaperPositionMode','auto',...
         'DeleteFcn',@deleteFig);

%% Create the bottom uipanel
botPanel = uipanel('BorderType','etchedin',...
     'BackgroundColor',panelColor,...
     'Units','characters',...
     'Position',[1/20 1/20 119.9 8],...
     'Parent',f);

%% Create the right side panel
rightPanel = uipanel('bordertype','etchedin',...
     'BackgroundColor',panelColor,...
     'Units','characters',...
     'Position',[88 8 32 27],...
     'Parent',f);

%% Create the center panel
centerPanel = uipanel('bordertype','etchedin',...
     'Units','characters',...
     'Position', [1/20 8 88 27],...
     'Parent',f);

%% Add an axes to the center panel
a = axes('parent',centerPanel);
xlabel(a,'Time')

%% Add listbox and label
listBoxLabel = uicontrol('Style','text','Units','characters',...
         'Position',[4 24 24 2],...
         'String','Select column(s) to plot',...
         'BackgroundColor',panelColor,...
         'Parent',rightPanel);
listBox = uicontrol('Style','listbox','Units','characters',...
         'Position',[4 2 24 20],...
         'BackgroundColor','white',...
         'Max',10,'Min',1,...
         'Parent',rightPanel,...
         'String',lBoxList(2:end));

%% Add edit field for excel file name
plotButton = uicontrol('Style','pushbutton','Units','characters',...
         'Position',[5 2 24 2],...
         'String','Create Plot',...
         'Parent',botPanel,...
         'Callback',@plotButtonCallback);
clearButton = uicontrol('Style','pushbutton','Units','characters',...
         'Position',[33 2 24 2],...
         'String','Clear Graph',...
         'Parent',botPanel,...
         'Callback',@clearButtonCallback);
saveButton = uicontrol('Style','pushbutton','Units','characters',...
         'Position',[60 2 24 2],...
         'String','Save Graph',...
         'Parent',botPanel,...
         'Callback',@saveButtonCallback);     
dispButton = uicontrol('Style','togglebutton','Units','characters',...
         'Position',[87 2 24 2],...
         'String','Show Excel Data File',...
         'Parent',botPanel,...
         'Callback',@dispButtonCallback);

%% ------------------Callback Functions------------

function plotButtonCallback(src,evnt)   
iSelected = get(listBox,'Value');
grid(a,'on');hold all
for p = 1:length(iSelected)
    switch iSelected(p)
       case 1
          plot(a,tme,matData(:,2))
       case 2
          plot(a,tme,matData(:,3))
       case 3
          plot(a,tme,matData(:,4))   
       case 4
          plot(a,tme,matData(:,5))
       case 5
          plot(a,tme,matData(:,6))
       case 6
          plot(a,tme,matData(:,7))
       otherwise
          disp('Select data to plot')
    end
end
[legh,c,g,lbs] = legend([lbs lBoxList(iSelected+1)]);
end % plotButtonCallback

%% Callback for clear button
function clearButtonCallback(src,evt)
    cla(a,'reset')
    lbs = '';
end % clearButtonCallback

%% Callback for save graph button
function saveButtonCallback(src,evt)
    tempfig = figure('Visible','off','PaperPositionMode','auto');
    tempfigfile = [tempname '.png'];
    ah = findobj(f,'type','axes');
    copyobj(ah,tempfig)
    print(tempfig,'-dpng',tempfigfile);
    close(tempfig)
    Shapes.AddPicture(tempfigfile,0,1,50,18,300,235);
    exl2.visible = 1;
end
   
%% Display or hide Excel file
function dispButtonCallback(src,evt)
    exl.visible = get(src,'Value');
end % dispButtonCallback

%% Terminate Excel process
function deleteFig(src,evt)
    exlWkbk.Close
    exlWkbk2.Close
    exl.Quit
    exl2.Quit;%invoke(exl2,'Quit')
end % deleteFig
         
end % actx_excel


相关文章

同类最新