FASTGETGRID Matlab script

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
Operating system:
Windows / Linux / Mac OS / BSD / Solaris

DOWNLOAD FASTGETGRID NOW!

Before you Download
Scan your PC for Windows errors!

IE 10 for Windows 8, comes with Adobe Flash support

After criticism received at Metro version of Internet Explorer 10 , initially offered no support for Adobe Flash technology, Microsoft has taken measures to correct this problem by working directly with Adobe to integrate the necessary components into the

Posted on: 25 May 2012 10:36 by A. Brown

Windows 8: boot to fast to furious

Last year began to circulate on the Internet videos where Windows 8 systems boot in 7 seconds. Unfortunately, from this performance derives some problems.

Posted on: 25 May 2012 07:28 by A. Brown

Apple prepares iPhone 5 and iOS 6

New information coming from some sources close to Apple confirming that the Cupertino giant is testing two different models of iPhone, called internal iPhone5, 1 and iPhone 5.2. Apparently, both devices have a screen of 3.95 inches and a resolution of 113

Posted on: 24 May 2012 08:36 by A. Brown

Windows 8 estimates: 500 million users in 2013

Microsoft expects to launch a new wave of optimism with Windows 8. In a recent statement, Steve Ballmer, chief executive at Microsoft, estimates that Windows 8 will reach a total of about 500 million users by the end of 2013.

Posted on: 24 May 2012 08:25 by A. Brown