FASTGETGRID 1.0

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : Freeware
CreatedCreated : Oct 9, 2007
Size downloadDownloads : 1
Program licensing
Thank you for voting...

FASTGETGRID extracts values and formuals form all ...

fastgetgrid by Michael Robbins extracts values and formuals form all worksheets in a Microsoft Office Spreadsheet Object (OWC). It also provides the numerical and the string variables seperately
USAGE:
>> h = actxcontrol('OWC11. sheet. 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 1.0(h)
A =
Sheet1: [1x1 struct]
Sheet2: [1x1 struct]
Sheet3: [1x1 struct]
>> % LOOK AT SHEET 1
>> A. Sheet1
ans =
Formula: {8x3 cell}
Value: {8x3 cell}
String: {8x3 cell}
Number: {8x3 cell}
>> % LOOK AT THE FORMULAS IN SHEET 1
>> A. Sheet1. Formula
ans =
'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. Value
ans =
'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. String
ans =
'Maturity' '4/15/2009' []
'coupon' [] 'ANN'
'redemption' [] []
'Yield' [] []
[] [] []
'dirty price' [] []
'accrued interest' [] []
'clean price' [] []
>> % LOOK AT ONLY THE NUMBERS IN SHEET 1
>> A. Sheet1. Number
ans =
[] [] [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
Demands:
• MATLAB Release: R14SP3

FASTGETGRID 1.0 scripting tags: fastgetgrid, annredemption, price, get grid, nan, development tools, sheet, interest, clean, maturity, structsheet, fast get. What is new in FASTGETGRID 1.0 software script? - Unable to find FASTGETGRID 1.0 news. What is improvements are expecting? Newly-made FASTGETGRID 1.1 will be downloaded from here. You may download directly. Please write the reviews of the FASTGETGRID. License limitations are unspecified.