-->

How to read all excel data with com server update

2019-09-05 23:11发布

问题:

for j=1:???
Loc = [func(j) '1:' func(j) '803'];

Result = get(Excel.Activesheet, 'Range', Loc);

Result.Select;

expResult = Excel.Selection.Value

func converts number to character of excel column. I want to read all data. If I write a number for ??? e.g 100 only Read 100 columns.