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
相关文章
同类最新