function import(h,inputtable,varargin)
%IMPORT Imports data from excelpanel to inputtable
%
% Author(s): J. G. Owen
% Revised:
% Copyright 1986-2004 The MathWorks, Inc.
% $Revision: 1.1.6.3 $ $Date: 2004/08/01 00:09:00 $

import com.mathworks.toolbox.control.spreadsheet.*;
import javax.swing.*;

% To do: consolidate with the copy callback "localExcelRightSelect" in 
% "createExcelPanel"


sheetObj = h.excelsheet;
selectedCols = double(sheetObj.STable.getSelectedColumns);

if ~isempty(selectedCols)
    headEnd = str2num(char(h.filterHandles.TXTrowEnd.getText)); 
    interpStr = h.filterHandles.COMBOinterp.getSelectedItem;  
    rawdata = sheetObj.xlsInterp(headEnd, interpStr, selectedCols);

    % empty rawdata means the import failed. 
    if isempty(rawdata)
        return
    end
    copyStruc = struct('data',rawdata,'source','xls','length',size(rawdata,1),...
        'subsource',h.excelsheet.sheetname,'construction',sheetObj.filename,...
        'columns',selectedCols,'transposed',false);
else
    errordlg('No columns have been selected for import','Data Import Tool',...
        'modal')
    return
end

% Copy to clipboard or intert into table
if nargin==3 && strcmp(varargin{1},'copy')
    inputtable.copieddatabuffer = copyStruc;
    inputtable.STable.getModel.setMenuStatus([1 1 1 1 1]);
else
	numpastedrows = inputtable.pasteData(copyStruc);    
	% if >= 1 rows were sucessfuly imported then bring the lsim gui into focus
	if numpastedrows > 0
		inputtable.setFocus
	end
end