FASTGETGRID 1.0

FASTGETGRID extracts values and formuals form all worksheets in a Microsoft Office Spreadsheet Object (OWC). It also provides the numerical and the string variables seperatelyUSAGE:>> h = actxcontrol('OWC11.Spreadsheet.11',[0 0 550 420]);>> FastFillGrid(h, ...{'Maturity' ,'4/15/09','' ; ...'coupon' ,8.63 ,'ANN' ; ...'redemption' ,100 ,'' ; ...'Yield' ,10.1660 ,'' ; ...'' ,'' ,'' ; ...'dirty price' ,97.2088 ,'' ; ...'accrued interest',6.2088 ,'' ; ...'clean price' ,91.0000 ,'' });>> A = FastGetGrid(h)A =Sheet1: [1x1 struct]Sheet2: [1x1 struct]Sheet3: [1x1 struct]>> % LOOK AT SHEET 1>> A.Sheet1ans =Formula: {8x3 cell}Value: {8x3 cell}String: {8x3 cell}Number: {8x3 cell}>> % LOOK AT THE FORMULAS IN SHEET 1>> A.Sheet1.Formulaans ='Maturity' '39918' [NaN]'coupon' '8.63' 'ANN''redemption' '100' [NaN]'Yield' '10.166' [NaN][ NaN] [ NaN] [NaN]'dirty price' '97.2088' [NaN]'accrued interest' '6.2088' [NaN]'clean price' '91' [NaN]>> % LOOK AT ALL OF THE VALUES IN SHEET 1>> A.Sheet1.Valueans ='Maturity' '4/15/2009' [NaN]'coupon' [ 8.6300] 'ANN''redemption' [ 100] [NaN]'Yield' [ 10.1660] [NaN][ NaN] [ NaN] [NaN]'dirty price' [ 97.2088] [NaN]'accrued interest' [ 6.2088] [NaN]'clean price' [ 91] [NaN]>> % LOOK AT ONLY THE STRINGS IN SHEET 1>> A.Sheet1.Stringans ='Maturity' '4/15/2009' []'coupon' [] 'ANN''redemption' [] []'Yield' [] [][] [] []'dirty price' [] []'accrued interest' [] []'clean price' [] []>> % LOOK AT ONLY THE NUMBERS IN SHEET 1>> A.Sheet1.Numberans =[] [] [NaN][] [ 8.6300] [][] [ 100] [NaN][] [10.1660] [NaN][NaN] [ NaN] [NaN][] [97.2088] [NaN][] [ 6.2088] [NaN][] [ 91] [NaN]KEY WORDS: Excel spreadsheet workbook sheet formula extract i/o input file grid

Requirements:	No special requirements
Platforms:	Matlab
Keyword:	Ann Redemption,  Asheet Formulaans,  Cellgtgt,  Cellnumber,  Cellstring,  Formulas,  Interest,  Maturity,  Nan Accrued,  Nan Clean,  Nan Coupon,  Nan Dirty,  Nan Yield
Users rating:	0/10