Publisher review:FASTGETGRID - Extracts values and formuals form all worksheets in a Microsoft Office Spreadsheet Object (OWC). 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: ยท MATLAB Release: R14SP3
FASTGETGRID is a Matlab script for Development Tools scripts design by Michael Robbins.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
FASTGETGRID - Extracts values and formuals form all worksheets in a Microsoft Office Spreadsheet Object (OWC).
Operating system:Windows / Linux / Mac OS / BSD / Solaris