怎么用c读取excel中的数据,或者用MATLAB读取,2023行62列,要能执行的程序段,急 (c 读取excle数据库)

matlab:

A=xlsread(‘xls文件的路径’); %该excel数据唯旅即读入到矩阵A里了

A %显指清凳正御示读取的数据

matlab的枝首帮猛局数助里腊敏面有例子:

Example — Importing Data From an Excel Application

Assume that you have an Excel spreadsheet stocks.xls. This spreadsheet contains the prices of three stocks in row 3 (columns 1 through 3) and the number of shares of these stocks in rows 6 through 8 (column 2). Initiate conversation with Excel with the command

channel = ddeinit(‘excel’,’stocks.xls’)

DDE functions require the rxcy reference style for Excel worksheets. In Excel terminology the prices are in r3c1:r3c3 and the shares in r6c2:r8c2.

Request the prices from Excel:

prices = ddereq(channel,’r3c1:r3c3′)

prices =

…88

Next, request the number of shares of each stock:

shares = ddereq(channel, ‘r6c2:r8c2’)

shares =

.00

.00

.00


数据运维技术 » 怎么用c读取excel中的数据,或者用MATLAB读取,2023行62列,要能执行的程序段,急 (c 读取excle数据库)